.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 | +---------------------+ -- Printed parts, which do not have image, while their unprinted counterparts have them. SELECT row_number() OVER () '#' , set_num example_set_num , ip.part_num part_num , ip.color_id color_id , pip.part_num plain_part_num , pip.img_url img_url FROM inventories i JOIN inventory_parts ip ON ip.inventory_id = i.id JOIN part_relationships r ON r.child_part_num = ip.part_num AND r.rel_type = 'P' JOIN inventory_parts pip ON pip.part_num = r.parent_part_num AND pip.color_id = ip.color_id WHERE ip.img_url IS NULL AND pip.img_url IS NOT NULL GROUP BY 3, 4, 5 ORDER BY 3, 4, 5; +-----+-------------------+---------------------+----------+----------------+-------------------------------------------------------------------------------------------------------------+ | # | example_set_num | part_num | color_id | plain_part_num | img_url | +-----+-------------------+---------------------+----------+----------------+-------------------------------------------------------------------------------------------------------------+ | 1 | LEGO-Modulex-1 | 1082pr0017 | 1013 | 1082 | https://cdn.rebrickable.com/media/parts/photos/1013/1082-1013-d1cc4cc6-b9b1-4b56-8b10-f148c1729f24.jpg | | 2 | 6399469-1 | 14718pr9997 | 14 | 14718 | https://cdn.rebrickable.com/media/parts/elements/6299765.jpg | | 3 | 6384346-1 | 14718pr9998 | 14 | 14718 | https://cdn.rebrickable.com/media/parts/elements/6299765.jpg | | 4 | 1017-1 | 2756pr0019 | 15 | 2756 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | | 5 | 1017-1 | 2756pr0020 | 15 | 2756 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | | 6 | 1017-1 | 2756pr0021 | 15 | 2756 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | | 7 | 1017-1 | 2756pr0022 | 15 | 2756 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | | 8 | 1017-1 | 2756pr0023 | 15 | 2756 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | | 9 | 1017-1 | 2756pr0024 | 15 | 2756 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | | 10 | 1017-1 | 2756pr0025 | 15 | 2756 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | | 11 | 1017-1 | 2756pr0026 | 15 | 2756 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | | 12 | 1017-1 | 2756pr0027 | 15 | 2756 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | | 13 | 1017-1 | 2756pr0028 | 15 | 2756 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | | 14 | 1017-1 | 2756pr0029 | 15 | 2756 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | | 15 | 1017-1 | 2756pr0030 | 15 | 2756 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | | 16 | 1017-1 | 2756pr0031 | 15 | 2756 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | | 17 | 1017-1 | 2756pr0032 | 15 | 2756 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | | 18 | 1017-1 | 2756pr0033 | 15 | 2756 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | | 19 | 1017-1 | 2756pr0034 | 15 | 2756 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | | 20 | 1017-1 | 2756pr0035 | 15 | 2756 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | | 21 | 1017-1 | 2756pr0036 | 15 | 2756 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | | 22 | 1017-1 | 2756pr0037 | 15 | 2756 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | | 23 | 1017-1 | 2756pr0038 | 15 | 2756 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | | 24 | 1017-1 | 2756pr0039 | 15 | 2756 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | | 25 | 1017-1 | 2756pr0040 | 15 | 2756 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | | 26 | 1017-1 | 2756pr0041 | 15 | 2756 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | | 27 | 1017-1 | 2756pr0042 | 15 | 2756 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | | 28 | 1017-1 | 2756pr0043 | 15 | 2756 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | | 29 | 1017-1 | 2756pr0044 | 15 | 2756 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | | 30 | 1017-1 | 2756pr0045 | 15 | 2756 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | | 31 | 1017-1 | 2756pr0046 | 15 | 2756 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | | 32 | 1017-1 | 2756pr0047 | 15 | 2756 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | | 33 | 1017-1 | 2756pr0048 | 15 | 2756 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | | 34 | 1017-1 | 2756pr0049 | 15 | 2756 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | | 35 | 1017-1 | 2756pr0051 | 15 | 2756 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | | 36 | 1017-1 | 2756pr0052 | 15 | 2756 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | | 37 | 1017-1 | 2756pr0053 | 15 | 2756 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | | 38 | 1017-1 | 2756pr0054 | 15 | 2756 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | | 39 | 1017-1 | 2756pr0055 | 15 | 2756 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | | 40 | 1017-1 | 2756pr0056 | 15 | 2756 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | | 41 | 1017-1 | 2756pr0057 | 15 | 2756 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | | 42 | 1017-1 | 2756pr0058 | 15 | 2756 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | | 43 | 1017-1 | 2756pr0059 | 15 | 2756 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | | 44 | 1017-1 | 2756pr0060 | 15 | 2756 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | | 45 | 1017-1 | 2756pr0061 | 15 | 2756 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | | 46 | 1017-1 | 2756pr0062 | 15 | 2756 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | | 47 | 1015-1 | 2756pr0063 | 15 | 2756 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | | 48 | 1017-1 | 2756pr0064 | 15 | 2756 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | | 49 | 1017-1 | 2756pr0065 | 15 | 2756 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | | 50 | 1017-1 | 2756pr0066 | 15 | 2756 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | | 51 | 1017-1 | 2756pr0067 | 15 | 2756 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | | 52 | 1017-1 | 2756pr0069 | 15 | 2756 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | | 53 | 1015-1 | 2756pr0070 | 15 | 2756 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | | 54 | 1015-1 | 2756pr0071 | 15 | 2756 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | | 55 | 1015-1 | 2756pr0072 | 15 | 2756 | https://cdn.rebrickable.com/media/parts/ldraw/15/2756.png | | 56 | fig-015494 | 28621pr9854 | 78 | 28621 | https://cdn.rebrickable.com/media/parts/elements/6448393.jpg | | 57 | fig-015492 | 28621pr9855 | 15 | 28621 | https://cdn.rebrickable.com/media/parts/elements/6454713.jpg | | 58 | 9021-1 | 29541pr0001 | 14 | 29541 | https://cdn.rebrickable.com/media/parts/elements/4238365.jpg | | 59 | NINJAGOSPINNER-1 | 3068bpr9983 | 15 | 3068b | https://cdn.rebrickable.com/media/parts/elements/306801.jpg | | 60 | 6315025-1 | 3245cpr9994 | 15 | 3245c | https://cdn.rebrickable.com/media/parts/elements/4113261.jpg | | 61 | 6278983-1 | 3245cpr9995 | 15 | 3245c | https://cdn.rebrickable.com/media/parts/elements/4113261.jpg | | 62 | 6270050-1 | 3245cpr9996 | 15 | 3245c | https://cdn.rebrickable.com/media/parts/elements/4113261.jpg | | 63 | fig-015496 | 36036pr9981 | 4 | 36036 | https://cdn.rebrickable.com/media/parts/ldraw/4/36036.png | | 64 | fig-010366 | 3623pr9998 | 29 | 3623 | https://cdn.rebrickable.com/media/parts/elements/6036788.jpg | | 65 | COMCON040-1 | 3623pr9999 | 29 | 3623 | https://cdn.rebrickable.com/media/parts/elements/6036788.jpg | | 66 | fig-000429 | 3626bpr0107 | 14 | 3626b | https://cdn.rebrickable.com/media/parts/ldraw/14/3626b.png | | 67 | 4301-1 | 3626bpr0114 | 14 | 3626b | https://cdn.rebrickable.com/media/parts/ldraw/14/3626b.png | | 68 | fig-001099 | 3626cpr0017 | 78 | 3626c | https://cdn.rebrickable.com/media/parts/elements/4238519.jpg | | 69 | 9234-1 | 45896pr0013 | 14 | 45896 | https://cdn.rebrickable.com/media/parts/photos/14/dupupn0008-14-03d3325f-b235-4249-8ca2-0bab1240734c.jpg | | 70 | 5595-1 | 53491pr0001 | 272 | 53491 | https://cdn.rebrickable.com/media/parts/photos/272/53491-272-303d795d-8853-4b8d-ba5e-9e86d218032e.jpg | | 71 | 7581-1 | 6171pr0006 | 0 | 6171 | https://cdn.rebrickable.com/media/parts/photos/6/6171pr02-6-2869a4a4-e3d8-4c37-abf9-1942c69774d5.jpg | | 72 | 5880-1 | 6171pr0008 | 15 | 6171 | https://cdn.rebrickable.com/media/parts/photos/6/6171pr02-6-2869a4a4-e3d8-4c37-abf9-1942c69774d5.jpg | | 73 | 3420-1 | 72824pr0002 | 15 | 72824 | https://cdn.rebrickable.com/media/parts/elements/6018511.jpg | | 74 | 10433-1 | 76371pr9903 | 15 | 76371 | https://cdn.rebrickable.com/media/parts/elements/6101121.jpg | | 75 | 10435-1 | 76371pr9911 | 41 | 76371 | https://cdn.rebrickable.com/media/parts/elements/6055533.jpg | | 76 | 853967-2 | 853967pr0001 | 9999 | 853967 | https://cdn.rebrickable.com/media/parts/photos/9999/PART-5871-9999-1e07fe0a-aa3a-4e80-8480-e266e8beb074.jpg | | 77 | fig-010960 | 970c03pr9838 | 0 | 970c03 | https://cdn.rebrickable.com/media/parts/elements/4569093.jpg | | 78 | fig-010740 | 970c03pr9845 | 0 | 970c03 | https://cdn.rebrickable.com/media/parts/elements/4569093.jpg | | 79 | fig-000463 | 970c03pr9887 | 0 | 970c03 | https://cdn.rebrickable.com/media/parts/elements/4569093.jpg | | 80 | fig-002016 | 970c03pr9906 | 0 | 970c03 | https://cdn.rebrickable.com/media/parts/elements/4569093.jpg | | 81 | fig-006534 | 970c05pr9984 | 272 | 970c05 | https://cdn.rebrickable.com/media/parts/elements/4162916.jpg | | 82 | fig-011246 | 970c10pr9823 | 320 | 970c10 | https://cdn.rebrickable.com/media/parts/elements/4501556.jpg | | 83 | fig-015366 | 970c12pr0001 | 72 | 970c12 | https://cdn.rebrickable.com/media/parts/elements/4222693.jpg | | 84 | fig-001985 | 970c19pr9902 | 70 | 970c19 | https://cdn.rebrickable.com/media/parts/elements/4221886.jpg | | 85 | fig-010952 | 970c22pr9842 | 4 | 970c22 | https://cdn.rebrickable.com/media/parts/elements/4582576.jpg | | 86 | fig-015169 | 970c27pr0014 | 15 | 970c27 | https://cdn.rebrickable.com/media/parts/elements/4570434.jpg | | 87 | fig-003675 | 970c27pr0040 | 15 | 970c27 | https://cdn.rebrickable.com/media/parts/elements/4570434.jpg | | 88 | fig-001858 | 970c28pr9908 | 1 | 970c28 | https://cdn.rebrickable.com/media/parts/elements/4583501.jpg | | 89 | fig-006249 | 973c02h02pr9699 | 0 | 973c02h02 | https://cdn.rebrickable.com/media/parts/elements/6353563.jpg | | 90 | fig-000305 | 973c03h03pr0908 | 0 | 973c03h03 | https://cdn.rebrickable.com/media/parts/elements/4647383.jpg | | 91 | fig-000152 | 973c17h17pr0335 | 7 | 973c17h17 | https://cdn.rebrickable.com/media/parts/ldraw/7/973c17h17.png | | 92 | FLATIRON-1 | 973c22h01pr1445 | 4 | 973c22h01 | https://cdn.rebrickable.com/media/parts/elements/4275872.jpg | | 93 | FLATIRON-1 | 973c24h01pr0121 | 379 | 973c24h01 | https://cdn.rebrickable.com/media/parts/elements/4519938.jpg | | 94 | fig-008467 | 973c24h01pr9713 | 379 | 973c24h01 | https://cdn.rebrickable.com/media/parts/elements/4519938.jpg | | 95 | Build-a-Mini-2021 | 973c27h01pr0032 | 15 | 973c27h01 | https://cdn.rebrickable.com/media/parts/elements/4275461.jpg | | 96 | fig-006940 | 973c27h01pr0213 | 15 | 973c27h01 | https://cdn.rebrickable.com/media/parts/elements/4275461.jpg | | 97 | fig-010133 | 973c27h01pr1134 | 15 | 973c27h01 | https://cdn.rebrickable.com/media/parts/elements/4275461.jpg | | 98 | fig-010801 | 973c27h14pr0001 | 15 | 973c27h14 | https://cdn.rebrickable.com/media/parts/elements/6445602.jpg | | 99 | fig-015296 | 973c27h27pr0010 | 15 | 973c27h27 | https://cdn.rebrickable.com/media/parts/elements/6009516.jpg | | 100 | fig-010210 | 973c31h01pr9700 | 2 | 973c31h01 | https://cdn.rebrickable.com/media/parts/elements/6185629.jpg | | 101 | 4659612-1 | 98342pr0006 | 27 | 98342 | https://cdn.rebrickable.com/media/parts/elements/4647108.jpg | | 102 | 1518-2 | penupn0003pr0004 | 0 | penupn0003 | https://cdn.rebrickable.com/media/parts/photos/0/penupn0003-0-027fb02a-72cf-42a7-bf4d-347c5b207006.jpg | | 103 | 1524-2 | penupn0003pr0008 | 1 | penupn0003 | https://cdn.rebrickable.com/media/parts/photos/1/penupn0003-1-3246e589-6c32-40c1-8786-eac002071782.jpg | | 104 | 1524-2 | penupn0003pr0010 | 4 | penupn0003 | https://cdn.rebrickable.com/media/parts/photos/4/penupn0003-4-5e3ca544-7066-4062-93c8-b11da4686ac2.jpg | | 105 | 1702-2 | penupn0003pr0015 | 0 | penupn0003 | https://cdn.rebrickable.com/media/parts/photos/0/penupn0003-0-027fb02a-72cf-42a7-bf4d-347c5b207006.jpg | | 106 | 1734-1 | penupn0003pr0021 | 2 | penupn0003 | https://cdn.rebrickable.com/media/parts/photos/2/penupn0003-2-9e3e6c08-cff0-40da-93b3-8e34495a5f0e.jpg | | 107 | 1733-2 | penupn0003pr0021 | 25 | penupn0003 | https://cdn.rebrickable.com/media/parts/photos/25/penupn0003-25-dabb42ba-d53d-4203-96bf-255a4b9a49b2.jpg | | 108 | 1530-1 | penupn0003pr0022 | 4 | penupn0003 | https://cdn.rebrickable.com/media/parts/photos/4/penupn0003-4-5e3ca544-7066-4062-93c8-b11da4686ac2.jpg | | 109 | 1534-1 | penupn0003pr0023 | 15 | penupn0003 | https://cdn.rebrickable.com/media/parts/photos/15/penupn0003-15-3d6f7f69-f68d-41b5-804a-d767c582e501.jpg | | 110 | 1538-1 | penupn0003pr0024 | 25 | penupn0003 | https://cdn.rebrickable.com/media/parts/photos/25/penupn0003-25-dabb42ba-d53d-4203-96bf-255a4b9a49b2.jpg | | 111 | 1538-1 | penupn0003pr0025 | 25 | penupn0003 | https://cdn.rebrickable.com/media/parts/photos/25/penupn0003-25-dabb42ba-d53d-4203-96bf-255a4b9a49b2.jpg | | 112 | 1708-2 | penupn0003pr0029 | 42 | penupn0003 | https://cdn.rebrickable.com/media/parts/photos/42/penupn0003-42-5ade2fc0-a827-4f3b-acc9-e27209a8d454.jpg | | 113 | 1542-1 | penupn0003pr0030 | 4 | penupn0003 | https://cdn.rebrickable.com/media/parts/photos/4/penupn0003-4-5e3ca544-7066-4062-93c8-b11da4686ac2.jpg | | 114 | 1542-1 | penupn0003pr0031 | 0 | penupn0003 | https://cdn.rebrickable.com/media/parts/photos/0/penupn0003-0-027fb02a-72cf-42a7-bf4d-347c5b207006.jpg | | 115 | 1542-1 | penupn0003pr0033 | 4 | penupn0003 | https://cdn.rebrickable.com/media/parts/photos/4/penupn0003-4-5e3ca544-7066-4062-93c8-b11da4686ac2.jpg | | 116 | 1546-2 | penupn0003pr0034 | 0 | penupn0003 | https://cdn.rebrickable.com/media/parts/photos/0/penupn0003-0-027fb02a-72cf-42a7-bf4d-347c5b207006.jpg | | 117 | 1709-1 | penupn0003pr0037 | 0 | penupn0003 | https://cdn.rebrickable.com/media/parts/photos/0/penupn0003-0-027fb02a-72cf-42a7-bf4d-347c5b207006.jpg | | 118 | 1713-2 | penupn0003pr0040 | 0 | penupn0003 | https://cdn.rebrickable.com/media/parts/photos/0/penupn0003-0-027fb02a-72cf-42a7-bf4d-347c5b207006.jpg | | 119 | 1730-2 | penupn0003pr0041 | 0 | penupn0003 | https://cdn.rebrickable.com/media/parts/photos/0/penupn0003-0-027fb02a-72cf-42a7-bf4d-347c5b207006.jpg | | 120 | 1727-2 | penupn0003pr0042 | 47 | penupn0003 | https://cdn.rebrickable.com/media/parts/photos/47/penupn0003-47-d35fd41e-9961-4e33-ba0d-94b369abbdde.jpg | | 121 | 1715-3 | penupn0003pr0044 | 0 | penupn0003 | https://cdn.rebrickable.com/media/parts/photos/0/penupn0003-0-027fb02a-72cf-42a7-bf4d-347c5b207006.jpg | | 122 | 3503-2 | penupn0003pr0044 | 33 | penupn0003 | https://cdn.rebrickable.com/media/parts/photos/33/penupn0003-33-f5d18be1-b1f7-4ffe-af54-e12c51910143.jpg | | 123 | 1715-3 | penupn0003pr0045 | 1 | penupn0003 | https://cdn.rebrickable.com/media/parts/photos/1/penupn0003-1-3246e589-6c32-40c1-8786-eac002071782.jpg | | 124 | 1712-2 | penupn0003pr0047 | 0 | penupn0003 | https://cdn.rebrickable.com/media/parts/photos/0/penupn0003-0-027fb02a-72cf-42a7-bf4d-347c5b207006.jpg | | 125 | 2851135-1 | penupn0003pr0048 | 0 | penupn0003 | https://cdn.rebrickable.com/media/parts/photos/0/penupn0003-0-027fb02a-72cf-42a7-bf4d-347c5b207006.jpg | | 126 | 1714-2 | penupn0003pr0049 | 15 | penupn0003 | https://cdn.rebrickable.com/media/parts/photos/15/penupn0003-15-3d6f7f69-f68d-41b5-804a-d767c582e501.jpg | | 127 | 1718-1 | penupn0003pr0050 | 0 | penupn0003 | https://cdn.rebrickable.com/media/parts/photos/0/penupn0003-0-027fb02a-72cf-42a7-bf4d-347c5b207006.jpg | | 128 | 1716-2 | penupn0003pr0050 | 15 | penupn0003 | https://cdn.rebrickable.com/media/parts/photos/15/penupn0003-15-3d6f7f69-f68d-41b5-804a-d767c582e501.jpg | | 129 | 1720-2 | penupn0003pr0051 | 4 | penupn0003 | https://cdn.rebrickable.com/media/parts/photos/4/penupn0003-4-5e3ca544-7066-4062-93c8-b11da4686ac2.jpg | | 130 | 1717-1 | penupn0003pr0052 | 2 | penupn0003 | https://cdn.rebrickable.com/media/parts/photos/2/penupn0003-2-9e3e6c08-cff0-40da-93b3-8e34495a5f0e.jpg | | 131 | 1732-2 | penupn0003pr0054 | 14 | penupn0003 | https://cdn.rebrickable.com/media/parts/photos/14/penupn0003-14-4dfd40c0-d752-435f-b591-a21874e30687.jpg | | 132 | 1732-2 | penupn0003pr0055 | 383 | penupn0003 | https://cdn.rebrickable.com/media/parts/photos/383/penupn0003-383-6932c775-afa4-4c25-ace0-1b814c75dadd.jpg | | 133 | 1728-2 | penupn0003pr0056 | 0 | penupn0003 | https://cdn.rebrickable.com/media/parts/photos/0/penupn0003-0-027fb02a-72cf-42a7-bf4d-347c5b207006.jpg | | 134 | 2032-2 | penupn0003pr0059 | 15 | penupn0003 | https://cdn.rebrickable.com/media/parts/photos/15/penupn0003-15-3d6f7f69-f68d-41b5-804a-d767c582e501.jpg | | 135 | 2032-2 | penupn0003pr0060 | 15 | penupn0003 | https://cdn.rebrickable.com/media/parts/photos/15/penupn0003-15-3d6f7f69-f68d-41b5-804a-d767c582e501.jpg | | 136 | 2032-2 | penupn0003pr0061 | 25 | penupn0003 | https://cdn.rebrickable.com/media/parts/photos/25/penupn0003-25-dabb42ba-d53d-4203-96bf-255a4b9a49b2.jpg | | 137 | 2032-2 | penupn0003pr0062 | 1 | penupn0003 | https://cdn.rebrickable.com/media/parts/photos/1/penupn0003-1-3246e589-6c32-40c1-8786-eac002071782.jpg | | 138 | 2032-2 | penupn0003pr0064 | 1 | penupn0003 | https://cdn.rebrickable.com/media/parts/photos/1/penupn0003-1-3246e589-6c32-40c1-8786-eac002071782.jpg | | 139 | 2032-2 | penupn0003pr0065 | 15 | penupn0003 | https://cdn.rebrickable.com/media/parts/photos/15/penupn0003-15-3d6f7f69-f68d-41b5-804a-d767c582e501.jpg | | 140 | 2030-1 | penupn0003pr0067 | 2 | penupn0003 | https://cdn.rebrickable.com/media/parts/photos/2/penupn0003-2-9e3e6c08-cff0-40da-93b3-8e34495a5f0e.jpg | | 141 | 2030-1 | penupn0003pr0068 | 25 | penupn0003 | https://cdn.rebrickable.com/media/parts/photos/25/penupn0003-25-dabb42ba-d53d-4203-96bf-255a4b9a49b2.jpg | | 142 | 2030-1 | penupn0003pr0069 | 1 | penupn0003 | https://cdn.rebrickable.com/media/parts/photos/1/penupn0003-1-3246e589-6c32-40c1-8786-eac002071782.jpg | | 143 | 1735-1 | penupn0003pr0074 | 2 | penupn0003 | https://cdn.rebrickable.com/media/parts/photos/2/penupn0003-2-9e3e6c08-cff0-40da-93b3-8e34495a5f0e.jpg | | 144 | 3114-2 | penupn0003pr0078 | 0 | penupn0003 | https://cdn.rebrickable.com/media/parts/photos/0/penupn0003-0-027fb02a-72cf-42a7-bf4d-347c5b207006.jpg | | 145 | 3114-2 | penupn0003pr0079 | 4 | penupn0003 | https://cdn.rebrickable.com/media/parts/photos/4/penupn0003-4-5e3ca544-7066-4062-93c8-b11da4686ac2.jpg | | 146 | 1518-2 | penupn0004pr0006 | 14 | penupn0004 | https://cdn.rebrickable.com/media/parts/photos/14/penupn0004-14-ec167cf3-7f43-4d54-b194-93275a0cdf2f.jpg | | 147 | 1518-2 | penupn0004pr0007 | 4 | penupn0004 | https://cdn.rebrickable.com/media/parts/photos/4/penupn0004-4-a5caf2d7-07cc-4282-9a63-269a9bd45884.jpg | | 148 | 1518-2 | penupn0004pr0008 | 2 | penupn0004 | https://cdn.rebrickable.com/media/parts/photos/2/penupn0004-2-ed3252d2-0cbe-4bc8-921a-f570fa49b025.jpg | | 149 | 1524-2 | penupn0004pr0016 | 2 | penupn0004 | https://cdn.rebrickable.com/media/parts/photos/2/penupn0004-2-ed3252d2-0cbe-4bc8-921a-f570fa49b025.jpg | | 150 | 1524-2 | penupn0004pr0017 | 4 | penupn0004 | https://cdn.rebrickable.com/media/parts/photos/4/penupn0004-4-a5caf2d7-07cc-4282-9a63-269a9bd45884.jpg | | 151 | 1524-2 | penupn0004pr0018 | 1 | penupn0004 | https://cdn.rebrickable.com/media/parts/photos/1/penupn0004-1-0a822a74-5021-43a0-bdeb-649852ee370a.jpg | | 152 | 1543-2 | penupn0004pr0025 | 45 | penupn0004 | https://cdn.rebrickable.com/media/parts/photos/1/penupn0004-1-0a822a74-5021-43a0-bdeb-649852ee370a.jpg | | 153 | 1543-2 | penupn0004pr0027 | 9 | penupn0004 | https://cdn.rebrickable.com/media/parts/photos/1/penupn0004-1-0a822a74-5021-43a0-bdeb-649852ee370a.jpg | | 154 | 1703-2 | penupn0004pr0039 | 27 | penupn0004 | https://cdn.rebrickable.com/media/parts/photos/27/penupn0004-27-b40d976f-b3b0-4371-9583-070b0fe17eac.jpg | | 155 | 1703-2 | penupn0004pr0040 | 27 | penupn0004 | https://cdn.rebrickable.com/media/parts/photos/27/penupn0004-27-b40d976f-b3b0-4371-9583-070b0fe17eac.jpg | | 156 | 1702-2 | penupn0004pr0047 | 15 | penupn0004 | https://cdn.rebrickable.com/media/parts/photos/15/penupn0004-15-11ee449e-9246-41f9-bf2f-e58df96c54dd.jpg | | 157 | 1702-2 | penupn0004pr0050 | 15 | penupn0004 | https://cdn.rebrickable.com/media/parts/photos/15/penupn0004-15-11ee449e-9246-41f9-bf2f-e58df96c54dd.jpg | | 158 | 1706-1 | penupn0004pr0055 | 4 | penupn0004 | https://cdn.rebrickable.com/media/parts/photos/4/penupn0004-4-a5caf2d7-07cc-4282-9a63-269a9bd45884.jpg | | 159 | 1734-1 | penupn0004pr0059 | 27 | penupn0004 | https://cdn.rebrickable.com/media/parts/photos/27/penupn0004-27-b40d976f-b3b0-4371-9583-070b0fe17eac.jpg | | 160 | 1530-1 | penupn0004pr0063 | 4 | penupn0004 | https://cdn.rebrickable.com/media/parts/photos/4/penupn0004-4-a5caf2d7-07cc-4282-9a63-269a9bd45884.jpg | | 161 | 1534-1 | penupn0004pr0064 | 15 | penupn0004 | https://cdn.rebrickable.com/media/parts/photos/15/penupn0004-15-11ee449e-9246-41f9-bf2f-e58df96c54dd.jpg | | 162 | 1534-1 | penupn0004pr0066 | 1 | penupn0004 | https://cdn.rebrickable.com/media/parts/photos/1/penupn0004-1-0a822a74-5021-43a0-bdeb-649852ee370a.jpg | | 163 | 1538-1 | penupn0004pr0068 | 15 | penupn0004 | https://cdn.rebrickable.com/media/parts/photos/15/penupn0004-15-11ee449e-9246-41f9-bf2f-e58df96c54dd.jpg | | 164 | 1538-1 | penupn0004pr0069 | 2 | penupn0004 | https://cdn.rebrickable.com/media/parts/photos/2/penupn0004-2-ed3252d2-0cbe-4bc8-921a-f570fa49b025.jpg | | 165 | 1532-1 | penupn0004pr0072 | 27 | penupn0004 | https://cdn.rebrickable.com/media/parts/photos/27/penupn0004-27-b40d976f-b3b0-4371-9583-070b0fe17eac.jpg | | 166 | 1535-1 | penupn0004pr0074 | 1 | penupn0004 | https://cdn.rebrickable.com/media/parts/photos/1/penupn0004-1-0a822a74-5021-43a0-bdeb-649852ee370a.jpg | | 167 | 1535-1 | penupn0004pr0076 | 2 | penupn0004 | https://cdn.rebrickable.com/media/parts/photos/2/penupn0004-2-ed3252d2-0cbe-4bc8-921a-f570fa49b025.jpg | | 168 | 1535-1 | penupn0004pr0077 | 9 | penupn0004 | https://cdn.rebrickable.com/media/parts/photos/1/penupn0004-1-0a822a74-5021-43a0-bdeb-649852ee370a.jpg | | 169 | 1535-1 | penupn0004pr0078 | 9 | penupn0004 | https://cdn.rebrickable.com/media/parts/photos/1/penupn0004-1-0a822a74-5021-43a0-bdeb-649852ee370a.jpg | | 170 | 1535-1 | penupn0004pr0080 | 4 | penupn0004 | https://cdn.rebrickable.com/media/parts/photos/4/penupn0004-4-a5caf2d7-07cc-4282-9a63-269a9bd45884.jpg | | 171 | 1542-1 | penupn0004pr0084 | 4 | penupn0004 | https://cdn.rebrickable.com/media/parts/photos/4/penupn0004-4-a5caf2d7-07cc-4282-9a63-269a9bd45884.jpg | | 172 | 1542-1 | penupn0004pr0085 | 4 | penupn0004 | https://cdn.rebrickable.com/media/parts/photos/4/penupn0004-4-a5caf2d7-07cc-4282-9a63-269a9bd45884.jpg | | 173 | 1542-1 | penupn0004pr0086 | 1 | penupn0004 | https://cdn.rebrickable.com/media/parts/photos/1/penupn0004-1-0a822a74-5021-43a0-bdeb-649852ee370a.jpg | | 174 | 1542-1 | penupn0004pr0087 | 14 | penupn0004 | https://cdn.rebrickable.com/media/parts/photos/14/penupn0004-14-ec167cf3-7f43-4d54-b194-93275a0cdf2f.jpg | | 175 | 1542-1 | penupn0004pr0088 | 1 | penupn0004 | https://cdn.rebrickable.com/media/parts/photos/1/penupn0004-1-0a822a74-5021-43a0-bdeb-649852ee370a.jpg | | 176 | 1729-2 | penupn0004pr0094 | 4 | penupn0004 | https://cdn.rebrickable.com/media/parts/photos/4/penupn0004-4-a5caf2d7-07cc-4282-9a63-269a9bd45884.jpg | | 177 | 1730-2 | penupn0004pr0102 | 1 | penupn0004 | https://cdn.rebrickable.com/media/parts/photos/1/penupn0004-1-0a822a74-5021-43a0-bdeb-649852ee370a.jpg | | 178 | 1730-2 | penupn0004pr0103 | 1 | penupn0004 | https://cdn.rebrickable.com/media/parts/photos/1/penupn0004-1-0a822a74-5021-43a0-bdeb-649852ee370a.jpg | | 179 | 1727-2 | penupn0004pr0105 | 0 | penupn0004 | https://cdn.rebrickable.com/media/parts/photos/1/penupn0004-1-0a822a74-5021-43a0-bdeb-649852ee370a.jpg | | 180 | 1717-1 | penupn0004pr0122 | 27 | penupn0004 | https://cdn.rebrickable.com/media/parts/photos/27/penupn0004-27-b40d976f-b3b0-4371-9583-070b0fe17eac.jpg | | 181 | 1717-1 | penupn0004pr0123 | 27 | penupn0004 | https://cdn.rebrickable.com/media/parts/photos/27/penupn0004-27-b40d976f-b3b0-4371-9583-070b0fe17eac.jpg | | 182 | 1732-2 | penupn0004pr0126 | 1 | penupn0004 | https://cdn.rebrickable.com/media/parts/photos/1/penupn0004-1-0a822a74-5021-43a0-bdeb-649852ee370a.jpg | | 183 | 1731-2 | penupn0004pr0130 | 4 | penupn0004 | https://cdn.rebrickable.com/media/parts/photos/4/penupn0004-4-a5caf2d7-07cc-4282-9a63-269a9bd45884.jpg | | 184 | 2035-1 | penupn0004pr0131 | 2 | penupn0004 | https://cdn.rebrickable.com/media/parts/photos/2/penupn0004-2-ed3252d2-0cbe-4bc8-921a-f570fa49b025.jpg | | 185 | 2035-1 | penupn0004pr0132 | 4 | penupn0004 | https://cdn.rebrickable.com/media/parts/photos/4/penupn0004-4-a5caf2d7-07cc-4282-9a63-269a9bd45884.jpg | | 186 | 2035-1 | penupn0004pr0133 | 1 | penupn0004 | https://cdn.rebrickable.com/media/parts/photos/1/penupn0004-1-0a822a74-5021-43a0-bdeb-649852ee370a.jpg | | 187 | 2032-2 | penupn0004pr0134 | 0 | penupn0004 | https://cdn.rebrickable.com/media/parts/photos/1/penupn0004-1-0a822a74-5021-43a0-bdeb-649852ee370a.jpg | | 188 | 2032-2 | penupn0004pr0135 | 0 | penupn0004 | https://cdn.rebrickable.com/media/parts/photos/1/penupn0004-1-0a822a74-5021-43a0-bdeb-649852ee370a.jpg | | 189 | 2032-2 | penupn0004pr0136 | 0 | penupn0004 | https://cdn.rebrickable.com/media/parts/photos/1/penupn0004-1-0a822a74-5021-43a0-bdeb-649852ee370a.jpg | | 190 | 2032-2 | penupn0004pr0137 | 0 | penupn0004 | https://cdn.rebrickable.com/media/parts/photos/1/penupn0004-1-0a822a74-5021-43a0-bdeb-649852ee370a.jpg | | 191 | 2032-2 | penupn0004pr0138 | 15 | penupn0004 | https://cdn.rebrickable.com/media/parts/photos/15/penupn0004-15-11ee449e-9246-41f9-bf2f-e58df96c54dd.jpg | | 192 | 2033-2 | penupn0004pr0144 | 0 | penupn0004 | https://cdn.rebrickable.com/media/parts/photos/1/penupn0004-1-0a822a74-5021-43a0-bdeb-649852ee370a.jpg | | 193 | 3503-2 | penupn0004pr0146 | 0 | penupn0004 | https://cdn.rebrickable.com/media/parts/photos/1/penupn0004-1-0a822a74-5021-43a0-bdeb-649852ee370a.jpg | | 194 | 1735-1 | penupn0004pr0147 | 14 | penupn0004 | https://cdn.rebrickable.com/media/parts/photos/14/penupn0004-14-ec167cf3-7f43-4d54-b194-93275a0cdf2f.jpg | | 195 | 3103-2 | penupn0004pr0149 | 1 | penupn0004 | https://cdn.rebrickable.com/media/parts/photos/1/penupn0004-1-0a822a74-5021-43a0-bdeb-649852ee370a.jpg | | 196 | 3110-2 | penupn0004pr0154 | 4 | penupn0004 | https://cdn.rebrickable.com/media/parts/photos/4/penupn0004-4-a5caf2d7-07cc-4282-9a63-269a9bd45884.jpg | | 197 | 3114-2 | penupn0004pr0155 | 1 | penupn0004 | https://cdn.rebrickable.com/media/parts/photos/1/penupn0004-1-0a822a74-5021-43a0-bdeb-649852ee370a.jpg | | 198 | 2155-2 | penupn0006pr0004 | 71 | penupn0006 | https://cdn.rebrickable.com/media/parts/photos/47/penupn0006-47-cf2c3bc8-6489-4906-aa7e-31048d32b978.jpg | | 199 | 1733-2 | penupn0006pr0044 | 19 | penupn0006 | https://cdn.rebrickable.com/media/parts/photos/47/penupn0006-47-cf2c3bc8-6489-4906-aa7e-31048d32b978.jpg | | 200 | 1720-2 | penupn0006pr0047 | 25 | penupn0006 | https://cdn.rebrickable.com/media/parts/photos/47/penupn0006-47-cf2c3bc8-6489-4906-aa7e-31048d32b978.jpg | | 201 | 1719-2 | penupn0006pr0049 | 19 | penupn0006 | https://cdn.rebrickable.com/media/parts/photos/47/penupn0006-47-cf2c3bc8-6489-4906-aa7e-31048d32b978.jpg | | 202 | 3114-2 | penupn0006pr0059 | 4 | penupn0006 | https://cdn.rebrickable.com/media/parts/photos/4/penupn0006-4-8ec028bf-e584-433c-9ec3-fde3a6d99b76.jpg | | 203 | 1713-2 | penupn0010pr0001 | 110 | penupn0010 | https://cdn.rebrickable.com/media/parts/photos/110/penupn0010-110-3f195839-8e32-42cb-b82f-924a4b722a4d.jpg | | 204 | 1733-2 | penupn0010pr0002 | 19 | penupn0010 | https://cdn.rebrickable.com/media/parts/photos/110/penupn0010-110-3f195839-8e32-42cb-b82f-924a4b722a4d.jpg | | 205 | 1714-2 | penupn0010pr0003 | 15 | penupn0010 | https://cdn.rebrickable.com/media/parts/photos/110/penupn0010-110-3f195839-8e32-42cb-b82f-924a4b722a4d.jpg | | 206 | 1728-2 | penupn0036c06pr0001 | 0 | penupn0036c06 | https://cdn.rebrickable.com/media/parts/photos/0/penupn0036c06-0-413c68c8-d0e0-40c5-b2d8-0248b6693f24.jpg | | 207 | 1718-1 | penupn0036c08pr0001 | 0 | penupn0036c08 | https://cdn.rebrickable.com/media/parts/photos/0/penupn0036c08-0-56451fc6-917c-41f2-b74e-3468134bb289.jpg | | 208 | 5005614-1 | upn0379pr0002 | 30 | upn0379 | https://cdn.rebrickable.com/media/parts/photos/0/upn0379-0-7e03b117-83e7-4f17-ad7b-6f11bc0188a4.jpg | | 209 | 5005614-1 | upn0379pr0003 | 29 | upn0379 | https://cdn.rebrickable.com/media/parts/photos/0/upn0379-0-7e03b117-83e7-4f17-ad7b-6f11bc0188a4.jpg | | 210 | 5005703-1 | upn0379pr0004 | 0 | upn0379 | https://cdn.rebrickable.com/media/parts/photos/0/upn0379-0-7e03b117-83e7-4f17-ad7b-6f11bc0188a4.jpg | +-----+-------------------+---------------------+----------+----------------+-------------------------------------------------------------------------------------------------------------+