.bail ON .mode table --wrap 0 SELECT datetime(value, 'unixepoch') 'DB version' FROM rb_db_lov WHERE key = 'data_timestamp'; +---------------------+ | DB version | +---------------------+ | 2026-06-07 10:17:03 | +---------------------+ -- Parts, which have multiple non-`NULL` image URLs, SELECT dense_rank() OVER (ORDER BY part_num, color_id) '#' , part_num, color_id, img_url, count(DISTINCT set_num) num_sets, set_num 'example set_num' FROM inventory_parts ip JOIN (SELECT part_num, color_id FROM inventory_parts GROUP BY 1, 2 HAVING count(DISTINCT img_url) > 1 -- use this to include null/non-null differences: -- HAVING count(DISTINCT coalesce(img_url, '!')) > 1 ) USING (part_num, color_id) JOIN inventories i ON i.id = ip.inventory_id GROUP BY part_num, color_id, img_url ORDER BY part_num, color_id, img_url; -- and which have both `NULL` and non-`NULL` image URLs. SELECT dense_rank() OVER (ORDER BY part_num, color_id) '#' , part_num, color_id, img_url, count(DISTINCT set_num) num_sets, set_num 'example set_num' FROM inventory_parts ip JOIN (SELECT part_num, color_id FROM inventory_parts GROUP BY 1, 2 HAVING count(img_url) > 0 AND count(*) > count(img_url) ) USING (part_num, color_id) JOIN inventories i ON i.id = ip.inventory_id GROUP BY part_num, color_id, img_url ORDER BY part_num, color_id, img_url; +----+-------------+----------+--------------------------------------------------------------+----------+-----------------+ | # | part_num | color_id | img_url | num_sets | example set_num | +----+-------------+----------+--------------------------------------------------------------+----------+-----------------+ | 1 | 14721 | 15 | | 1 | 10462-1 | | 1 | 14721 | 15 | https://cdn.rebrickable.com/media/parts/elements/6421340.jpg | 4 | 10986-1 | | 2 | 16375 | 322 | | 1 | 10462-1 | | 2 | 16375 | 322 | https://cdn.rebrickable.com/media/parts/elements/6082949.jpg | 6 | 10515-1 | | 3 | 18674 | 14 | | 1 | 6638187-1 | | 3 | 18674 | 14 | https://cdn.rebrickable.com/media/parts/elements/6299764.jpg | 67 | 41436-1 | | 4 | 24246 | 0 | | 1 | 6626040-1 | | 4 | 24246 | 0 | https://cdn.rebrickable.com/media/parts/elements/6256435.jpg | 184 | 75894-1 | | 5 | 24246 | 14 | | 1 | 6626040-1 | | 5 | 24246 | 14 | https://cdn.rebrickable.com/media/parts/elements/6300104.jpg | 51 | 41935-1 | | 6 | 24246 | 15 | | 1 | 6626040-1 | | 6 | 24246 | 15 | https://cdn.rebrickable.com/media/parts/elements/6131655.jpg | 278 | 41562-1 | | 7 | 24299 | 1 | | 1 | 6626040-1 | | 7 | 24299 | 1 | https://cdn.rebrickable.com/media/parts/elements/6189198.jpg | 30 | 75889-1 | | 8 | 24299 | 2 | | 1 | 6626040-1 | | 8 | 24299 | 2 | https://cdn.rebrickable.com/media/parts/elements/6385276.jpg | 22 | 21332-1 | | 9 | 24299 | 4 | | 1 | 6626040-1 | | 9 | 24299 | 4 | https://cdn.rebrickable.com/media/parts/elements/6141552.jpg | 77 | 75874-1 | | 10 | 24299 | 14 | | 1 | 6626040-1 | | 10 | 24299 | 14 | https://cdn.rebrickable.com/media/parts/elements/6132609.jpg | 29 | 75870-1 | | 11 | 24299 | 15 | | 1 | 6626040-1 | | 11 | 24299 | 15 | https://cdn.rebrickable.com/media/parts/elements/6132203.jpg | 149 | 75872-1 | | 12 | 24307 | 1 | | 1 | 6626040-1 | | 12 | 24307 | 1 | https://cdn.rebrickable.com/media/parts/elements/6189202.jpg | 35 | 75889-1 | | 13 | 24307 | 2 | | 1 | 6626040-1 | | 13 | 24307 | 2 | https://cdn.rebrickable.com/media/parts/elements/6385279.jpg | 28 | 21332-1 | | 14 | 24307 | 4 | | 1 | 6626040-1 | | 14 | 24307 | 4 | https://cdn.rebrickable.com/media/parts/elements/6141553.jpg | 78 | 75874-1 | | 15 | 24307 | 14 | | 1 | 6626040-1 | | 15 | 24307 | 14 | https://cdn.rebrickable.com/media/parts/elements/6132201.jpg | 29 | 75870-1 | | 16 | 24307 | 15 | | 1 | 6626040-1 | | 16 | 24307 | 15 | https://cdn.rebrickable.com/media/parts/elements/6132204.jpg | 151 | 75872-1 | | 17 | 24807 | 322 | | 1 | 10462-1 | | 17 | 24807 | 322 | https://cdn.rebrickable.com/media/parts/elements/6138094.jpg | 23 | 10806-1 | | 18 | 25269 | 0 | | 1 | 6626040-1 | | 18 | 25269 | 0 | https://cdn.rebrickable.com/media/parts/elements/6172383.jpg | 414 | 10255-1 | | 19 | 25269 | 1 | | 1 | 6626040-1 | | 19 | 25269 | 1 | https://cdn.rebrickable.com/media/parts/elements/6302961.jpg | 110 | 75551-1 | | 20 | 25269 | 2 | | 1 | 6626040-1 | | 20 | 25269 | 2 | https://cdn.rebrickable.com/media/parts/elements/6150607.jpg | 130 | 21133-1 | | 21 | 25269 | 4 | | 1 | 6626040-1 | | 21 | 25269 | 4 | https://cdn.rebrickable.com/media/parts/elements/6170390.jpg | 251 | 21306-1 | | 22 | 25269 | 14 | | 1 | 6626040-1 | | 22 | 25269 | 14 | https://cdn.rebrickable.com/media/parts/elements/6195183.jpg | 168 | 41597-1 | | 23 | 25269 | 15 | | 1 | 6626040-1 | | 23 | 25269 | 15 | https://cdn.rebrickable.com/media/parts/elements/6172366.jpg | 445 | 41232-1 | | 24 | 25269 | 288 | | 1 | 6638187-1 | | 24 | 25269 | 288 | https://cdn.rebrickable.com/media/parts/elements/6315608.jpg | 44 | 41917-1 | | 25 | 26604 | 71 | | 1 | 6638187-1 | | 25 | 26604 | 71 | https://cdn.rebrickable.com/media/parts/elements/6267495.jpg | 106 | 10269-1 | | 26 | 27383 | 15 | | 1 | 10462-1 | | 26 | 27383 | 15 | https://cdn.rebrickable.com/media/parts/elements/6210049.jpg | 11 | 10895-1 | | 27 | 27925 | 1 | | 1 | 6626040-1 | | 27 | 27925 | 1 | https://cdn.rebrickable.com/media/parts/elements/6194724.jpg | 35 | 31070-1 | | 28 | 27925 | 2 | | 1 | 6626040-1 | | 28 | 27925 | 2 | https://cdn.rebrickable.com/media/parts/elements/6365611.jpg | 23 | 71395-1 | | 29 | 27925 | 4 | | 1 | 6626040-1 | | 29 | 27925 | 4 | https://cdn.rebrickable.com/media/parts/elements/6310198.jpg | 60 | 70436-1 | | 30 | 27925 | 14 | | 1 | 6626040-1 | | 30 | 27925 | 14 | https://cdn.rebrickable.com/media/parts/elements/6195186.jpg | 63 | 76084-1 | | 31 | 27925 | 15 | | 1 | 6626040-1 | | 31 | 27925 | 15 | https://cdn.rebrickable.com/media/parts/elements/6172674.jpg | 171 | 75222-1 | | 32 | 27925 | 288 | | 1 | 6638187-1 | | 32 | 27925 | 288 | https://cdn.rebrickable.com/media/parts/elements/6426639.jpg | 11 | 75344-1 | | 33 | 3011 | 15 | | 1 | 10462-1 | | 33 | 3011 | 15 | https://cdn.rebrickable.com/media/parts/elements/301101.jpg | 110 | 5490-1 | | 34 | 3011 | 322 | | 1 | 10462-1 | | 34 | 3011 | 322 | https://cdn.rebrickable.com/media/parts/elements/6136982.jpg | 27 | 10818-1 | | 35 | 3011 | 323 | | 1 | 10462-1 | | 35 | 3011 | 323 | https://cdn.rebrickable.com/media/parts/elements/6294254.jpg | 19 | 10914-1 | | 36 | 3022 | 14 | | 1 | 6638187-1 | | 36 | 3022 | 14 | https://cdn.rebrickable.com/media/parts/elements/302224.jpg | 989 | 6378-1 | | 37 | 3023 | 1 | | 1 | 6626040-1 | | 37 | 3023 | 1 | https://cdn.rebrickable.com/media/parts/elements/302323.jpg | 1140 | 9385-1 | | 38 | 3023 | 2 | | 1 | 6626040-1 | | 38 | 3023 | 2 | https://cdn.rebrickable.com/media/parts/elements/302328.jpg | 690 | 76015-1 | | 39 | 3023 | 4 | | 1 | 6626040-1 | | 39 | 3023 | 4 | https://cdn.rebrickable.com/media/parts/elements/302321.jpg | 1913 | 6356-1 | | 40 | 3023 | 14 | | 2 | 6638187-1 | | 40 | 3023 | 14 | https://cdn.rebrickable.com/media/parts/elements/302324.jpg | 1373 | 9385-1 | | 41 | 3023 | 15 | | 1 | 6626040-1 | | 41 | 3023 | 15 | https://cdn.rebrickable.com/media/parts/elements/302301.jpg | 2586 | 3931-1 | | 42 | 3069b | 1 | | 1 | 6626040-1 | | 42 | 3069b | 1 | https://cdn.rebrickable.com/media/parts/elements/306923.jpg | 447 | 6913-1 | | 43 | 3069b | 2 | | 1 | 6626040-1 | | 43 | 3069b | 2 | https://cdn.rebrickable.com/media/parts/elements/306928.jpg | 256 | 8678-1 | | 44 | 3069b | 4 | | 1 | 6626040-1 | | 44 | 3069b | 4 | https://cdn.rebrickable.com/media/parts/elements/306921.jpg | 877 | 6356-1 | | 45 | 3069b | 14 | | 1 | 6626040-1 | | 45 | 3069b | 14 | https://cdn.rebrickable.com/media/parts/elements/306924.jpg | 688 | 6913-1 | | 46 | 3069b | 15 | | 1 | 6626040-1 | | 46 | 3069b | 15 | https://cdn.rebrickable.com/media/parts/elements/306901.jpg | 1557 | 850950-1 | | 47 | 3070b | 0 | | 1 | 6626040-1 | | 47 | 3070b | 0 | https://cdn.rebrickable.com/media/parts/elements/307026.jpg | 850 | 6386-1 | | 48 | 3070b | 14 | | 1 | 6626040-1 | | 48 | 3070b | 14 | https://cdn.rebrickable.com/media/parts/elements/307024.jpg | 382 | 1966-1 | | 49 | 3070b | 15 | | 1 | 6626040-1 | | 49 | 3070b | 15 | https://cdn.rebrickable.com/media/parts/elements/307001.jpg | 881 | 9385-1 | | 50 | 32028 | 14 | | 1 | 6638187-1 | | 50 | 32028 | 14 | https://cdn.rebrickable.com/media/parts/elements/4141630.jpg | 116 | 4309-1 | | 51 | 3437 | 3 | | 1 | 10462-1 | | 51 | 3437 | 3 | https://cdn.rebrickable.com/media/parts/elements/4185171.jpg | 6 | 3296-1 | | 52 | 3437 | 15 | | 1 | 10462-1 | | 52 | 3437 | 15 | https://cdn.rebrickable.com/media/parts/elements/343701.jpg | 186 | 5490-1 | | 53 | 3437 | 31 | | 1 | 10462-1 | | 53 | 3437 | 31 | https://cdn.rebrickable.com/media/parts/elements/4654789.jpg | 26 | 6151-1 | | 54 | 3437 | 41 | | 1 | 10462-1 | | 54 | 3437 | 41 | https://cdn.rebrickable.com/media/parts/elements/4158454.jpg | 75 | 10515-1 | | 55 | 3437 | 322 | | 1 | 10462-1 | | 55 | 3437 | 322 | https://cdn.rebrickable.com/media/parts/elements/6054619.jpg | 90 | 10580-1 | | 56 | 35735 | 226 | | 1 | 10462-1 | | 56 | 35735 | 226 | https://cdn.rebrickable.com/media/parts/elements/6295402.jpg | 5 | 10929-1 | | 57 | 3795 | 1 | | 1 | 6626040-1 | | 57 | 3795 | 1 | https://cdn.rebrickable.com/media/parts/elements/379523.jpg | 484 | 4411-1 | | 58 | 3795 | 2 | | 1 | 6626040-1 | | 58 | 3795 | 2 | https://cdn.rebrickable.com/media/parts/elements/379528.jpg | 310 | 3027-1 | | 59 | 3795 | 4 | | 1 | 6626040-1 | | 59 | 3795 | 4 | https://cdn.rebrickable.com/media/parts/elements/379521.jpg | 690 | 9385-1 | | 60 | 3795 | 14 | | 1 | 6626040-1 | | 60 | 3795 | 14 | https://cdn.rebrickable.com/media/parts/elements/379524.jpg | 478 | 7899-1 | | 61 | 3795 | 15 | | 1 | 6626040-1 | | 61 | 3795 | 15 | https://cdn.rebrickable.com/media/parts/elements/379501.jpg | 1052 | 3931-1 | | 62 | 4032a | 1 | | 1 | 6638187-1 | | 62 | 4032a | 1 | https://cdn.rebrickable.com/media/parts/elements/403223.jpg | 244 | 75060-1 | | 63 | 40666 | 322 | | 1 | 10462-1 | | 63 | 40666 | 322 | https://cdn.rebrickable.com/media/parts/elements/6211342.jpg | 33 | 10863-1 | | 64 | 40666 | 323 | | 1 | 10462-1 | | 64 | 40666 | 323 | https://cdn.rebrickable.com/media/parts/elements/6296140.jpg | 19 | 10913-1 | | 65 | 41417 | 47 | | 1 | 10462-1 | | 65 | 41417 | 47 | https://cdn.rebrickable.com/media/parts/elements/6258910.jpg | 2 | 10899-1 | | 66 | 41539 | 27 | | 1 | 6626040-1 | | 66 | 41539 | 27 | https://cdn.rebrickable.com/media/parts/elements/6210657.jpg | 16 | 41340-1 | | 67 | 4733 | 0 | | 1 | 6638187-1 | | 67 | 4733 | 0 | https://cdn.rebrickable.com/media/parts/elements/473326.jpg | 360 | 7899-1 | | 68 | 52388 | 15 | | 1 | 10462-1 | | 68 | 52388 | 15 | https://cdn.rebrickable.com/media/parts/elements/6263019.jpg | 3 | 10899-1 | | 69 | 53048pr0001 | 323 | | 1 | 10462-1 | | 69 | 53048pr0001 | 323 | https://cdn.rebrickable.com/media/parts/elements/6545872.jpg | 1 | 10455-1 | | 70 | 5404 | 14 | | 1 | 6638187-1 | | 70 | 5404 | 14 | https://cdn.rebrickable.com/media/parts/elements/6535750.jpg | 5 | 42205-1 | | 71 | 60474 | 14 | | 1 | 6638187-1 | | 71 | 60474 | 14 | https://cdn.rebrickable.com/media/parts/elements/4515349.jpg | 126 | 41562-1 | | 72 | 61649 | 15 | | 1 | 10462-1 | | 72 | 61649 | 15 | https://cdn.rebrickable.com/media/parts/elements/4622476.jpg | 27 | 10803-1 | | 73 | 6474 | 41 | | 1 | 10462-1 | | 73 | 6474 | 41 | https://cdn.rebrickable.com/media/parts/elements/6295975.jpg | 6 | 10920-1 | | 74 | 65273 | 30 | | 1 | 10462-1 | | 74 | 65273 | 30 | https://cdn.rebrickable.com/media/parts/elements/6530487.jpg | 3 | 10449-1 | | 75 | 67329 | 14 | | 1 | 6638187-1 | | 75 | 67329 | 14 | https://cdn.rebrickable.com/media/parts/elements/6310247.jpg | 73 | 71369-1 | | 76 | 71752 | 19 | | 1 | 6638187-1 | | 76 | 71752 | 19 | https://cdn.rebrickable.com/media/parts/elements/6330903.jpg | 119 | 80023-1 | | 77 | 76371 | 323 | | 1 | 10462-1 | | 77 | 76371 | 323 | https://cdn.rebrickable.com/media/parts/elements/6294211.jpg | 12 | 10913-1 | | 78 | 84195 | 15 | | 1 | 10462-1 | | 78 | 84195 | 15 | https://cdn.rebrickable.com/media/parts/elements/6535952.jpg | 1 | 10455-1 | | 79 | 85984 | 14 | | 1 | 6638187-1 | | 79 | 85984 | 14 | https://cdn.rebrickable.com/media/parts/elements/4550348.jpg | 274 | 60018-1 | | 80 | 86996 | 19 | | 1 | 6638187-1 | | 80 | 86996 | 19 | https://cdn.rebrickable.com/media/parts/elements/6458392.jpg | 55 | 910032-1 | | 81 | 87994 | 15 | | 1 | 6638187-1 | | 81 | 87994 | 15 | https://cdn.rebrickable.com/media/parts/elements/6093526.jpg | 160 | 41067-1 | | 82 | 90265 | 322 | | 1 | 10462-1 | | 82 | 90265 | 322 | https://cdn.rebrickable.com/media/parts/elements/6185059.jpg | 9 | 10844-1 | | 83 | 98223 | 323 | | 1 | 10462-1 | | 83 | 98223 | 323 | https://cdn.rebrickable.com/media/parts/elements/6296047.jpg | 2 | 10914-1 | | 84 | 98233 | 15 | | 1 | 10462-1 | | 84 | 98233 | 15 | https://cdn.rebrickable.com/media/parts/elements/6059082.jpg | 40 | 10803-1 | | 85 | 98252 | 5 | | 1 | 10462-1 | | 85 | 98252 | 5 | https://cdn.rebrickable.com/media/parts/elements/4654903.jpg | 14 | 6154-1 | | 86 | 99771pr0006 | 322 | | 1 | 10462-1 | | 86 | 99771pr0006 | 322 | https://cdn.rebrickable.com/media/parts/elements/6546204.jpg | 1 | 10455-1 | +----+-------------+----------+--------------------------------------------------------------+----------+-----------------+