.bail ON .mode table --wrap 0 SELECT datetime(value, 'unixepoch') 'DB version' FROM rb_db_lov WHERE key = 'data_timestamp'; +---------------------+ | DB version | +---------------------+ | 2025-11-21 07:56:07 | +---------------------+ -- 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 | 11090 | 70 | | 1 | 6602967-1 | | 1 | 11090 | 70 | https://cdn.rebrickable.com/media/parts/elements/6080355.jpg | 124 | 70231-1 | | 2 | 11211 | 71 | | 1 | 6602967-1 | | 2 | 11211 | 71 | https://cdn.rebrickable.com/media/parts/elements/6015344.jpg | 597 | 75060-1 | | 3 | 11609 | 191 | | 1 | 6602967-1 | | 3 | 11609 | 191 | https://cdn.rebrickable.com/media/parts/elements/6017001.jpg | 100 | 30286-1 | | 4 | 14769 | 0 | | 1 | 6602967-1 | | 4 | 14769 | 0 | https://cdn.rebrickable.com/media/parts/elements/6070695.jpg | 217 | 41135-1 | | 5 | 14769 | 15 | | 1 | 6602967-1 | | 5 | 14769 | 15 | https://cdn.rebrickable.com/media/parts/elements/6044691.jpg | 299 | 21104-1 | | 6 | 15573 | 4 | | 1 | 6602967-1 | | 6 | 15573 | 4 | https://cdn.rebrickable.com/media/parts/elements/6092565.jpg | 340 | 70600-1 | | 7 | 15573 | 70 | | 1 | 6602967-1 | | 7 | 15573 | 70 | https://cdn.rebrickable.com/media/parts/elements/6092590.jpg | 424 | 21114-1 | | 8 | 15712 | 15 | | 1 | 6602967-1 | | 8 | 15712 | 15 | https://cdn.rebrickable.com/media/parts/elements/6054551.jpg | 326 | 10255-1 | | 9 | 1745 | 0 | | 1 | 6602967-1 | | 9 | 1745 | 0 | https://cdn.rebrickable.com/media/parts/elements/6438919.jpg | 58 | 76916-1 | | 10 | 1745 | 15 | | 1 | 6602967-1 | | 10 | 1745 | 15 | https://cdn.rebrickable.com/media/parts/elements/6462354.jpg | 30 | 40627-1 | | 11 | 17485 | 0 | | 1 | 6602967-1 | | 11 | 17485 | 0 | https://cdn.rebrickable.com/media/parts/elements/6195273.jpg | 35 | 31096-1 | | 12 | 20482 | 15 | | 1 | 6602967-1 | | 12 | 20482 | 15 | https://cdn.rebrickable.com/media/parts/elements/6178492.jpg | 256 | 41492-1 | | 13 | 22484 | 0 | | 1 | 6602967-1 | | 13 | 22484 | 0 | https://cdn.rebrickable.com/media/parts/elements/6509664.jpg | 15 | 21350-1 | | 14 | 22885 | 15 | | 1 | 6602967-1 | | 14 | 22885 | 15 | https://cdn.rebrickable.com/media/parts/elements/6218823.jpg | 227 | 10261-1 | | 15 | 24246 | 15 | | 1 | 6602967-1 | | 15 | 24246 | 15 | https://cdn.rebrickable.com/media/parts/elements/6131655.jpg | 251 | 41562-1 | | 16 | 2540 | 15 | | 1 | 6602967-1 | | 16 | 2540 | 15 | https://cdn.rebrickable.com/media/parts/elements/254001.jpg | 289 | 71217-1 | | 17 | 2756pr0019 | 15 | | 2 | 1017-1 | | 17 | 2756pr0019 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 18 | 2756pr0021 | 15 | | 2 | 1017-1 | | 18 | 2756pr0021 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 19 | 2756pr0023 | 15 | | 2 | 1017-1 | | 19 | 2756pr0023 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 20 | 2756pr0025 | 15 | | 2 | 1017-1 | | 20 | 2756pr0025 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 21 | 2756pr0027 | 15 | | 2 | 1017-1 | | 21 | 2756pr0027 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 22 | 2756pr0029 | 15 | | 2 | 1017-1 | | 22 | 2756pr0029 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 23 | 2756pr0030 | 15 | | 1 | 1017-1 | | 23 | 2756pr0030 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 24 | 2756pr0031 | 15 | | 2 | 1017-1 | | 24 | 2756pr0031 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 25 | 2756pr0032 | 15 | | 1 | 1017-1 | | 25 | 2756pr0032 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 26 | 2756pr0033 | 15 | | 2 | 1017-1 | | 26 | 2756pr0033 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 27 | 2756pr0034 | 15 | | 1 | 1017-1 | | 27 | 2756pr0034 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 28 | 2756pr0035 | 15 | | 2 | 1017-1 | | 28 | 2756pr0035 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 29 | 2756pr0036 | 15 | | 1 | 1017-1 | | 29 | 2756pr0036 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 30 | 2756pr0037 | 15 | | 2 | 1017-1 | | 30 | 2756pr0037 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 31 | 2756pr0038 | 15 | | 1 | 1017-1 | | 31 | 2756pr0038 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 32 | 2756pr0039 | 15 | | 2 | 1017-1 | | 32 | 2756pr0039 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 33 | 2756pr0040 | 15 | | 1 | 1017-1 | | 33 | 2756pr0040 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 34 | 2756pr0041 | 15 | | 2 | 1017-1 | | 34 | 2756pr0041 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 35 | 2756pr0042 | 15 | | 1 | 1017-1 | | 35 | 2756pr0042 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 36 | 2756pr0043 | 15 | | 2 | 1017-1 | | 36 | 2756pr0043 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 37 | 2756pr0044 | 15 | | 1 | 1017-1 | | 37 | 2756pr0044 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 38 | 2756pr0045 | 15 | | 2 | 1017-1 | | 38 | 2756pr0045 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 39 | 2756pr0046 | 15 | | 1 | 1017-1 | | 39 | 2756pr0046 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 40 | 2756pr0047 | 15 | | 2 | 1017-1 | | 40 | 2756pr0047 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 41 | 2756pr0048 | 15 | | 1 | 1017-1 | | 41 | 2756pr0048 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 42 | 2756pr0049 | 15 | | 2 | 1017-1 | | 42 | 2756pr0049 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 43 | 2756pr0051 | 15 | | 2 | 1017-1 | | 43 | 2756pr0051 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 44 | 2756pr0052 | 15 | | 1 | 1017-1 | | 44 | 2756pr0052 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 45 | 2756pr0053 | 15 | | 2 | 1017-1 | | 45 | 2756pr0053 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 46 | 2756pr0054 | 15 | | 1 | 1017-1 | | 46 | 2756pr0054 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 47 | 2756pr0055 | 15 | | 2 | 1017-1 | | 47 | 2756pr0055 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 48 | 2756pr0056 | 15 | | 1 | 1017-1 | | 48 | 2756pr0056 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 49 | 2756pr0057 | 15 | | 2 | 1017-1 | | 49 | 2756pr0057 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 50 | 2756pr0058 | 15 | | 1 | 1017-1 | | 50 | 2756pr0058 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 51 | 2756pr0059 | 15 | | 2 | 1017-1 | | 51 | 2756pr0059 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 52 | 2756pr0060 | 15 | | 1 | 1017-1 | | 52 | 2756pr0060 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 53 | 2756pr0061 | 15 | | 2 | 1017-1 | | 53 | 2756pr0061 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 54 | 2756pr0062 | 15 | | 1 | 1017-1 | | 54 | 2756pr0062 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 55 | 2756pr0064 | 15 | | 1 | 1017-1 | | 55 | 2756pr0064 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 56 | 2756pr0065 | 15 | | 2 | 1017-1 | | 56 | 2756pr0065 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 57 | 2756pr0066 | 15 | | 1 | 1017-1 | | 57 | 2756pr0066 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 58 | 2756pr0067 | 15 | | 2 | 1017-1 | | 58 | 2756pr0067 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 59 | 2756pr0069 | 15 | | 2 | 1017-1 | | 59 | 2756pr0069 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 60 | 27925 | 0 | | 1 | 6602967-1 | | 60 | 27925 | 0 | https://cdn.rebrickable.com/media/parts/elements/6191630.jpg | 117 | 41635-1 | | 61 | 2877 | 19 | | 1 | 6602967-1 | | 61 | 2877 | 19 | https://cdn.rebrickable.com/media/parts/elements/4655900.jpg | 55 | 30197-1 | | 62 | 3020 | 14 | | 1 | 6602967-1 | | 62 | 3020 | 14 | https://cdn.rebrickable.com/media/parts/elements/302024.jpg | 890 | 6435-1 | | 63 | 3020 | 15 | | 1 | 6602967-1 | | 63 | 3020 | 15 | https://cdn.rebrickable.com/media/parts/elements/302001.jpg | 1618 | 3931-1 | | 64 | 3021 | 15 | | 1 | 6602967-1 | | 64 | 3021 | 15 | https://cdn.rebrickable.com/media/parts/elements/302101.jpg | 1265 | 850950-1 | | 65 | 3022 | 4 | | 1 | 6602967-1 | | 65 | 3022 | 4 | https://cdn.rebrickable.com/media/parts/elements/302221.jpg | 1390 | 6356-1 | | 66 | 3022 | 71 | | 1 | 6602967-1 | | 66 | 3022 | 71 | https://cdn.rebrickable.com/media/parts/elements/4211397.jpg | 1262 | 75094-1 | | 67 | 3023 | 4 | | 1 | 6602967-1 | | 67 | 3023 | 4 | https://cdn.rebrickable.com/media/parts/elements/302321.jpg | 1824 | 6356-1 | | 68 | 3023 | 15 | | 1 | 6602967-1 | | 68 | 3023 | 15 | https://cdn.rebrickable.com/media/parts/elements/302301.jpg | 2439 | 3931-1 | | 69 | 3024 | 15 | | 1 | 6602967-1 | | 69 | 3024 | 15 | https://cdn.rebrickable.com/media/parts/elements/302401.jpg | 1423 | 850950-1 | | 70 | 33078 | 0 | | 1 | 6602967-1 | | 70 | 33078 | 0 | https://cdn.rebrickable.com/media/parts/elements/4613736.jpg | 45 | 21308-1 | | 71 | 33172 | 25 | | 1 | 6602967-1 | | 71 | 33172 | 25 | https://cdn.rebrickable.com/media/parts/elements/4119478.jpg | 264 | 41135-1 | | 72 | 3386 | 15 | | 1 | 6602967-1 | | 72 | 3386 | 15 | https://cdn.rebrickable.com/media/parts/elements/6446788.jpg | 63 | 71424-1 | | 73 | 34103 | 15 | | 1 | 6602967-1 | | 73 | 34103 | 15 | https://cdn.rebrickable.com/media/parts/elements/6195371.jpg | 152 | 41615-1 | | 74 | 3484 | 70 | | 1 | 6602967-1 | | 74 | 3484 | 70 | https://cdn.rebrickable.com/media/parts/elements/6439053.jpg | 52 | 21341-1 | | 75 | 36841 | 71 | | 1 | 6602967-1 | | 75 | 36841 | 71 | https://cdn.rebrickable.com/media/parts/elements/6227012.jpg | 269 | 70657-1 | | 76 | 3710 | 70 | | 1 | 6602967-1 | | 76 | 3710 | 70 | https://cdn.rebrickable.com/media/parts/elements/4211190.jpg | 758 | 9385-1 | | 77 | 3957b | 70 | | 1 | 6602967-1 | | 77 | 3957b | 70 | https://cdn.rebrickable.com/media/parts/elements/4538252.jpg | 131 | 561508-1 | | 78 | 39739 | 5 | | 1 | 6602967-1 | | 78 | 39739 | 5 | https://cdn.rebrickable.com/media/parts/elements/6256130.jpg | 57 | 70830-1 | | 79 | 39739 | 29 | | 1 | 6602967-1 | | 79 | 39739 | 29 | https://cdn.rebrickable.com/media/parts/elements/6275466.jpg | 22 | 40413-1 | | 80 | 4032a | 1 | | 1 | 6602967-1 | | 80 | 4032a | 1 | https://cdn.rebrickable.com/media/parts/elements/403223.jpg | 231 | 75060-1 | | 81 | 4032a | 4 | | 1 | 6602967-1 | | 81 | 4032a | 4 | https://cdn.rebrickable.com/media/parts/elements/403221.jpg | 500 | 6424-1 | | 82 | 4032a | 27 | | 1 | 6602967-1 | | 82 | 4032a | 27 | https://cdn.rebrickable.com/media/parts/elements/4213047.jpg | 69 | 7593-1 | | 83 | 4367 | 5 | | 1 | 6602967-1 | | 83 | 4367 | 5 | https://cdn.rebrickable.com/media/parts/elements/6452523.jpg | 36 | 77050-1 | | 84 | 4367 | 10 | | 1 | 6602967-1 | | 84 | 4367 | 10 | https://cdn.rebrickable.com/media/parts/elements/6488792.jpg | 13 | 76962-1 | | 85 | 5841 | 15 | | 1 | 6602967-1 | | 85 | 5841 | 15 | https://cdn.rebrickable.com/media/parts/elements/6519988.jpg | 28 | 80065-1 | | 86 | 5846 | 15 | | 1 | 6602967-1 | | 86 | 5846 | 15 | https://cdn.rebrickable.com/media/parts/elements/6519991.jpg | 5 | 40824-1 | | 87 | 5852 | 15 | | 1 | 6602967-1 | | 87 | 5852 | 15 | https://cdn.rebrickable.com/media/parts/elements/6516468.jpg | 13 | 60451-1 | | 88 | 60470b | 4 | | 1 | 6602967-1 | | 88 | 60470b | 4 | https://cdn.rebrickable.com/media/parts/elements/6360036.jpg | 145 | 70812-1 | | 89 | 60474 | 0 | | 1 | 6602967-1 | | 89 | 60474 | 0 | https://cdn.rebrickable.com/media/parts/elements/4515350.jpg | 290 | 9385-1 | | 90 | 60474 | 15 | | 1 | 6602967-1 | | 90 | 60474 | 15 | https://cdn.rebrickable.com/media/parts/elements/4515347.jpg | 239 | 10189-1 | | 91 | 60478 | 4 | | 1 | 6602967-1 | | 91 | 60478 | 4 | https://cdn.rebrickable.com/media/parts/elements/4515365.jpg | 132 | 7958-1 | | 92 | 89678 | 72 | | 1 | 6602967-1 | | 92 | 89678 | 72 | https://cdn.rebrickable.com/media/parts/elements/6395635.jpg | 281 | 10311-1 | | 93 | 98138 | 0 | | 1 | 6602967-1 | | 93 | 98138 | 0 | https://cdn.rebrickable.com/media/parts/elements/6284070.jpg | 370 | 60139-1 | | 94 | 98138 | 2 | | 1 | 6602967-1 | | 94 | 98138 | 2 | https://cdn.rebrickable.com/media/parts/elements/6396247.jpg | 17 | 21332-1 | | 95 | 98138 | 85 | | 1 | 6602967-1 | | 95 | 98138 | 85 | https://cdn.rebrickable.com/media/parts/elements/6476247.jpg | 5 | 43248-1 | | 96 | 98138 | 320 | | 1 | 6602967-1 | | 96 | 98138 | 320 | https://cdn.rebrickable.com/media/parts/elements/6028132.jpg | 55 | 75910-1 | | 97 | 98138pr9977 | 15 | | 1 | 6602967-1 | | 97 | 98138pr9977 | 15 | https://cdn.rebrickable.com/media/parts/elements/6433502.jpg | 16 | 11027-1 | | 98 | 99207 | 15 | | 1 | 6602967-1 | | 98 | 99207 | 15 | https://cdn.rebrickable.com/media/parts/elements/6097637.jpg | 260 | 75876-1 | +----+-------------+----------+--------------------------------------------------------------+----------+-----------------+