.bail ON .mode table --wrap 0 SELECT datetime(value, 'unixepoch') 'DB version' FROM rb_db_lov WHERE key = 'data_timestamp'; +---------------------+ | DB version | +---------------------+ | 2024-09-18 07:55:42 | +---------------------+ -- 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 | 2346 | 0 | | 1 | 9684-1 | | 1 | 2346 | 0 | https://cdn.rebrickable.com/media/parts/elements/234626.jpg | 86 | 1796-1 | | 2 | 2431 | 2 | | 1 | 9684-1 | | 2 | 2431 | 2 | https://cdn.rebrickable.com/media/parts/elements/243128.jpg | 131 | 8678-1 | | 3 | 2458 | 8 | | 1 | 9684-1 | | 3 | 2458 | 8 | https://cdn.rebrickable.com/media/parts/elements/4113907.jpg | 26 | 6737-1 | | 4 | 2653 | 0 | | 1 | 9684-1 | | 4 | 2653 | 0 | https://cdn.rebrickable.com/media/parts/elements/265326.jpg | 146 | 5974-1 | | 5 | 2756pr0019 | 15 | | 2 | 1017-1 | | 5 | 2756pr0019 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 6 | 2756pr0020 | 15 | | 1 | 1017-1 | | 6 | 2756pr0020 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 7 | 2756pr0021 | 15 | | 2 | 1017-1 | | 7 | 2756pr0021 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 8 | 2756pr0022 | 15 | | 1 | 1017-1 | | 8 | 2756pr0022 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 9 | 2756pr0023 | 15 | | 2 | 1017-1 | | 9 | 2756pr0023 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 10 | 2756pr0024 | 15 | | 1 | 1017-1 | | 10 | 2756pr0024 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 11 | 2756pr0025 | 15 | | 2 | 1017-1 | | 11 | 2756pr0025 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 12 | 2756pr0026 | 15 | | 1 | 1017-1 | | 12 | 2756pr0026 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 13 | 2756pr0027 | 15 | | 2 | 1017-1 | | 13 | 2756pr0027 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 14 | 2756pr0028 | 15 | | 1 | 1017-1 | | 14 | 2756pr0028 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 15 | 2756pr0029 | 15 | | 2 | 1017-1 | | 15 | 2756pr0029 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 16 | 2756pr0030 | 15 | | 1 | 1017-1 | | 16 | 2756pr0030 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 17 | 2756pr0031 | 15 | | 2 | 1017-1 | | 17 | 2756pr0031 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 18 | 2756pr0032 | 15 | | 1 | 1017-1 | | 18 | 2756pr0032 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 19 | 2756pr0033 | 15 | | 2 | 1017-1 | | 19 | 2756pr0033 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 20 | 2756pr0034 | 15 | | 1 | 1017-1 | | 20 | 2756pr0034 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 21 | 2756pr0035 | 15 | | 2 | 1017-1 | | 21 | 2756pr0035 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 22 | 2756pr0036 | 15 | | 1 | 1017-1 | | 22 | 2756pr0036 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 23 | 2756pr0037 | 15 | | 2 | 1017-1 | | 23 | 2756pr0037 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 24 | 2756pr0038 | 15 | | 1 | 1017-1 | | 24 | 2756pr0038 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 25 | 2756pr0039 | 15 | | 2 | 1017-1 | | 25 | 2756pr0039 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 26 | 2756pr0040 | 15 | | 1 | 1017-1 | | 26 | 2756pr0040 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 27 | 2756pr0041 | 15 | | 2 | 1017-1 | | 27 | 2756pr0041 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 28 | 2756pr0042 | 15 | | 1 | 1017-1 | | 28 | 2756pr0042 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 29 | 2756pr0043 | 15 | | 2 | 1017-1 | | 29 | 2756pr0043 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 30 | 2756pr0044 | 15 | | 1 | 1017-1 | | 30 | 2756pr0044 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 31 | 2756pr0045 | 15 | | 2 | 1017-1 | | 31 | 2756pr0045 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 32 | 2756pr0046 | 15 | | 1 | 1017-1 | | 32 | 2756pr0046 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 33 | 2756pr0047 | 15 | | 2 | 1017-1 | | 33 | 2756pr0047 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 34 | 2756pr0048 | 15 | | 1 | 1017-1 | | 34 | 2756pr0048 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 35 | 2756pr0049 | 15 | | 2 | 1017-1 | | 35 | 2756pr0049 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 36 | 2756pr0051 | 15 | | 2 | 1017-1 | | 36 | 2756pr0051 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 37 | 2756pr0052 | 15 | | 1 | 1017-1 | | 37 | 2756pr0052 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 38 | 2756pr0053 | 15 | | 2 | 1017-1 | | 38 | 2756pr0053 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 39 | 2756pr0054 | 15 | | 1 | 1017-1 | | 39 | 2756pr0054 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 40 | 2756pr0055 | 15 | | 2 | 1017-1 | | 40 | 2756pr0055 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 41 | 2756pr0056 | 15 | | 1 | 1017-1 | | 41 | 2756pr0056 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 42 | 2756pr0057 | 15 | | 2 | 1017-1 | | 42 | 2756pr0057 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 43 | 2756pr0058 | 15 | | 1 | 1017-1 | | 43 | 2756pr0058 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 44 | 2756pr0059 | 15 | | 2 | 1017-1 | | 44 | 2756pr0059 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 45 | 2756pr0060 | 15 | | 1 | 1017-1 | | 45 | 2756pr0060 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 46 | 2756pr0061 | 15 | | 2 | 1017-1 | | 46 | 2756pr0061 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 47 | 2756pr0062 | 15 | | 1 | 1017-1 | | 47 | 2756pr0062 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 48 | 2756pr0064 | 15 | | 1 | 1017-1 | | 48 | 2756pr0064 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 49 | 2756pr0065 | 15 | | 2 | 1017-1 | | 49 | 2756pr0065 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 50 | 2756pr0066 | 15 | | 1 | 1017-1 | | 50 | 2756pr0066 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 51 | 2756pr0067 | 15 | | 2 | 1017-1 | | 51 | 2756pr0067 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 52 | 2756pr0069 | 15 | | 2 | 1017-1 | | 52 | 2756pr0069 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | 1 | 1016-1 | | 53 | 2780 | 0 | | 1 | 9684-1 | | 53 | 2780 | 0 | https://cdn.rebrickable.com/media/parts/elements/4121715.jpg | 2512 | 8931-1 | | 54 | 2815 | 0 | | 1 | 9684-1 | | 54 | 2815 | 0 | https://cdn.rebrickable.com/media/parts/elements/281526.jpg | 139 | 8223-1 | | 55 | 2825 | 7 | | 1 | 9684-1 | | 55 | 2825 | 7 | https://cdn.rebrickable.com/media/parts/elements/4107133.jpg | 79 | 8812-1 | | 56 | 2854 | 7 | | 1 | 9684-1 | | 56 | 2854 | 7 | https://cdn.rebrickable.com/media/parts/elements/285402.jpg | 31 | 9614-1 | | 57 | 2902 | 0 | | 1 | 9684-1 | | 57 | 2902 | 0 | https://cdn.rebrickable.com/media/parts/elements/290226.jpg | 22 | 970670-1 | | 58 | 2903 | 15 | | 1 | 9684-1 | | 58 | 2903 | 15 | https://cdn.rebrickable.com/media/parts/elements/290301.jpg | 23 | 970670-1 | | 59 | 2905 | 7 | | 1 | 9684-1 | | 59 | 2905 | 7 | https://cdn.rebrickable.com/media/parts/elements/4142539.jpg | 24 | 8459-1 | | 60 | 30000 | 8 | | 1 | 9684-1 | | 60 | 30000 | 8 | https://cdn.rebrickable.com/media/parts/elements/3000027.jpg | 58 | 4284-1 | | 61 | 3001 | 2 | | 1 | 9684-1 | | 61 | 3001 | 2 | https://cdn.rebrickable.com/media/parts/elements/4106356.jpg | 342 | 9385-1 | | 62 | 3001 | 4 | | 1 | 9684-1 | | 62 | 3001 | 4 | https://cdn.rebrickable.com/media/parts/elements/300121.jpg | 921 | 9385-1 | | 63 | 3022 | 0 | | 1 | 9684-1 | | 63 | 3022 | 0 | https://cdn.rebrickable.com/media/parts/elements/302226.jpg | 2034 | 30277-1 | | 64 | 3023 | 0 | | 1 | 9684-1 | | 64 | 3023 | 0 | https://cdn.rebrickable.com/media/parts/elements/302326.jpg | 2525 | 850950-1 | | 65 | 3031 | 0 | | 1 | 9684-1 | | 65 | 3031 | 0 | https://cdn.rebrickable.com/media/parts/elements/303126.jpg | 708 | 70812-1 | | 66 | 3069b | 0 | | 1 | 9684-1 | | 66 | 3069b | 0 | https://cdn.rebrickable.com/media/parts/elements/306926.jpg | 1182 | 75060-1 | | 67 | 3069b | 4 | | 1 | 9684-1 | | 67 | 3069b | 4 | https://cdn.rebrickable.com/media/parts/elements/306921.jpg | 766 | 6356-1 | | 68 | 3127 | 7 | | 1 | 9684-1 | | 68 | 3127 | 7 | https://cdn.rebrickable.com/media/parts/ldraw/7/3127a.png | 53 | 6435-1 | | 69 | 3176 | 0 | | 1 | 9684-1 | | 69 | 3176 | 0 | https://cdn.rebrickable.com/media/parts/elements/317626.jpg | 267 | 6386-1 | | 70 | 32001 | 0 | | 1 | 9684-1 | | 70 | 32001 | 0 | https://cdn.rebrickable.com/media/parts/elements/3200126.jpg | 190 | 75060-1 | | 71 | 32002 | 8 | | 1 | 9684-1 | | 71 | 32002 | 8 | https://cdn.rebrickable.com/media/parts/elements/4109854.jpg | 150 | 8223-1 | | 72 | 32012 | 1 | | 1 | 9684-1 | | 72 | 32012 | 1 | https://cdn.rebrickable.com/media/parts/elements/4107179.jpg | 11 | 8205-1 | | 73 | 32013 | 1 | | 1 | 9684-1 | | 73 | 32013 | 1 | https://cdn.rebrickable.com/media/parts/elements/4107797.jpg | 72 | 970670-1 | | 74 | 32014 | 1 | | 1 | 9684-1 | | 74 | 32014 | 1 | https://cdn.rebrickable.com/media/parts/elements/4112205.jpg | 18 | 970670-1 | | 75 | 32015 | 7 | | 1 | 9684-1 | | 75 | 32015 | 7 | https://cdn.rebrickable.com/media/parts/elements/4106378.jpg | 37 | 970670-1 | | 76 | 32016 | 1 | | 1 | 9684-1 | | 76 | 32016 | 1 | https://cdn.rebrickable.com/media/parts/elements/4112204.jpg | 19 | 42063-1 | | 77 | 32017 | 7 | | 1 | 9684-1 | | 77 | 32017 | 7 | https://cdn.rebrickable.com/media/parts/elements/4106885.jpg | 50 | 8448-1 | | 78 | 32028 | 7 | | 1 | 9684-1 | | 78 | 32028 | 7 | https://cdn.rebrickable.com/media/parts/elements/4109642.jpg | 23 | 970600-1 | | 79 | 32034 | 7 | | 1 | 9684-1 | | 79 | 32034 | 7 | https://cdn.rebrickable.com/media/parts/elements/4107830.jpg | 32 | 8448-1 | | 80 | 32039 | 7 | | 1 | 9684-1 | | 80 | 32039 | 7 | https://cdn.rebrickable.com/media/parts/elements/4106469.jpg | 62 | 8240-1 | | 81 | 32062 | 0 | | 1 | 9684-1 | | 81 | 32062 | 0 | https://cdn.rebrickable.com/media/parts/elements/4109810.jpg | 859 | 4094-1 | | 82 | 32073 | 0 | | 1 | 9684-1 | | 82 | 32073 | 0 | https://cdn.rebrickable.com/media/parts/elements/4114740.jpg | 150 | 8240-1 | | 83 | 32123a | 7 | | 1 | 9684-1 | | 83 | 32123a | 7 | https://cdn.rebrickable.com/media/parts/ldraw/7/32123a.png | 218 | 8240-1 | | 84 | 32138 | 0 | | 1 | 9684-1 | | 84 | 32138 | 0 | https://cdn.rebrickable.com/media/parts/elements/4119589.jpg | 225 | 75060-1 | | 85 | 3482 | 14 | | 1 | 9684-1 | | 85 | 3482 | 14 | https://cdn.rebrickable.com/media/parts/elements/348224.jpg | 52 | 9794-1 | | 86 | 3483 | 0 | | 1 | 9684-1 | | 86 | 3483 | 0 | https://cdn.rebrickable.com/media/parts/elements/348326.jpg | 317 | 4284-1 | | 87 | 3634 | 0 | | 1 | 9684-1 | | 87 | 3634 | 0 | https://cdn.rebrickable.com/media/parts/elements/363426.jpg | 82 | 970670-1 | | 88 | 3647 | 7 | | 1 | 9684-1 | | 88 | 3647 | 7 | https://cdn.rebrickable.com/media/parts/elements/364702.jpg | 248 | 8223-1 | | 89 | 3648b | 7 | | 1 | 9684-1 | | 89 | 3648b | 7 | https://cdn.rebrickable.com/media/parts/elements/4107543.jpg | 55 | 4094-1 | | 90 | 3649 | 7 | | 1 | 9684-1 | | 90 | 3649 | 7 | https://cdn.rebrickable.com/media/parts/elements/364902.jpg | 65 | 9853-1 | | 91 | 3650c | 7 | | 1 | 9684-1 | | 91 | 3650c | 7 | https://cdn.rebrickable.com/media/parts/elements/365002.jpg | 78 | 8223-1 | | 92 | 3666 | 0 | | 1 | 9684-1 | | 92 | 3666 | 0 | https://cdn.rebrickable.com/media/parts/elements/366626.jpg | 1326 | 75060-1 | | 93 | 3673 | 7 | | 1 | 9684-1 | | 93 | 3673 | 7 | https://cdn.rebrickable.com/media/parts/elements/367302.jpg | 378 | 5827-1 | | 94 | 3700 | 4 | | 1 | 9684-1 | | 94 | 3700 | 4 | https://cdn.rebrickable.com/media/parts/elements/370021.jpg | 356 | 8678-1 | | 95 | 3700 | 14 | | 1 | 9684-1 | | 95 | 3700 | 14 | https://cdn.rebrickable.com/media/parts/elements/370024.jpg | 295 | 4888-1 | | 96 | 3701 | 4 | | 1 | 9684-1 | | 96 | 3701 | 4 | https://cdn.rebrickable.com/media/parts/elements/370121.jpg | 177 | 8812-1 | | 97 | 3701 | 14 | | 1 | 9684-1 | | 97 | 3701 | 14 | https://cdn.rebrickable.com/media/parts/elements/370124.jpg | 125 | 4094-1 | | 98 | 3702 | 4 | | 1 | 9684-1 | | 98 | 3702 | 4 | https://cdn.rebrickable.com/media/parts/elements/370221.jpg | 146 | 10189-1 | | 99 | 3702 | 14 | | 1 | 9684-1 | | 99 | 3702 | 14 | https://cdn.rebrickable.com/media/parts/elements/370224.jpg | 89 | 4888-1 | | 100 | 3703 | 4 | | 1 | 9684-1 | | 100 | 3703 | 4 | https://cdn.rebrickable.com/media/parts/elements/370321.jpg | 82 | 8678-1 | | 101 | 3703 | 14 | | 1 | 9684-1 | | 101 | 3703 | 14 | https://cdn.rebrickable.com/media/parts/elements/370324.jpg | 56 | 9871-1 | | 102 | 3705 | 0 | | 1 | 9684-1 | | 102 | 3705 | 0 | https://cdn.rebrickable.com/media/parts/elements/370526.jpg | 1531 | 4768-2 | | 103 | 3706 | 0 | | 1 | 9684-1 | | 103 | 3706 | 0 | https://cdn.rebrickable.com/media/parts/elements/370626.jpg | 1174 | 75060-1 | | 104 | 3707 | 0 | | 1 | 9684-1 | | 104 | 3707 | 0 | https://cdn.rebrickable.com/media/parts/elements/370726.jpg | 792 | 10189-1 | | 105 | 3708 | 0 | | 1 | 9684-1 | | 105 | 3708 | 0 | https://cdn.rebrickable.com/media/parts/elements/370826.jpg | 576 | 75060-1 | | 106 | 3709 | 0 | | 1 | 9684-1 | | 106 | 3709 | 0 | https://cdn.rebrickable.com/media/parts/elements/370926.jpg | 295 | 75060-1 | | 107 | 3710 | 0 | | 1 | 9684-1 | | 107 | 3710 | 0 | https://cdn.rebrickable.com/media/parts/elements/371026.jpg | 1856 | 30277-1 | | 108 | 3710 | 2 | | 1 | 9684-1 | | 108 | 3710 | 2 | https://cdn.rebrickable.com/media/parts/elements/371028.jpg | 331 | 21206-1 | | 109 | 3711a | 0 | | 1 | 9684-1 | | 109 | 3711a | 0 | https://cdn.rebrickable.com/media/parts/elements/371126.jpg | 40 | 9648-1 | | 110 | 3713 | 7 | | 1 | 9684-1 | | 110 | 3713 | 7 | https://cdn.rebrickable.com/media/parts/elements/4125313.jpg | 487 | 4094-1 | | 111 | 3736 | 7 | | 1 | 9684-1 | | 111 | 3736 | 7 | https://cdn.rebrickable.com/media/parts/elements/373602.jpg | 83 | 954-1 | | 112 | 3737 | 0 | | 1 | 9684-1 | | 112 | 3737 | 0 | https://cdn.rebrickable.com/media/parts/elements/373726.jpg | 650 | 10189-1 | | 113 | 3738 | 0 | | 1 | 9684-1 | | 113 | 3738 | 0 | https://cdn.rebrickable.com/media/parts/elements/373826.jpg | 172 | 75060-1 | | 114 | 3749 | 7 | | 1 | 9684-1 | | 114 | 3749 | 7 | https://cdn.rebrickable.com/media/parts/elements/4184168.jpg | 445 | 8223-1 | | 115 | 3832 | 0 | | 1 | 9684-1 | | 115 | 3832 | 0 | https://cdn.rebrickable.com/media/parts/elements/383226.jpg | 597 | 6909-1 | | 116 | 3894 | 4 | | 1 | 9684-1 | | 116 | 3894 | 4 | https://cdn.rebrickable.com/media/parts/elements/389421.jpg | 140 | 8652-1 | | 117 | 3894 | 14 | | 1 | 9684-1 | | 117 | 3894 | 14 | https://cdn.rebrickable.com/media/parts/elements/389424.jpg | 107 | 4888-1 | | 118 | 3895 | 4 | | 1 | 9684-1 | | 118 | 3895 | 4 | https://cdn.rebrickable.com/media/parts/elements/389521.jpg | 74 | 8680-1 | | 119 | 3895 | 14 | | 1 | 9684-1 | | 119 | 3895 | 14 | https://cdn.rebrickable.com/media/parts/elements/389524.jpg | 47 | 8710-1 | | 120 | 4079 | 15 | | 1 | 9684-1 | | 120 | 4079 | 15 | https://cdn.rebrickable.com/media/parts/ldraw/15/4079.png | 49 | 6386-1 | | 121 | 4080 | 14 | | 1 | 9684-1 | | 121 | 4080 | 14 | https://cdn.rebrickable.com/media/parts/elements/408024.jpg | 16 | 4201-1 | | 122 | 4162 | 0 | | 1 | 9684-1 | | 122 | 4162 | 0 | https://cdn.rebrickable.com/media/parts/elements/416226.jpg | 558 | 6435-1 | | 123 | 4185 | 7 | | 1 | 9684-1 | | 123 | 4185 | 7 | https://cdn.rebrickable.com/media/parts/elements/4100502.jpg | 173 | 8223-1 | | 124 | 4274 | 7 | | 1 | 9684-1 | | 124 | 4274 | 7 | https://cdn.rebrickable.com/media/parts/elements/427402.jpg | 292 | 10128-1 | | 125 | 4519 | 0 | | 1 | 9684-1 | | 125 | 4519 | 0 | https://cdn.rebrickable.com/media/parts/elements/451926.jpg | 303 | 8223-1 | | 126 | 4716 | 0 | | 1 | 9684-1 | | 126 | 4716 | 0 | https://cdn.rebrickable.com/media/parts/elements/471626.jpg | 108 | 5276-1 | | 127 | 5306bc020 | 0 | | 1 | 9684-1 | | 127 | 5306bc020 | 0 | https://cdn.rebrickable.com/media/parts/elements/4100355.jpg | 29 | 970654-1 | | 128 | 5306bc036 | 0 | | 1 | 9684-1 | | 128 | 5306bc036 | 0 | https://cdn.rebrickable.com/media/parts/ldraw/0/75652.png | 26 | 970654-1 | | 129 | 6035 | 15 | | 1 | 9684-1 | | 129 | 6035 | 15 | https://cdn.rebrickable.com/media/parts/elements/4603220.jpg | 38 | 9794-1 | | 130 | 6222 | 8 | | 1 | 9684-1 | | 130 | 6222 | 8 | https://cdn.rebrickable.com/media/parts/elements/4114075.jpg | 13 | 7152-1 | | 131 | 6536 | 7 | | 1 | 9684-1 | | 131 | 6536 | 7 | https://cdn.rebrickable.com/media/parts/elements/4173667.jpg | 127 | 10128-1 | | 132 | 6538b | 7 | | 1 | 9684-1 | | 132 | 6538b | 7 | https://cdn.rebrickable.com/media/parts/elements/4113804.jpg | 119 | 8223-1 | | 133 | 6553 | 7 | | 1 | 9684-1 | | 133 | 6553 | 7 | https://cdn.rebrickable.com/media/parts/elements/655302.jpg | 82 | 10128-1 | | 134 | 6558 | 0 | | 1 | 9684-1 | | 134 | 6558 | 0 | https://cdn.rebrickable.com/media/parts/elements/655826.jpg | 403 | 8103-1 | | 135 | 6575 | 7 | | 1 | 9684-1 | | 135 | 6575 | 7 | https://cdn.rebrickable.com/media/parts/elements/657502.jpg | 51 | 8448-1 | | 136 | 6587 | 8 | | 1 | 9684-1 | | 136 | 6587 | 8 | https://cdn.rebrickable.com/media/parts/elements/4113884.jpg | 203 | 4094-1 | | 137 | 6588 | 14 | | 1 | 9684-1 | | 137 | 6588 | 14 | https://cdn.rebrickable.com/media/parts/elements/658824.jpg | 16 | 9794-1 | | 138 | 6632 | 7 | | 1 | 9684-1 | | 138 | 6632 | 7 | https://cdn.rebrickable.com/media/parts/elements/4107825.jpg | 70 | 4094-1 | | 139 | 71427c01 | 7 | | 1 | 9684-1 | | 139 | 71427c01 | 7 | https://cdn.rebrickable.com/media/parts/ldraw/7/71427.png | 26 | 9794-1 | | 140 | 71509 | 0 | | 1 | 9684-1 | | 140 | 71509 | 0 | https://cdn.rebrickable.com/media/parts/elements/4107153.jpg | 121 | 3420-1 | | 141 | 73090b | 0 | | 1 | 9684-1 | | 141 | 73090b | 0 | https://cdn.rebrickable.com/media/parts/elements/6094053.jpg | 24 | 9607-1 | | 142 | 9912 | 2 | | 1 | 9684-1 | | 142 | 9912 | 2 | https://cdn.rebrickable.com/media/parts/ldraw/2/22578.png | 4 | 9681-1 | | 143 | upn0018pr0001 | 15 | | 1 | 9684-1 | | 143 | upn0018pr0001 | 15 | https://cdn.rebrickable.com/media/parts/photos/15/sailbb03-15-c13c5f4b-1ff8-4192-b12c-7cc9d1dede89.jpg | 5 | 6280-1 | | 144 | upn0370 | 0 | | 1 | 9684-1 | | 144 | upn0370 | 0 | https://cdn.rebrickable.com/media/parts/photos/0/rb00164-0-2bc201c2-f28b-4af4-b8bb-71f5c4a8efc3.jpg | 58 | 811-2 | +-----+---------------+----------+--------------------------------------------------------------------------------------------------------+----------+-----------------+