.bail ON .mode table --wrap 0 SELECT datetime(value, 'unixepoch') 'DB version' FROM rb_db_lov WHERE key = 'data_timestamp'; +---------------------+ | DB version | +---------------------+ | 2025-11-15 07:55:58 | +---------------------+ -- 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 | 13547 | 0 | | 1 | 6596091-1 | | 1 | 13547 | 0 | https://cdn.rebrickable.com/media/parts/elements/6039869.jpg | 172 | 75059-1 | | 2 | 14719 | 14 | | 1 | 6596091-1 | | 2 | 14719 | 14 | https://cdn.rebrickable.com/media/parts/elements/6308099.jpg | 41 | 75551-1 | | 3 | 14769 | 14 | | 1 | 6596091-1 | | 3 | 14769 | 14 | https://cdn.rebrickable.com/media/parts/elements/6078279.jpg | 131 | 60096-1 | | 4 | 15533 | 72 | | 1 | 6596091-1 | | 4 | 15533 | 72 | https://cdn.rebrickable.com/media/parts/elements/6055310.jpg | 44 | 10760-1 | | 5 | 1748 | 0 | | 1 | 6596091-1 | | 5 | 1748 | 0 | https://cdn.rebrickable.com/media/parts/elements/6420852.jpg | 63 | 60357-1 | | 6 | 1751pr9999 | 14 | | 1 | 6596091-1 | | 6 | 1751pr9999 | 14 | https://cdn.rebrickable.com/media/parts/elements/6480862.jpg | 9 | 60440-1 | | 7 | 18980 | 4 | | 1 | 6596091-1 | | 7 | 18980 | 4 | https://cdn.rebrickable.com/media/parts/elements/6108802.jpg | 57 | 41235-1 | | 8 | 1927 | 4 | | 1 | 6596091-1 | | 8 | 1927 | 4 | https://cdn.rebrickable.com/media/parts/elements/6416443.jpg | 24 | 40536-1 | | 9 | 1927 | 14 | | 1 | 6596091-1 | | 9 | 1927 | 14 | https://cdn.rebrickable.com/media/parts/elements/6416522.jpg | 18 | 910009-1 | | 10 | 20310 | 72 | | 1 | 6596091-1 | | 10 | 20310 | 72 | https://cdn.rebrickable.com/media/parts/elements/6388131.jpg | 16 | 10305-1 | | 11 | 20482 | 4 | | 1 | 6596091-1 | | 11 | 20482 | 4 | https://cdn.rebrickable.com/media/parts/elements/6188827.jpg | 151 | 75529-1 | | 12 | 22885 | 14 | | 1 | 6596091-1 | | 12 | 22885 | 14 | https://cdn.rebrickable.com/media/parts/elements/6313592.jpg | 54 | 43179-1 | | 13 | 2445 | 0 | | 1 | 6596091-1 | | 13 | 2445 | 0 | https://cdn.rebrickable.com/media/parts/elements/244526.jpg | 478 | 4768-2 | | 14 | 2453b | 15 | | 1 | 6596091-1 | | 14 | 2453b | 15 | https://cdn.rebrickable.com/media/parts/elements/245301.jpg | 179 | 41135-1 | | 15 | 2454b | 15 | | 1 | 6596091-1 | | 15 | 2454b | 15 | https://cdn.rebrickable.com/media/parts/elements/245401.jpg | 170 | 75094-1 | | 16 | 2456 | 14 | | 1 | 6596091-1 | | 16 | 2456 | 14 | https://cdn.rebrickable.com/media/parts/elements/245624.jpg | 297 | 4411-1 | | 17 | 25269 | 1 | | 1 | 6596091-1 | | 17 | 25269 | 1 | https://cdn.rebrickable.com/media/parts/elements/6302961.jpg | 83 | 75551-1 | | 18 | 25269 | 2 | | 1 | 6596091-1 | | 18 | 25269 | 2 | https://cdn.rebrickable.com/media/parts/elements/6150607.jpg | 103 | 21133-1 | | 19 | 25269 | 4 | | 1 | 6596091-1 | | 19 | 25269 | 4 | https://cdn.rebrickable.com/media/parts/elements/6170390.jpg | 201 | 21306-1 | | 20 | 25269 | 14 | | 1 | 6596091-1 | | 20 | 25269 | 14 | https://cdn.rebrickable.com/media/parts/elements/6195183.jpg | 136 | 41597-1 | | 21 | 2653 | 0 | | 1 | 6596091-1 | | 21 | 2653 | 0 | https://cdn.rebrickable.com/media/parts/elements/265326.jpg | 172 | 5974-1 | | 22 | 26603 | 0 | | 1 | 6596091-1 | | 22 | 26603 | 0 | https://cdn.rebrickable.com/media/parts/elements/6162892.jpg | 313 | 41230-1 | | 23 | 2756pr0019 | 15 | | 2 | 1017-1 | | 23 | 2756pr0019 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 24 | 2756pr0021 | 15 | | 2 | 1017-1 | | 24 | 2756pr0021 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 25 | 2756pr0023 | 15 | | 2 | 1017-1 | | 25 | 2756pr0023 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 26 | 2756pr0025 | 15 | | 2 | 1017-1 | | 26 | 2756pr0025 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 27 | 2756pr0027 | 15 | | 2 | 1017-1 | | 27 | 2756pr0027 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 28 | 2756pr0029 | 15 | | 2 | 1017-1 | | 28 | 2756pr0029 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 29 | 2756pr0030 | 15 | | 1 | 1017-1 | | 29 | 2756pr0030 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 30 | 2756pr0031 | 15 | | 2 | 1017-1 | | 30 | 2756pr0031 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 31 | 2756pr0032 | 15 | | 1 | 1017-1 | | 31 | 2756pr0032 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 32 | 2756pr0033 | 15 | | 2 | 1017-1 | | 32 | 2756pr0033 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 33 | 2756pr0034 | 15 | | 1 | 1017-1 | | 33 | 2756pr0034 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 34 | 2756pr0035 | 15 | | 2 | 1017-1 | | 34 | 2756pr0035 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 35 | 2756pr0036 | 15 | | 1 | 1017-1 | | 35 | 2756pr0036 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 36 | 2756pr0037 | 15 | | 2 | 1017-1 | | 36 | 2756pr0037 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 37 | 2756pr0038 | 15 | | 1 | 1017-1 | | 37 | 2756pr0038 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 38 | 2756pr0039 | 15 | | 2 | 1017-1 | | 38 | 2756pr0039 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 39 | 2756pr0040 | 15 | | 1 | 1017-1 | | 39 | 2756pr0040 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 40 | 2756pr0041 | 15 | | 2 | 1017-1 | | 40 | 2756pr0041 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 41 | 2756pr0042 | 15 | | 1 | 1017-1 | | 41 | 2756pr0042 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 42 | 2756pr0043 | 15 | | 2 | 1017-1 | | 42 | 2756pr0043 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 43 | 2756pr0044 | 15 | | 1 | 1017-1 | | 43 | 2756pr0044 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 44 | 2756pr0045 | 15 | | 2 | 1017-1 | | 44 | 2756pr0045 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 45 | 2756pr0046 | 15 | | 1 | 1017-1 | | 45 | 2756pr0046 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 46 | 2756pr0047 | 15 | | 2 | 1017-1 | | 46 | 2756pr0047 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 47 | 2756pr0048 | 15 | | 1 | 1017-1 | | 47 | 2756pr0048 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 48 | 2756pr0049 | 15 | | 2 | 1017-1 | | 48 | 2756pr0049 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 49 | 2756pr0051 | 15 | | 2 | 1017-1 | | 49 | 2756pr0051 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 50 | 2756pr0052 | 15 | | 1 | 1017-1 | | 50 | 2756pr0052 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 51 | 2756pr0053 | 15 | | 2 | 1017-1 | | 51 | 2756pr0053 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 52 | 2756pr0054 | 15 | | 1 | 1017-1 | | 52 | 2756pr0054 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 53 | 2756pr0055 | 15 | | 2 | 1017-1 | | 53 | 2756pr0055 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 54 | 2756pr0056 | 15 | | 1 | 1017-1 | | 54 | 2756pr0056 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 55 | 2756pr0057 | 15 | | 2 | 1017-1 | | 55 | 2756pr0057 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 56 | 2756pr0058 | 15 | | 1 | 1017-1 | | 56 | 2756pr0058 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 57 | 2756pr0059 | 15 | | 2 | 1017-1 | | 57 | 2756pr0059 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 58 | 2756pr0060 | 15 | | 1 | 1017-1 | | 58 | 2756pr0060 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 59 | 2756pr0061 | 15 | | 2 | 1017-1 | | 59 | 2756pr0061 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 60 | 2756pr0062 | 15 | | 1 | 1017-1 | | 60 | 2756pr0062 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 61 | 2756pr0064 | 15 | | 1 | 1017-1 | | 61 | 2756pr0064 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 62 | 2756pr0065 | 15 | | 2 | 1017-1 | | 62 | 2756pr0065 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 63 | 2756pr0066 | 15 | | 1 | 1017-1 | | 63 | 2756pr0066 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 64 | 2756pr0067 | 15 | | 2 | 1017-1 | | 64 | 2756pr0067 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 65 | 2756pr0069 | 15 | | 2 | 1017-1 | | 65 | 2756pr0069 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 66 | 29119 | 14 | | 1 | 6596091-1 | | 66 | 29119 | 14 | https://cdn.rebrickable.com/media/parts/elements/6289743.jpg | 30 | 76897-1 | | 67 | 29120 | 4 | | 1 | 6596091-1 | | 67 | 29120 | 4 | https://cdn.rebrickable.com/media/parts/elements/6177505.jpg | 127 | 75882-1 | | 68 | 29120 | 14 | | 1 | 6596091-1 | | 68 | 29120 | 14 | https://cdn.rebrickable.com/media/parts/elements/6289740.jpg | 29 | 76897-1 | | 69 | 3005 | 0 | | 1 | 6596091-1 | | 69 | 3005 | 0 | https://cdn.rebrickable.com/media/parts/elements/300526.jpg | 1154 | 6378-1 | | 70 | 3009 | 0 | | 1 | 6596091-1 | | 70 | 3009 | 0 | https://cdn.rebrickable.com/media/parts/elements/300926.jpg | 698 | 6378-1 | | 71 | 3009 | 14 | | 1 | 6596091-1 | | 71 | 3009 | 14 | https://cdn.rebrickable.com/media/parts/elements/300924.jpg | 484 | 4888-1 | | 72 | 3020 | 14 | | 1 | 6596091-1 | | 72 | 3020 | 14 | https://cdn.rebrickable.com/media/parts/elements/302024.jpg | 888 | 6435-1 | | 73 | 3023 | 14 | | 1 | 6596091-1 | | 73 | 3023 | 14 | https://cdn.rebrickable.com/media/parts/elements/302324.jpg | 1291 | 9385-1 | | 74 | 3031 | 0 | | 1 | 6596091-1 | | 74 | 3031 | 0 | https://cdn.rebrickable.com/media/parts/elements/303126.jpg | 768 | 70812-1 | | 75 | 3034 | 4 | | 1 | 6596091-1 | | 75 | 3034 | 4 | https://cdn.rebrickable.com/media/parts/elements/303421.jpg | 456 | 9385-1 | | 76 | 30340 | 0 | | 1 | 6596091-1 | | 76 | 30340 | 0 | https://cdn.rebrickable.com/media/parts/elements/4203611.jpg | 24 | 10255-1 | | 77 | 3036 | 72 | | 1 | 6596091-1 | | 77 | 3036 | 72 | https://cdn.rebrickable.com/media/parts/elements/4210794.jpg | 274 | 20208-1 | | 78 | 3068b | 14 | | 1 | 6596091-1 | | 78 | 3068b | 14 | https://cdn.rebrickable.com/media/parts/elements/306824.jpg | 348 | 9385-1 | | 79 | 3070b | 4 | | 1 | 6596091-1 | | 79 | 3070b | 4 | https://cdn.rebrickable.com/media/parts/elements/307021.jpg | 559 | 8223-1 | | 80 | 32028 | 0 | | 1 | 6596091-1 | | 80 | 32028 | 0 | https://cdn.rebrickable.com/media/parts/elements/4107761.jpg | 421 | 4748-1 | | 81 | 3622 | 14 | | 1 | 6596091-1 | | 81 | 3622 | 14 | https://cdn.rebrickable.com/media/parts/elements/362224.jpg | 419 | 525-1 | | 82 | 3623 | 14 | | 1 | 6596091-1 | | 82 | 3623 | 14 | https://cdn.rebrickable.com/media/parts/elements/362324.jpg | 462 | 10189-1 | | 83 | 3666 | 0 | | 1 | 6596091-1 | | 83 | 3666 | 0 | https://cdn.rebrickable.com/media/parts/elements/366626.jpg | 1450 | 75060-1 | | 84 | 3666 | 4 | | 1 | 6596091-1 | | 84 | 3666 | 4 | https://cdn.rebrickable.com/media/parts/elements/366621.jpg | 683 | 6356-1 | | 85 | 3710 | 0 | | 1 | 6596091-1 | | 85 | 3710 | 0 | https://cdn.rebrickable.com/media/parts/elements/371026.jpg | 2017 | 30277-1 | | 86 | 4032a | 14 | | 1 | 6596091-1 | | 86 | 4032a | 14 | https://cdn.rebrickable.com/media/parts/elements/403224.jpg | 390 | 561508-1 | | 87 | 43888 | 15 | | 1 | 6596091-1 | | 87 | 43888 | 15 | https://cdn.rebrickable.com/media/parts/elements/6073345.jpg | 56 | 21020-1 | | 88 | 4495b | 4 | | 1 | 6596091-1 | | 88 | 4495b | 4 | https://cdn.rebrickable.com/media/parts/elements/449521.jpg | 151 | 7953-1 | | 89 | 4740 | 71 | | 1 | 6596091-1 | | 89 | 4740 | 71 | https://cdn.rebrickable.com/media/parts/elements/4211512.jpg | 348 | 4758-1 | | 90 | 48336 | 15 | | 1 | 6596091-1 | | 90 | 48336 | 15 | https://cdn.rebrickable.com/media/parts/elements/4222017.jpg | 315 | 8103-1 | | 91 | 60479 | 0 | | 1 | 6596091-1 | | 91 | 60479 | 0 | https://cdn.rebrickable.com/media/parts/elements/4514845.jpg | 306 | 75059-1 | | 92 | 60592 | 0 | | 1 | 6596091-1 | | 92 | 60592 | 0 | https://cdn.rebrickable.com/media/parts/elements/4521439.jpg | 131 | 9337-1 | | 93 | 60593 | 0 | | 1 | 6596091-1 | | 93 | 60593 | 0 | https://cdn.rebrickable.com/media/parts/elements/4536522.jpg | 76 | 9314-1 | | 94 | 60596 | 15 | | 1 | 6596091-1 | | 94 | 60596 | 15 | https://cdn.rebrickable.com/media/parts/elements/4521254.jpg | 247 | 41135-1 | | 95 | 60601 | 47 | | 1 | 6596091-1 | | 95 | 60601 | 47 | https://cdn.rebrickable.com/media/parts/elements/4521209.jpg | 232 | 10222-1 | | 96 | 60602 | 47 | | 1 | 6596091-1 | | 96 | 60602 | 47 | https://cdn.rebrickable.com/media/parts/elements/4536998.jpg | 187 | 10255-1 | | 97 | 60616b | 47 | | 1 | 6596091-1 | | 97 | 60616b | 47 | https://cdn.rebrickable.com/media/parts/elements/6247362.jpg | 123 | 10255-1 | | 98 | 6141 | 15 | | 1 | 6596091-1 | | 98 | 6141 | 15 | https://cdn.rebrickable.com/media/parts/elements/614101.jpg | 1062 | 40107-1 | | 99 | 63864 | 4 | | 1 | 6596091-1 | | 99 | 63864 | 4 | https://cdn.rebrickable.com/media/parts/elements/4533742.jpg | 226 | 10222-1 | | 100 | 63868 | 4 | | 1 | 6596091-1 | | 100 | 63868 | 4 | https://cdn.rebrickable.com/media/parts/elements/4534648.jpg | 149 | 40195-1 | | 101 | 6636 | 14 | | 1 | 6596091-1 | | 101 | 6636 | 14 | https://cdn.rebrickable.com/media/parts/elements/6388488.jpg | 213 | 4888-1 | | 102 | 77844 | 0 | | 1 | 6596091-1 | | 102 | 77844 | 0 | https://cdn.rebrickable.com/media/parts/elements/6439175.jpg | 110 | 75348-1 | | 103 | 86996 | 0 | | 1 | 6596091-1 | | 103 | 86996 | 0 | https://cdn.rebrickable.com/media/parts/elements/6388352.jpg | 126 | 76909-1 | | 104 | 87079 | 14 | | 1 | 6596091-1 | | 104 | 87079 | 14 | https://cdn.rebrickable.com/media/parts/elements/4560181.jpg | 206 | 60018-1 | | 105 | 87580 | 4 | | 1 | 6596091-1 | | 105 | 87580 | 4 | https://cdn.rebrickable.com/media/parts/elements/4581308.jpg | 240 | 10222-1 | +-----+------------+----------+--------------------------------------------------------------+----------+-----------------+