.bail ON .mode table --wrap 0 SELECT datetime(value, 'unixepoch') 'DB version' FROM rb_db_lov WHERE key = 'data_timestamp'; +---------------------+ | DB version | +---------------------+ | 2025-12-08 07:55:48 | +---------------------+ -- 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 | 10187 | 2 | | 1 | 5009626-1 | | 1 | 10187 | 2 | https://cdn.rebrickable.com/media/parts/elements/6329651.jpg | 12 | 71741-1 | | 2 | 11213 | 19 | | 1 | 5009626-1 | | 2 | 11213 | 19 | https://cdn.rebrickable.com/media/parts/elements/6093862.jpg | 22 | 21322-1 | | 3 | 11477 | 1 | | 1 | 5009626-1 | | 3 | 11477 | 1 | https://cdn.rebrickable.com/media/parts/elements/6055065.jpg | 168 | 71236-1 | | 4 | 11477 | 14 | | 1 | 5009626-1 | | 4 | 11477 | 14 | https://cdn.rebrickable.com/media/parts/elements/6029947.jpg | 178 | 60096-1 | | 5 | 13564 | 85 | | 1 | 5009626-1 | | 5 | 13564 | 85 | https://cdn.rebrickable.com/media/parts/elements/6430673.jpg | 6 | 75576-1 | | 6 | 15462 | 70 | | 1 | 5009626-1 | | 6 | 15462 | 70 | https://cdn.rebrickable.com/media/parts/elements/6159763.jpg | 373 | 42063-1 | | 7 | 1566 | 326 | | 1 | 5009626-1 | | 7 | 1566 | 326 | https://cdn.rebrickable.com/media/parts/elements/6426470.jpg | 4 | 10314-1 | | 8 | 18575 | 0 | | 1 | 5009626-1 | | 8 | 18575 | 0 | https://cdn.rebrickable.com/media/parts/elements/6346535.jpg | 110 | 71207-1 | | 9 | 18654 | 0 | | 1 | 5009626-1 | | 9 | 18654 | 0 | https://cdn.rebrickable.com/media/parts/elements/6121485.jpg | 205 | 30378-1 | | 10 | 20482 | 72 | | 1 | 5009626-1 | | 10 | 20482 | 72 | https://cdn.rebrickable.com/media/parts/elements/6271752.jpg | 195 | 70837-1 | | 11 | 20482 | 191 | | 1 | 5009626-1 | | 11 | 20482 | 191 | https://cdn.rebrickable.com/media/parts/elements/6223719.jpg | 48 | 10294-1 | | 12 | 22885 | 14 | | 1 | 5009626-1 | | 12 | 22885 | 14 | https://cdn.rebrickable.com/media/parts/elements/6313592.jpg | 60 | 43179-1 | | 13 | 24866 | 320 | | 1 | 5009626-1 | | 13 | 24866 | 320 | https://cdn.rebrickable.com/media/parts/elements/6458394.jpg | 17 | 40725-1 | | 14 | 26601 | 28 | | 1 | 5009626-1 | | 14 | 26601 | 28 | https://cdn.rebrickable.com/media/parts/elements/6228921.jpg | 81 | 75215-1 | | 15 | 27263 | 71 | | 1 | 5009626-1 | | 15 | 27263 | 71 | https://cdn.rebrickable.com/media/parts/elements/6177078.jpg | 135 | 10255-1 | | 16 | 2756pr0019 | 15 | | 2 | 1017-1 | | 16 | 2756pr0019 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 17 | 2756pr0021 | 15 | | 2 | 1017-1 | | 17 | 2756pr0021 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 18 | 2756pr0023 | 15 | | 2 | 1017-1 | | 18 | 2756pr0023 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 19 | 2756pr0025 | 15 | | 2 | 1017-1 | | 19 | 2756pr0025 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 20 | 2756pr0027 | 15 | | 2 | 1017-1 | | 20 | 2756pr0027 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 21 | 2756pr0029 | 15 | | 2 | 1017-1 | | 21 | 2756pr0029 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 22 | 2756pr0030 | 15 | | 1 | 1017-1 | | 22 | 2756pr0030 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 23 | 2756pr0031 | 15 | | 2 | 1017-1 | | 23 | 2756pr0031 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 24 | 2756pr0032 | 15 | | 1 | 1017-1 | | 24 | 2756pr0032 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 25 | 2756pr0033 | 15 | | 2 | 1017-1 | | 25 | 2756pr0033 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 26 | 2756pr0034 | 15 | | 1 | 1017-1 | | 26 | 2756pr0034 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 27 | 2756pr0035 | 15 | | 2 | 1017-1 | | 27 | 2756pr0035 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 28 | 2756pr0036 | 15 | | 1 | 1017-1 | | 28 | 2756pr0036 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 29 | 2756pr0037 | 15 | | 2 | 1017-1 | | 29 | 2756pr0037 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 30 | 2756pr0038 | 15 | | 1 | 1017-1 | | 30 | 2756pr0038 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 31 | 2756pr0039 | 15 | | 2 | 1017-1 | | 31 | 2756pr0039 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 32 | 2756pr0040 | 15 | | 1 | 1017-1 | | 32 | 2756pr0040 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 33 | 2756pr0041 | 15 | | 2 | 1017-1 | | 33 | 2756pr0041 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 34 | 2756pr0042 | 15 | | 1 | 1017-1 | | 34 | 2756pr0042 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 35 | 2756pr0043 | 15 | | 2 | 1017-1 | | 35 | 2756pr0043 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 36 | 2756pr0044 | 15 | | 1 | 1017-1 | | 36 | 2756pr0044 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 37 | 2756pr0045 | 15 | | 2 | 1017-1 | | 37 | 2756pr0045 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 38 | 2756pr0046 | 15 | | 1 | 1017-1 | | 38 | 2756pr0046 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 39 | 2756pr0047 | 15 | | 2 | 1017-1 | | 39 | 2756pr0047 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 40 | 2756pr0048 | 15 | | 1 | 1017-1 | | 40 | 2756pr0048 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 41 | 2756pr0049 | 15 | | 2 | 1017-1 | | 41 | 2756pr0049 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 42 | 2756pr0051 | 15 | | 2 | 1017-1 | | 42 | 2756pr0051 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 43 | 2756pr0052 | 15 | | 1 | 1017-1 | | 43 | 2756pr0052 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 44 | 2756pr0053 | 15 | | 2 | 1017-1 | | 44 | 2756pr0053 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 45 | 2756pr0054 | 15 | | 1 | 1017-1 | | 45 | 2756pr0054 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 46 | 2756pr0055 | 15 | | 2 | 1017-1 | | 46 | 2756pr0055 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 47 | 2756pr0056 | 15 | | 1 | 1017-1 | | 47 | 2756pr0056 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 48 | 2756pr0057 | 15 | | 2 | 1017-1 | | 48 | 2756pr0057 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 49 | 2756pr0058 | 15 | | 1 | 1017-1 | | 49 | 2756pr0058 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 50 | 2756pr0059 | 15 | | 2 | 1017-1 | | 50 | 2756pr0059 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 51 | 2756pr0060 | 15 | | 1 | 1017-1 | | 51 | 2756pr0060 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 52 | 2756pr0061 | 15 | | 2 | 1017-1 | | 52 | 2756pr0061 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 53 | 2756pr0062 | 15 | | 1 | 1017-1 | | 53 | 2756pr0062 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 54 | 2756pr0064 | 15 | | 1 | 1017-1 | | 54 | 2756pr0064 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 55 | 2756pr0065 | 15 | | 2 | 1017-1 | | 55 | 2756pr0065 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 56 | 2756pr0066 | 15 | | 1 | 1017-1 | | 56 | 2756pr0066 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 57 | 2756pr0067 | 15 | | 2 | 1017-1 | | 57 | 2756pr0067 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 58 | 2756pr0069 | 15 | | 2 | 1017-1 | | 58 | 2756pr0069 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 59 | 29119 | 4 | | 1 | 5009626-1 | | 59 | 29119 | 4 | https://cdn.rebrickable.com/media/parts/elements/6177507.jpg | 119 | 75882-1 | | 60 | 3001 | 28 | | 1 | 5009626-1 | | 60 | 3001 | 28 | https://cdn.rebrickable.com/media/parts/elements/4247145.jpg | 97 | 60069-1 | | 61 | 3005 | 71 | | 1 | 5009626-1 | | 61 | 3005 | 71 | https://cdn.rebrickable.com/media/parts/elements/4211389.jpg | 731 | 75060-1 | | 62 | 3010 | 4 | | 1 | 5009626-1 | | 62 | 3010 | 4 | https://cdn.rebrickable.com/media/parts/elements/301021.jpg | 981 | 9385-1 | | 63 | 3010 | 28 | | 1 | 5009626-1 | | 63 | 3010 | 28 | https://cdn.rebrickable.com/media/parts/elements/4497072.jpg | 125 | 10705-1 | | 64 | 3020 | 28 | | 1 | 5009626-1 | | 64 | 3020 | 28 | https://cdn.rebrickable.com/media/parts/elements/4267874.jpg | 375 | 76036-1 | | 65 | 3023 | 2 | | 1 | 5009626-1 | | 65 | 3023 | 2 | https://cdn.rebrickable.com/media/parts/elements/302328.jpg | 643 | 76015-1 | | 66 | 3023 | 321 | | 1 | 5009626-1 | | 66 | 3023 | 321 | https://cdn.rebrickable.com/media/parts/elements/4653988.jpg | 176 | 10705-1 | | 67 | 3024 | 14 | | 1 | 5009626-1 | | 67 | 3024 | 14 | https://cdn.rebrickable.com/media/parts/elements/302424.jpg | 580 | 10071-1 | | 68 | 3031 | 71 | | 1 | 5009626-1 | | 68 | 3031 | 71 | https://cdn.rebrickable.com/media/parts/elements/4211403.jpg | 446 | 41135-1 | | 69 | 30363 | 71 | | 1 | 5009626-1 | | 69 | 30363 | 71 | https://cdn.rebrickable.com/media/parts/elements/4211618.jpg | 67 | 8083-1 | | 70 | 3039 | 28 | | 1 | 5009626-1 | | 70 | 3039 | 28 | https://cdn.rebrickable.com/media/parts/elements/6184880.jpg | 53 | 10704-1 | | 71 | 30562 | 47 | | 1 | 5009626-1 | | 71 | 30562 | 47 | https://cdn.rebrickable.com/media/parts/elements/4599452.jpg | 45 | 9526-1 | | 72 | 32062 | 4 | | 1 | 5009626-1 | | 72 | 32062 | 4 | https://cdn.rebrickable.com/media/parts/elements/4142865.jpg | 2037 | 8931-1 | | 73 | 32828 | 19 | | 1 | 5009626-1 | | 73 | 32828 | 19 | https://cdn.rebrickable.com/media/parts/elements/6286492.jpg | 69 | 80104-1 | | 74 | 32952 | 1 | | 1 | 5009626-1 | | 74 | 32952 | 1 | https://cdn.rebrickable.com/media/parts/elements/6290531.jpg | 47 | 60244-1 | | 75 | 3386 | 71 | | 1 | 5009626-1 | | 75 | 3386 | 71 | https://cdn.rebrickable.com/media/parts/elements/6448793.jpg | 102 | 76419-1 | | 76 | 3622 | 71 | | 1 | 5009626-1 | | 76 | 3622 | 71 | https://cdn.rebrickable.com/media/parts/elements/4211428.jpg | 478 | 75060-1 | | 77 | 3659 | 28 | | 1 | 5009626-1 | | 77 | 3659 | 28 | https://cdn.rebrickable.com/media/parts/elements/4596218.jpg | 24 | 4842-1 | | 78 | 3666 | 322 | | 1 | 5009626-1 | | 78 | 3666 | 322 | https://cdn.rebrickable.com/media/parts/elements/4625036.jpg | 114 | 41125-1 | | 79 | 36840 | 0 | | 1 | 5009626-1 | | 79 | 36840 | 0 | https://cdn.rebrickable.com/media/parts/elements/6234695.jpg | 280 | 41615-1 | | 80 | 36841 | 212 | | 1 | 5009626-1 | | 80 | 36841 | 212 | https://cdn.rebrickable.com/media/parts/elements/6383096.jpg | 9 | 10298-1 | | 81 | 3700 | 0 | | 1 | 5009626-1 | | 81 | 3700 | 0 | https://cdn.rebrickable.com/media/parts/elements/370026.jpg | 741 | 4768-2 | | 82 | 3710 | 28 | | 1 | 5009626-1 | | 82 | 3710 | 28 | https://cdn.rebrickable.com/media/parts/elements/4626904.jpg | 341 | 60069-1 | | 83 | 37352 | 0 | | 1 | 5009626-1 | | 83 | 37352 | 0 | https://cdn.rebrickable.com/media/parts/elements/6275732.jpg | 71 | 43114-1 | | 84 | 3894 | 1 | | 1 | 5009626-1 | | 84 | 3894 | 1 | https://cdn.rebrickable.com/media/parts/elements/389423.jpg | 76 | 6928-1 | | 85 | 4032a | 0 | | 1 | 5009626-1 | | 85 | 4032a | 0 | https://cdn.rebrickable.com/media/parts/elements/403226.jpg | 1031 | 6981-1 | | 86 | 4070 | 1 | | 1 | 5009626-1 | | 86 | 4070 | 1 | https://cdn.rebrickable.com/media/parts/elements/407023.jpg | 180 | 9385-1 | | 87 | 41539 | 71 | | 1 | 5009626-1 | | 87 | 41539 | 71 | https://cdn.rebrickable.com/media/parts/elements/4166618.jpg | 115 | 2000424-1 | | 88 | 41677 | 0 | | 1 | 5009626-1 | | 88 | 41677 | 0 | https://cdn.rebrickable.com/media/parts/elements/4164133.jpg | 305 | 75060-1 | | 89 | 43710 | 28 | | 1 | 5009626-1 | | 89 | 43710 | 28 | https://cdn.rebrickable.com/media/parts/elements/6004711.jpg | 14 | 6869-1 | | 90 | 43711 | 28 | | 1 | 5009626-1 | | 90 | 43711 | 28 | https://cdn.rebrickable.com/media/parts/elements/6004712.jpg | 13 | 6869-1 | | 91 | 48092 | 0 | | 1 | 5009626-1 | | 91 | 48092 | 0 | https://cdn.rebrickable.com/media/parts/elements/4275674.jpg | 23 | 3826-1 | | 92 | 52107 | 0 | | 1 | 5009626-1 | | 92 | 52107 | 0 | https://cdn.rebrickable.com/media/parts/elements/4253815.jpg | 253 | 850950-1 | | 93 | 54200 | 0 | | 1 | 5009626-1 | | 93 | 54200 | 0 | https://cdn.rebrickable.com/media/parts/elements/4504382.jpg | 1055 | 75060-1 | | 94 | 54200 | 28 | | 1 | 5009626-1 | | 94 | 54200 | 28 | https://cdn.rebrickable.com/media/parts/elements/6015451.jpg | 166 | 10234-1 | | 95 | 54200 | 72 | | 1 | 5009626-1 | | 95 | 54200 | 72 | https://cdn.rebrickable.com/media/parts/elements/4244373.jpg | 720 | 4888-1 | | 96 | 54200 | 321 | | 1 | 5009626-1 | | 96 | 54200 | 321 | https://cdn.rebrickable.com/media/parts/elements/6133838.jpg | 51 | 10252-1 | | 97 | 5904 | 25 | | 1 | 5009626-1 | | 97 | 5904 | 25 | https://cdn.rebrickable.com/media/parts/elements/6515227.jpg | 10 | 21353-1 | | 98 | 59900 | 26 | | 1 | 5009626-1 | | 98 | 59900 | 26 | https://cdn.rebrickable.com/media/parts/elements/6003007.jpg | 75 | 10747-1 | | 99 | 60897 | 25 | | 1 | 5009626-1 | | 99 | 60897 | 25 | https://cdn.rebrickable.com/media/parts/elements/4587052.jpg | 73 | 60036-1 | | 100 | 61408 | 0 | | 1 | 5009626-1 | | 100 | 61408 | 0 | https://cdn.rebrickable.com/media/parts/elements/6313520.jpg | 49 | 42108-1 | | 101 | 6141 | 71 | | 1 | 5009626-1 | | 101 | 6141 | 71 | https://cdn.rebrickable.com/media/parts/elements/4211525.jpg | 872 | 40107-1 | | 102 | 71752 | 0 | | 1 | 5009626-1 | | 102 | 71752 | 0 | https://cdn.rebrickable.com/media/parts/elements/6325254.jpg | 119 | 60276-1 | | 103 | 73230 | 321 | | 1 | 5009626-1 | | 103 | 73230 | 321 | https://cdn.rebrickable.com/media/parts/elements/6446031.jpg | 8 | 76269-1 | | 104 | 74611 | 0 | | 1 | 5009626-1 | | 104 | 74611 | 0 | https://cdn.rebrickable.com/media/parts/elements/6393938.jpg | 19 | 41964-1 | | 105 | 79743 | 25 | | 1 | 5009626-1 | | 105 | 79743 | 25 | https://cdn.rebrickable.com/media/parts/elements/6510513.jpg | 10 | 10368-1 | | 106 | 85861 | 28 | | 1 | 5009626-1 | | 106 | 85861 | 28 | https://cdn.rebrickable.com/media/parts/elements/6300322.jpg | 72 | 75978-1 | | 107 | 85861 | 288 | | 1 | 5009626-1 | | 107 | 85861 | 288 | https://cdn.rebrickable.com/media/parts/elements/6230571.jpg | 75 | 41775-4 | | 108 | 87083 | 72 | | 1 | 5009626-1 | | 108 | 87083 | 72 | https://cdn.rebrickable.com/media/parts/elements/4560177.jpg | 957 | 75060-1 | | 109 | 87087 | 212 | | 1 | 5009626-1 | | 109 | 87087 | 212 | https://cdn.rebrickable.com/media/parts/elements/6383074.jpg | 11 | 76424-1 | | 110 | 98138pr0008 | 15 | | 1 | 5009626-1 | | 110 | 98138pr0008 | 15 | https://cdn.rebrickable.com/media/parts/elements/6029156.jpg | 335 | 850950-1 | +-----+-------------+----------+--------------------------------------------------------------+----------+-----------------+