.bail ON .mode table --wrap 0 SELECT datetime(value, 'unixepoch') 'DB version' FROM rb_db_lov WHERE key = 'data_timestamp'; +---------------------+ | DB version | +---------------------+ | 2025-12-02 07:55:33 | +---------------------+ -- 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 | 11062 | 0 | | 1 | 5009614-1 | | 1 | 11062 | 0 | https://cdn.rebrickable.com/media/parts/elements/6022202.jpg | 43 | 40107-1 | | 2 | 11213 | 322 | | 1 | 5009614-1 | | 2 | 11213 | 322 | https://cdn.rebrickable.com/media/parts/elements/6029690.jpg | 85 | 561508-1 | | 3 | 11609 | 297 | | 1 | 5009614-1 | | 3 | 11609 | 297 | https://cdn.rebrickable.com/media/parts/elements/6070746.jpg | 96 | 41135-1 | | 4 | 15496 | 15 | | 1 | 5009614-1 | | 4 | 15496 | 15 | https://cdn.rebrickable.com/media/parts/elements/6052312.jpg | 18 | 71016-1 | | 5 | 15535 | 1 | | 1 | 5009614-1 | | 5 | 15535 | 1 | https://cdn.rebrickable.com/media/parts/elements/6535451.jpg | 2 | 77249-1 | | 6 | 18674 | 15 | | 1 | 5009614-1 | | 6 | 18674 | 15 | https://cdn.rebrickable.com/media/parts/elements/6093053.jpg | 456 | 41135-1 | | 7 | 2420 | 0 | | 1 | 5009614-1 | | 7 | 2420 | 0 | https://cdn.rebrickable.com/media/parts/elements/242026.jpg | 950 | 4888-1 | | 8 | 2431 | 15 | | 1 | 5009614-1 | | 8 | 2431 | 15 | https://cdn.rebrickable.com/media/parts/elements/243101.jpg | 935 | 6356-1 | | 9 | 2450 | 15 | | 1 | 5009614-1 | | 9 | 2450 | 15 | https://cdn.rebrickable.com/media/parts/elements/245001.jpg | 145 | 10189-1 | | 10 | 26603 | 14 | | 1 | 5009614-1 | | 10 | 26603 | 14 | https://cdn.rebrickable.com/media/parts/elements/6179184.jpg | 57 | 21307-1 | | 11 | 27448 | 484 | | 1 | 5009614-1 | | 11 | 27448 | 484 | https://cdn.rebrickable.com/media/parts/elements/6375188.jpg | 17 | 76399-1 | | 12 | 2756pr0019 | 15 | | 2 | 1017-1 | | 12 | 2756pr0019 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 13 | 2756pr0021 | 15 | | 2 | 1017-1 | | 13 | 2756pr0021 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 14 | 2756pr0023 | 15 | | 2 | 1017-1 | | 14 | 2756pr0023 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 15 | 2756pr0025 | 15 | | 2 | 1017-1 | | 15 | 2756pr0025 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 16 | 2756pr0027 | 15 | | 2 | 1017-1 | | 16 | 2756pr0027 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 17 | 2756pr0029 | 15 | | 2 | 1017-1 | | 17 | 2756pr0029 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 18 | 2756pr0030 | 15 | | 1 | 1017-1 | | 18 | 2756pr0030 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 19 | 2756pr0031 | 15 | | 2 | 1017-1 | | 19 | 2756pr0031 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 20 | 2756pr0032 | 15 | | 1 | 1017-1 | | 20 | 2756pr0032 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 21 | 2756pr0033 | 15 | | 2 | 1017-1 | | 21 | 2756pr0033 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 22 | 2756pr0034 | 15 | | 1 | 1017-1 | | 22 | 2756pr0034 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 23 | 2756pr0035 | 15 | | 2 | 1017-1 | | 23 | 2756pr0035 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 24 | 2756pr0036 | 15 | | 1 | 1017-1 | | 24 | 2756pr0036 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 25 | 2756pr0037 | 15 | | 2 | 1017-1 | | 25 | 2756pr0037 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 26 | 2756pr0038 | 15 | | 1 | 1017-1 | | 26 | 2756pr0038 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 27 | 2756pr0039 | 15 | | 2 | 1017-1 | | 27 | 2756pr0039 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 28 | 2756pr0040 | 15 | | 1 | 1017-1 | | 28 | 2756pr0040 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 29 | 2756pr0041 | 15 | | 2 | 1017-1 | | 29 | 2756pr0041 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 30 | 2756pr0042 | 15 | | 1 | 1017-1 | | 30 | 2756pr0042 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 31 | 2756pr0043 | 15 | | 2 | 1017-1 | | 31 | 2756pr0043 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 32 | 2756pr0044 | 15 | | 1 | 1017-1 | | 32 | 2756pr0044 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 33 | 2756pr0045 | 15 | | 2 | 1017-1 | | 33 | 2756pr0045 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 34 | 2756pr0046 | 15 | | 1 | 1017-1 | | 34 | 2756pr0046 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 35 | 2756pr0047 | 15 | | 2 | 1017-1 | | 35 | 2756pr0047 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 36 | 2756pr0048 | 15 | | 1 | 1017-1 | | 36 | 2756pr0048 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 37 | 2756pr0049 | 15 | | 2 | 1017-1 | | 37 | 2756pr0049 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 38 | 2756pr0051 | 15 | | 2 | 1017-1 | | 38 | 2756pr0051 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 39 | 2756pr0052 | 15 | | 1 | 1017-1 | | 39 | 2756pr0052 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 40 | 2756pr0053 | 15 | | 2 | 1017-1 | | 40 | 2756pr0053 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 41 | 2756pr0054 | 15 | | 1 | 1017-1 | | 41 | 2756pr0054 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 42 | 2756pr0055 | 15 | | 2 | 1017-1 | | 42 | 2756pr0055 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 43 | 2756pr0056 | 15 | | 1 | 1017-1 | | 43 | 2756pr0056 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 44 | 2756pr0057 | 15 | | 2 | 1017-1 | | 44 | 2756pr0057 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 45 | 2756pr0058 | 15 | | 1 | 1017-1 | | 45 | 2756pr0058 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 46 | 2756pr0059 | 15 | | 2 | 1017-1 | | 46 | 2756pr0059 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 47 | 2756pr0060 | 15 | | 1 | 1017-1 | | 47 | 2756pr0060 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 48 | 2756pr0061 | 15 | | 2 | 1017-1 | | 48 | 2756pr0061 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 49 | 2756pr0062 | 15 | | 1 | 1017-1 | | 49 | 2756pr0062 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 50 | 2756pr0064 | 15 | | 1 | 1017-1 | | 50 | 2756pr0064 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 51 | 2756pr0065 | 15 | | 2 | 1017-1 | | 51 | 2756pr0065 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 52 | 2756pr0066 | 15 | | 1 | 1017-1 | | 52 | 2756pr0066 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 53 | 2756pr0067 | 15 | | 2 | 1017-1 | | 53 | 2756pr0067 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 54 | 2756pr0069 | 15 | | 2 | 1017-1 | | 54 | 2756pr0069 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 55 | 28621 | 47 | | 1 | 5009614-1 | | 55 | 28621 | 47 | https://cdn.rebrickable.com/media/parts/elements/6168665.jpg | 60 | 75955-1 | | 56 | 3002 | 27 | | 1 | 5009614-1 | | 56 | 3002 | 27 | https://cdn.rebrickable.com/media/parts/elements/4122452.jpg | 88 | 8302-1 | | 57 | 3004 | 0 | | 1 | 5009614-1 | | 57 | 3004 | 0 | https://cdn.rebrickable.com/media/parts/elements/300426.jpg | 1741 | 6435-1 | | 58 | 3009 | 0 | | 1 | 5009614-1 | | 58 | 3009 | 0 | https://cdn.rebrickable.com/media/parts/elements/300926.jpg | 703 | 6378-1 | | 59 | 3028 | 0 | | 1 | 5009614-1 | | 59 | 3028 | 0 | https://cdn.rebrickable.com/media/parts/elements/302826.jpg | 148 | 21017-1 | | 60 | 3029 | 15 | | 1 | 5009614-1 | | 60 | 3029 | 15 | https://cdn.rebrickable.com/media/parts/elements/302901.jpg | 142 | 75094-1 | | 61 | 3062b | 70 | | 1 | 5009614-1 | | 61 | 3062b | 70 | https://cdn.rebrickable.com/media/parts/elements/4211183.jpg | 530 | 9385-1 | | 62 | 32001 | 15 | | 1 | 5009614-1 | | 62 | 32001 | 15 | https://cdn.rebrickable.com/media/parts/elements/4527947.jpg | 47 | 70707-1 | | 63 | 32607 | 2 | | 1 | 5009614-1 | | 63 | 32607 | 2 | https://cdn.rebrickable.com/media/parts/elements/6229130.jpg | 278 | 10261-1 | | 64 | 3262 | 15 | | 1 | 5009614-1 | | 64 | 3262 | 15 | https://cdn.rebrickable.com/media/parts/elements/6429053.jpg | 26 | 43213-1 | | 65 | 32828 | 288 | | 1 | 5009614-1 | | 65 | 32828 | 288 | https://cdn.rebrickable.com/media/parts/elements/6392974.jpg | 27 | 75338-1 | | 66 | 33183 | 70 | | 1 | 5009614-1 | | 66 | 33183 | 70 | https://cdn.rebrickable.com/media/parts/elements/4618589.jpg | 181 | 41071-1 | | 67 | 3460 | 0 | | 1 | 5009614-1 | | 67 | 3460 | 0 | https://cdn.rebrickable.com/media/parts/elements/346026.jpg | 946 | 6435-1 | | 68 | 35442 | 322 | | 1 | 5009614-1 | | 68 | 35442 | 322 | https://cdn.rebrickable.com/media/parts/elements/6271207.jpg | 27 | 75948-1 | | 69 | 35443 | 322 | | 1 | 5009614-1 | | 69 | 35443 | 322 | https://cdn.rebrickable.com/media/parts/elements/6238331.jpg | 27 | 41366-1 | | 70 | 35480 | 0 | | 1 | 5009614-1 | | 70 | 35480 | 0 | https://cdn.rebrickable.com/media/parts/elements/6210270.jpg | 456 | 76098-1 | | 71 | 3666 | 15 | | 1 | 5009614-1 | | 71 | 3666 | 15 | https://cdn.rebrickable.com/media/parts/elements/366601.jpg | 1084 | 6356-1 | | 72 | 36841 | 0 | | 1 | 5009614-1 | | 72 | 36841 | 0 | https://cdn.rebrickable.com/media/parts/elements/6299338.jpg | 174 | 75274-1 | | 73 | 3795 | 70 | | 1 | 5009614-1 | | 73 | 3795 | 70 | https://cdn.rebrickable.com/media/parts/elements/4211247.jpg | 515 | 4768-2 | | 74 | 3878 | 0 | | 1 | 5009614-1 | | 74 | 3878 | 0 | https://cdn.rebrickable.com/media/parts/elements/4105175.jpg | 122 | 10228-1 | | 75 | 4032a | 14 | | 1 | 5009614-1 | | 75 | 4032a | 14 | https://cdn.rebrickable.com/media/parts/elements/403224.jpg | 396 | 561508-1 | | 76 | 4032a | 322 | | 1 | 5009614-1 | | 76 | 4032a | 322 | https://cdn.rebrickable.com/media/parts/elements/6109752.jpg | 121 | 41124-1 | | 77 | 4162 | 4 | | 1 | 5009614-1 | | 77 | 4162 | 4 | https://cdn.rebrickable.com/media/parts/elements/416221.jpg | 199 | 6356-1 | | 78 | 4162 | 322 | | 1 | 5009614-1 | | 78 | 4162 | 322 | https://cdn.rebrickable.com/media/parts/elements/6078339.jpg | 36 | 41125-1 | | 79 | 41770 | 288 | | 1 | 5009614-1 | | 79 | 41770 | 288 | https://cdn.rebrickable.com/media/parts/elements/4648340.jpg | 31 | 10226-1 | | 80 | 4733 | 0 | | 1 | 5009614-1 | | 80 | 4733 | 0 | https://cdn.rebrickable.com/media/parts/elements/473326.jpg | 343 | 7899-1 | | 81 | 4733 | 15 | | 1 | 5009614-1 | | 81 | 4733 | 15 | https://cdn.rebrickable.com/media/parts/elements/4111971.jpg | 236 | 20205-1 | | 82 | 4740 | 0 | | 1 | 5009614-1 | | 82 | 4740 | 0 | https://cdn.rebrickable.com/media/parts/elements/474026.jpg | 459 | 40107-1 | | 83 | 54200 | 288 | | 1 | 5009614-1 | | 83 | 54200 | 288 | https://cdn.rebrickable.com/media/parts/elements/4504375.jpg | 145 | 40109-1 | | 84 | 59900 | 288 | | 1 | 5009614-1 | | 84 | 59900 | 288 | https://cdn.rebrickable.com/media/parts/elements/6411591.jpg | 24 | 10308-1 | | 85 | 60478 | 0 | | 1 | 5009614-1 | | 85 | 60478 | 0 | https://cdn.rebrickable.com/media/parts/elements/4515368.jpg | 472 | 76015-1 | | 86 | 6111 | 0 | | 1 | 5009614-1 | | 86 | 6111 | 0 | https://cdn.rebrickable.com/media/parts/elements/611126.jpg | 174 | 8108-1 | | 87 | 6141 | 4 | | 1 | 5009614-1 | | 87 | 6141 | 4 | https://cdn.rebrickable.com/media/parts/elements/614121.jpg | 845 | 40107-1 | | 88 | 6141 | 36 | | 1 | 5009614-1 | | 88 | 6141 | 36 | https://cdn.rebrickable.com/media/parts/elements/3005741.jpg | 1655 | 6435-1 | | 89 | 6141 | 46 | | 1 | 5009614-1 | | 89 | 6141 | 46 | https://cdn.rebrickable.com/media/parts/elements/3005744.jpg | 1076 | 7899-1 | | 90 | 6141 | 72 | | 1 | 5009614-1 | | 90 | 6141 | 72 | https://cdn.rebrickable.com/media/parts/elements/4210633.jpg | 671 | 75060-1 | | 91 | 6141 | 322 | | 1 | 5009614-1 | | 91 | 6141 | 322 | https://cdn.rebrickable.com/media/parts/elements/6102986.jpg | 149 | 70734-1 | | 92 | 61485 | 15 | | 1 | 5009614-1 | | 92 | 61485 | 15 | https://cdn.rebrickable.com/media/parts/elements/4611927.jpg | 102 | 4645-1 | | 93 | 63868 | 72 | | 1 | 5009614-1 | | 93 | 63868 | 72 | https://cdn.rebrickable.com/media/parts/elements/4581225.jpg | 279 | 70812-1 | | 94 | 6587 | 28 | | 1 | 5009614-1 | | 94 | 6587 | 28 | https://cdn.rebrickable.com/media/parts/elements/4566927.jpg | 669 | 75060-1 | | 95 | 6636 | 70 | | 1 | 5009614-1 | | 95 | 6636 | 70 | https://cdn.rebrickable.com/media/parts/elements/4211204.jpg | 287 | 10189-1 | | 96 | 80679pr0001 | 484 | | 1 | 5009614-1 | | 96 | 80679pr0001 | 484 | https://cdn.rebrickable.com/media/parts/elements/6384077.jpg | 24 | 60317-1 | | 97 | 85861 | 47 | | 1 | 5009614-1 | | 97 | 85861 | 47 | https://cdn.rebrickable.com/media/parts/elements/6449836.jpg | 59 | 76261-1 | | 98 | 87079 | 322 | | 1 | 5009614-1 | | 98 | 87079 | 322 | https://cdn.rebrickable.com/media/parts/elements/6097042.jpg | 88 | 41065-1 | | 99 | 89522 | 25 | | 1 | 5009614-1 | | 99 | 89522 | 25 | https://cdn.rebrickable.com/media/parts/elements/6100397.jpg | 33 | 30397-1 | | 100 | 98138 | 0 | | 1 | 5009614-1 | | 100 | 98138 | 0 | https://cdn.rebrickable.com/media/parts/elements/6284070.jpg | 374 | 60139-1 | | 101 | 98138 | 15 | | 1 | 5009614-1 | | 101 | 98138 | 15 | https://cdn.rebrickable.com/media/parts/elements/4646844.jpg | 354 | 561508-1 | | 102 | 98138pr9986 | 84 | | 1 | 5009614-1 | | 102 | 98138pr9986 | 84 | https://cdn.rebrickable.com/media/parts/elements/6395410.jpg | 18 | 60317-1 | +-----+-------------+----------+--------------------------------------------------------------+----------+-----------------+