.bail ON .mode table --wrap 0 SELECT datetime(value, 'unixepoch') 'DB version' FROM rb_db_lov WHERE key = 'data_timestamp'; +---------------------+ | DB version | +---------------------+ | 2025-07-06 08:09:25 | +---------------------+ -- Stats difference in `colors` table (`'c.'`), `color_stats` view (`'cs.'`) and `part_color_stats` view (`'pcs.'`). SELECT id , name , c.num_parts 'c.num_parts' , cs.num_parts 'cs.num_parts' , c.num_parts - cs.num_parts 'c-cs' , c.num_sets 'c.num_sets' , cs.num_sets 'cs.num_sets' , c.num_sets - cs.num_sets 'c-cs' , sum(pcs.num_sets) , c.num_sets - sum(pcs.num_sets) 'c-pcs' , CAST(c.y1 AS TEXT) || '-' || CAST(cs.min_year AS TEXT) || '=' || CAST(c.y1-cs.min_year AS TEXT) 'minyear:c-cs' , CAST(c.y2 AS TEXT) || '-' || CAST(cs.max_year AS TEXT) || '=' || CAST(c.y2-cs.max_year AS TEXT) 'maxyear:c-cs' FROM colors c JOIN color_stats cs ON c.id = cs.color_id JOIN part_color_stats pcs ON c.id = pcs.color_id GROUP BY id; +------+------------------------------+-------------+--------------+------+------------+-------------+--------+-------------------+-------+--------------+--------------+ | id | name | c.num_parts | cs.num_parts | c-cs | c.num_sets | cs.num_sets | c-cs | sum(pcs.num_sets) | c-pcs | minyear:c-cs | maxyear:c-cs | +------+------------------------------+-------------+--------------+------+------------+-------------+--------+-------------------+-------+--------------+--------------+ | -1 | [Unknown] | 17 | 17 | 0 | 2 | 1 | 1 | 2 | 0 | 2000-2000=0 | 2000-2000=0 | | 0 | Black | 758247 | 756274 | 1973 | 210254 | 14199 | 196055 | 210004 | 250 | 1957-1957=0 | 2026-2025=1 | | 1 | Blue | 194980 | 194446 | 534 | 47095 | 9315 | 37780 | 47017 | 78 | 1949-1949=0 | 2025-2025=0 | | 2 | Green | 81937 | 81811 | 126 | 24399 | 6129 | 18270 | 24389 | 10 | 1949-1949=0 | 2025-2025=0 | | 3 | Dark Turquoise | 20473 | 20446 | 27 | 5371 | 1258 | 4113 | 5362 | 9 | 1998-1998=0 | 2025-2025=0 | | 4 | Red | 297967 | 297221 | 746 | 88771 | 11787 | 76984 | 88701 | 70 | 1949-1949=0 | 2025-2025=0 | | 5 | Dark Pink | 13239 | 13219 | 20 | 4234 | 1558 | 2676 | 4231 | 3 | 2003-2003=0 | 2025-2025=0 | | 6 | Brown | 9551 | 9453 | 98 | 3778 | 1099 | 2679 | 3776 | 2 | 1974-1974=0 | 2006-2006=0 | | 7 | Light Gray | 92781 | 92764 | 17 | 25142 | 3117 | 22025 | 25130 | 12 | 1954-1954=0 | 2006-2006=0 | | 8 | Dark Gray | 22416 | 22386 | 30 | 7778 | 1604 | 6174 | 7777 | 1 | 1978-1978=0 | 2008-2008=0 | | 9 | Light Blue | 42 | 41 | 1 | 33 | 21 | 12 | 33 | 0 | 1995-1995=0 | 2007-2007=0 | | 10 | Bright Green | 22732 | 22716 | 16 | 7040 | 2702 | 4338 | 7038 | 2 | 1949-1949=0 | 2026-2025=1 | | 11 | Light Turquoise | 136 | 136 | 0 | 74 | 38 | 36 | 74 | 0 | 1998-1998=0 | 2004-2004=0 | | 12 | Salmon | 185 | 185 | 0 | 115 | 27 | 88 | 115 | 0 | 1997-1997=0 | 2000-2000=0 | | 13 | Pink | 477 | 476 | 1 | 246 | 77 | 169 | 244 | 2 | 1994-1994=0 | 2005-2005=0 | | 14 | Yellow | 201525 | 200052 | 1473 | 67168 | 11713 | 55455 | 67092 | 76 | 1949-1949=0 | 2025-2025=0 | | 15 | White | 471356 | 470396 | 960 | 138172 | 12302 | 125870 | 137922 | 250 | 1949-1949=0 | 2025-2025=0 | | 17 | Light Green | 165 | 165 | 0 | 124 | 63 | 61 | 124 | 0 | 1992-1992=0 | 2005-2005=0 | | 18 | Light Yellow | 341 | 340 | 1 | 188 | 77 | 111 | 187 | 1 | 1993-1993=0 | 2005-2005=0 | | 19 | Tan | 169984 | 169662 | 322 | 40361 | 6096 | 34265 | 40342 | 19 | 1982-1982=0 | 2026-2025=1 | | 20 | Light Violet | 182 | 181 | 1 | 124 | 40 | 84 | 119 | 5 | 1994-1994=0 | 2002-2002=0 | | 21 | Glow In Dark Opaque | 209 | 207 | 2 | 151 | 78 | 73 | 151 | 0 | 1990-1990=0 | 2006-2006=0 | | 22 | Purple | 1005 | 1003 | 2 | 318 | 122 | 196 | 318 | 0 | 1997-1997=0 | 2005-2005=0 | | 23 | Dark Blue-Violet | 9 | 9 | 0 | 9 | 7 | 2 | 9 | 0 | 2004-2004=0 | 2006-2006=0 | | 25 | Orange | 49332 | 49197 | 135 | 16113 | 4519 | 11594 | 16088 | 25 | 1997-1997=0 | 2025-2025=0 | | 26 | Magenta | 12183 | 12132 | 51 | 4315 | 1357 | 2958 | 4308 | 7 | 2000-2000=0 | 2025-2025=0 | | 27 | Lime | 40566 | 40532 | 34 | 13349 | 3495 | 9854 | 13347 | 2 | 1997-1997=0 | 2025-2025=0 | | 28 | Dark Tan | 60400 | 60283 | 117 | 14495 | 3094 | 11401 | 14485 | 10 | 2000-2000=0 | 2025-2025=0 | | 29 | Bright Pink | 15759 | 15736 | 23 | 5005 | 1805 | 3200 | 4996 | 9 | 2003-2003=0 | 2025-2025=0 | | 30 | Medium Lavender | 8445 | 8426 | 19 | 2901 | 1002 | 1899 | 2896 | 5 | 2011-2011=0 | 2025-2025=0 | | 31 | Lavender | 7360 | 7354 | 6 | 2002 | 739 | 1263 | 2000 | 2 | 2011-2011=0 | 2025-2025=0 | | 33 | Trans-Dark Blue | 10432 | 10426 | 6 | 3213 | 1913 | 1300 | 3207 | 6 | 1965-1965=0 | 2025-2025=0 | | 34 | Trans-Green | 5155 | 5152 | 3 | 2185 | 1652 | 533 | 2183 | 2 | 1969-1969=0 | 2025-2025=0 | | 35 | Trans-Bright Green | 3239 | 3231 | 8 | 1174 | 680 | 494 | 1171 | 3 | 2010-2010=0 | 2025-2025=0 | | 36 | Trans-Red | 19580 | 19552 | 28 | 6839 | 4231 | 2608 | 6811 | 28 | 1969-1969=0 | 2025-2025=0 | | 40 | Trans-Brown | 8650 | 8612 | 38 | 3003 | 1834 | 1169 | 2988 | 15 | 1999-1999=0 | 2025-2025=0 | | 41 | Trans-Light Blue | 30206 | 30162 | 44 | 8734 | 3567 | 5167 | 8676 | 58 | 1985-1985=0 | 2025-2025=0 | | 42 | Trans-Neon Green | 6800 | 6753 | 47 | 2335 | 1162 | 1173 | 2327 | 8 | 1988-1988=0 | 2024-2024=0 | | 43 | Trans-Very Lt Blue | 232 | 232 | 0 | 76 | 32 | 44 | 76 | 0 | 2003-2003=0 | 2006-2006=0 | | 45 | Trans-Dark Pink | 5441 | 5432 | 9 | 1847 | 902 | 945 | 1842 | 5 | 1998-1998=0 | 2025-2025=0 | | 46 | Trans-Yellow | 12624 | 12617 | 7 | 4244 | 2901 | 1343 | 4236 | 8 | 1969-1969=0 | 2025-2025=0 | | 47 | Trans-Clear | 42936 | 43047 | -111 | 13903 | 5912 | 7991 | 13885 | 18 | 1954-1954=0 | 2025-2025=0 | | 52 | Trans-Purple | 2870 | 2859 | 11 | 813 | 495 | 318 | 806 | 7 | 2000-2000=0 | 2025-2025=0 | | 54 | Trans-Neon Yellow | 187 | 187 | 0 | 57 | 26 | 31 | 57 | 0 | 2001-2001=0 | 2005-2005=0 | | 57 | Trans-Neon Orange | 5601 | 5590 | 11 | 1945 | 1076 | 869 | 1940 | 5 | 1993-1993=0 | 2024-2024=0 | | 60 | Chrome Antique Brass | 33 | 33 | 0 | 16 | 16 | 0 | 16 | 0 | 2001-2001=0 | 2005-2005=0 | | 61 | Chrome Blue | 26 | 24 | 2 | 16 | 15 | 1 | 16 | 0 | 1998-1998=0 | 2006-2006=0 | | 62 | Chrome Green | 2 | 2 | 0 | 2 | 2 | 0 | 2 | 0 | 1999-1999=0 | 1999-1999=0 | | 63 | Chrome Pink | 19 | 16 | 3 | 12 | 12 | 0 | 12 | 0 | 2001-2001=0 | 2018-2018=0 | | 64 | Chrome Black | 10 | 10 | 0 | 10 | 5 | 5 | 10 | 0 | 2008-2008=0 | 2020-2020=0 | | 68 | Very Light Orange | 16 | 16 | 0 | 16 | 5 | 11 | 16 | 0 | 2000-2000=0 | 2002-2002=0 | | 69 | Light Purple | 102 | 98 | 4 | 38 | 19 | 19 | 38 | 0 | 2003-2003=0 | 2006-2006=0 | | 70 | Reddish Brown | 150169 | 149745 | 424 | 42968 | 5414 | 37554 | 42930 | 38 | 2003-2003=0 | 2026-2025=1 | | 71 | Light Bluish Gray | 463426 | 462994 | 432 | 121277 | 8492 | 112785 | 121161 | 116 | 2002-2002=0 | 2026-2025=1 | | 72 | Dark Bluish Gray | 335565 | 334994 | 571 | 93941 | 7775 | 86166 | 93777 | 164 | 1999-1999=0 | 2025-2025=0 | | 73 | Medium Blue | 13118 | 13043 | 75 | 3467 | 1344 | 2123 | 3460 | 7 | 1997-1997=0 | 2025-2025=0 | | 74 | Medium Green | 569 | 566 | 3 | 307 | 119 | 188 | 305 | 2 | 1994-1994=0 | 2005-2005=0 | | 75 | Speckle Black-Copper | 10 | 10 | 0 | 7 | 3 | 4 | 7 | 0 | 2006-2006=0 | 2006-2006=0 | | 76 | Speckle DBGray-Silver | 12 | 12 | 0 | 9 | 7 | 2 | 9 | 0 | 2006-2006=0 | 2006-2006=0 | | 77 | Light Pink | 184 | 182 | 2 | 81 | 16 | 65 | 81 | 0 | 1991-1991=0 | 1994-1994=0 | | 78 | Light Nougat | 9349 | 8804 | 545 | 5291 | 2214 | 3077 | 5291 | 0 | 2004-2004=0 | 2025-2025=0 | | 79 | Milky White | 238 | 238 | 0 | 157 | 106 | 51 | 157 | 0 | 1963-1963=0 | 2008-2008=0 | | 80 | Metallic Silver | 3828 | 3757 | 71 | 1249 | 790 | 459 | 1245 | 4 | 1998-1998=0 | 2025-2025=0 | | 81 | Metallic Green | 23 | 23 | 0 | 13 | 2 | 11 | 13 | 0 | 2001-2001=0 | 2001-2001=0 | | 82 | Metallic Gold | 2511 | 2501 | 10 | 625 | 361 | 264 | 623 | 2 | 1997-1997=0 | 2025-2025=0 | | 84 | Medium Nougat | 33445 | 33319 | 126 | 9617 | 2284 | 7333 | 9615 | 2 | 2010-2010=0 | 2025-2025=0 | | 85 | Dark Purple | 15697 | 15617 | 80 | 5501 | 1595 | 3906 | 5496 | 5 | 2000-2000=0 | 2025-2025=0 | | 86 | Light Brown | 167 | 165 | 2 | 100 | 35 | 65 | 100 | 0 | 2002-2002=0 | 2006-2006=0 | | 89 | Royal Blue | 190 | 188 | 2 | 67 | 17 | 50 | 67 | 0 | 2004-2004=0 | 2005-2005=0 | | 92 | Nougat | 2586 | 2532 | 54 | 1040 | 569 | 471 | 1038 | 2 | 1979-1979=0 | 2025-2025=0 | | 100 | Light Salmon | 180 | 180 | 0 | 111 | 22 | 89 | 111 | 0 | 1997-1997=0 | 2002-2002=0 | | 110 | Violet | 194 | 193 | 1 | 122 | 47 | 75 | 122 | 0 | 1992-1992=0 | 2008-2008=0 | | 112 | Medium Bluish Violet | 59 | 59 | 0 | 52 | 30 | 22 | 52 | 0 | 1999-1999=0 | 2005-2005=0 | | 114 | Glitter Trans-Dark Pink | 233 | 233 | 0 | 49 | 36 | 13 | 49 | 0 | 1999-1999=0 | 2024-2024=0 | | 115 | Medium Lime | 192 | 192 | 0 | 105 | 50 | 55 | 105 | 0 | 1998-1998=0 | 2005-2005=0 | | 117 | Glitter Trans-Clear | 230 | 230 | 0 | 38 | 34 | 4 | 38 | 0 | 1999-1999=0 | 2023-2023=0 | | 118 | Aqua | 324 | 323 | 1 | 132 | 59 | 73 | 132 | 0 | 1998-1998=0 | 2018-2018=0 | | 120 | Light Lime | 28 | 28 | 0 | 20 | 16 | 4 | 20 | 0 | 1998-1998=0 | 2007-2007=0 | | 125 | Light Orange | 66 | 66 | 0 | 46 | 28 | 18 | 46 | 0 | 1998-1998=0 | 2004-2004=0 | | 129 | Glitter Trans-Purple | 168 | 168 | 0 | 73 | 65 | 8 | 73 | 0 | 2000-2000=0 | 2024-2024=0 | | 132 | Speckle Black-Silver | 244 | 225 | 19 | 91 | 50 | 41 | 91 | 0 | 2005-2005=0 | 2013-2013=0 | | 133 | Speckle Black-Gold | 5 | 5 | 0 | 5 | 4 | 1 | 5 | 0 | 2010-2010=0 | 2011-2011=0 | | 134 | Copper | 191 | 161 | 30 | 44 | 25 | 19 | 44 | 0 | 2004-2004=0 | 2008-2008=0 | | 135 | Pearl Light Gray | 5487 | 5459 | 28 | 2387 | 746 | 1641 | 2383 | 4 | 2000-2000=0 | 2011-2011=0 | | 137 | Pearl Sand Blue | 171 | 171 | 0 | 77 | 23 | 54 | 77 | 0 | 2000-2000=0 | 2006-2006=0 | | 142 | Pearl Light Gold | 28 | 27 | 1 | 27 | 10 | 17 | 27 | 0 | 2000-2000=0 | 2005-2005=0 | | 143 | Trans-Medium Blue | 703 | 700 | 3 | 249 | 181 | 68 | 248 | 1 | 2001-2001=0 | 2018-2018=0 | | 148 | Pearl Dark Gray | 532 | 522 | 10 | 281 | 114 | 167 | 281 | 0 | 2001-2001=0 | 2010-2010=0 | | 150 | Pearl Very Light Gray | 40 | 40 | 0 | 29 | 10 | 19 | 29 | 0 | 2000-2000=0 | 2004-2004=0 | | 151 | Very Light Bluish Gray | 283 | 278 | 5 | 152 | 61 | 91 | 152 | 0 | 1998-1998=0 | 2013-2013=0 | | 158 | Yellowish Green | 3026 | 3025 | 1 | 930 | 492 | 438 | 929 | 1 | 2012-2012=0 | 2025-2025=0 | | 178 | Flat Dark Gold | 141 | 141 | 0 | 113 | 48 | 65 | 113 | 0 | 2002-2002=0 | 2006-2006=0 | | 179 | Flat Silver | 21317 | 21257 | 60 | 7996 | 3409 | 4587 | 7970 | 26 | 2009-2009=0 | 2025-2025=0 | | 182 | Trans-Orange | 14530 | 14505 | 25 | 4645 | 2554 | 2091 | 4626 | 19 | 2002-2002=0 | 2025-2025=0 | | 183 | Pearl White | 46 | 46 | 0 | 19 | 10 | 9 | 19 | 0 | 2003-2003=0 | 2021-2021=0 | | 191 | Bright Light Orange | 26623 | 26587 | 36 | 8942 | 2415 | 6527 | 8940 | 2 | 2003-2003=0 | 2025-2025=0 | | 212 | Bright Light Blue | 7261 | 7235 | 26 | 2199 | 914 | 1285 | 2199 | 0 | 2004-2004=0 | 2025-2025=0 | | 216 | Rust | 31 | 31 | 0 | 17 | 12 | 5 | 17 | 0 | 1989-1989=0 | 2001-2001=0 | | 226 | Bright Light Yellow | 10343 | 10276 | 67 | 3214 | 1291 | 1923 | 3213 | 1 | 2004-2004=0 | 2025-2025=0 | | 230 | Trans-Pink | 435 | 435 | 0 | 182 | 41 | 141 | 182 | 0 | 2003-2003=0 | 2025-2025=0 | | 232 | Sky Blue | 131 | 131 | 0 | 62 | 35 | 27 | 62 | 0 | 2003-2003=0 | 2007-2007=0 | | 236 | Trans-Light Purple | 71 | 71 | 0 | 37 | 14 | 23 | 37 | 0 | 2000-2000=0 | 2006-2006=0 | | 272 | Dark Blue | 46614 | 46335 | 279 | 13288 | 2827 | 10461 | 13276 | 12 | 1999-1999=0 | 2026-2025=1 | | 288 | Dark Green | 21534 | 21459 | 75 | 5245 | 1480 | 3765 | 5245 | 0 | 1999-1999=0 | 2025-2025=0 | | 294 | Glow In Dark Trans | 131 | 130 | 1 | 43 | 34 | 9 | 43 | 0 | 2005-2005=0 | 2011-2011=0 | | 297 | Pearl Gold | 45402 | 45265 | 137 | 13555 | 3024 | 10531 | 13503 | 52 | 2004-2004=0 | 2025-2025=0 | | 308 | Dark Brown | 21490 | 21259 | 231 | 6044 | 2214 | 3830 | 6040 | 4 | 2008-2008=0 | 2025-2025=0 | | 313 | Maersk Blue | 469 | 469 | 0 | 101 | 11 | 90 | 101 | 0 | 1974-1974=0 | 2006-2006=0 | | 320 | Dark Red | 44961 | 44817 | 144 | 11342 | 2359 | 8983 | 11336 | 6 | 2001-2001=0 | 2025-2025=0 | | 321 | Dark Azure | 14098 | 14056 | 42 | 4923 | 1483 | 3440 | 4916 | 7 | 2011-2011=0 | 2025-2025=0 | | 322 | Medium Azure | 24361 | 24340 | 21 | 8693 | 2132 | 6561 | 8681 | 12 | 2012-2012=0 | 2025-2025=0 | | 323 | Light Aqua | 9687 | 9622 | 65 | 2794 | 881 | 1913 | 2793 | 1 | 2011-2011=0 | 2025-2025=0 | | 326 | Olive Green | 10043 | 10004 | 39 | 2219 | 704 | 1515 | 2219 | 0 | 2010-2010=0 | 2025-2025=0 | | 334 | Chrome Gold | 2171 | 2160 | 11 | 838 | 308 | 530 | 837 | 1 | 1989-1989=0 | 2025-2025=0 | | 335 | Sand Red | 591 | 579 | 12 | 51 | 19 | 32 | 51 | 0 | 2001-2001=0 | 2004-2004=0 | | 351 | Medium Dark Pink | 1092 | 1088 | 4 | 574 | 131 | 443 | 566 | 8 | 1994-1994=0 | 2005-2005=0 | | 366 | Earth Orange | 170 | 167 | 3 | 132 | 89 | 43 | 131 | 1 | 1982-1982=0 | 2005-2005=0 | | 373 | Sand Purple | 73 | 71 | 2 | 21 | 8 | 13 | 21 | 0 | 2001-2001=0 | 2003-2003=0 | | 378 | Sand Green | 21924 | 21801 | 123 | 4438 | 1107 | 3331 | 4437 | 1 | 2000-2000=0 | 2025-2025=0 | | 379 | Sand Blue | 9207 | 9158 | 49 | 2540 | 940 | 1600 | 2539 | 1 | 2001-2001=0 | 2025-2025=0 | | 383 | Chrome Silver | 1325 | 1326 | -1 | 625 | 422 | 203 | 623 | 2 | 1977-1977=0 | 2025-2025=0 | | 450 | Fabuland Brown | 55 | 55 | 0 | 43 | 25 | 18 | 43 | 0 | 1979-1979=0 | 1991-1991=0 | | 462 | Medium Orange | 494 | 494 | 0 | 284 | 122 | 162 | 281 | 3 | 1996-1996=0 | 2008-2008=0 | | 484 | Dark Orange | 22948 | 22866 | 82 | 6952 | 2340 | 4612 | 6951 | 1 | 1994-1994=0 | 2025-2025=0 | | 503 | Very Light Gray | 59 | 59 | 0 | 48 | 22 | 26 | 48 | 0 | 1997-1997=0 | 2004-2004=0 | | 1000 | Glow in Dark White | 637 | 636 | 1 | 174 | 109 | 65 | 174 | 0 | 2011-2011=0 | 2025-2025=0 | | 1001 | Medium Violet | 11 | 11 | 0 | 11 | 9 | 2 | 11 | 0 | 2000-2000=0 | 2005-2005=0 | | 1002 | Glitter Trans-Neon Green | 9 | 9 | 0 | 8 | 8 | 0 | 8 | 0 | 2015-2015=0 | 2018-2018=0 | | 1003 | Glitter Trans-Light Blue | 91 | 91 | 0 | 43 | 32 | 11 | 43 | 0 | 2015-2015=0 | 2024-2024=0 | | 1004 | Trans-Flame Yellowish Orange | 214 | 214 | 0 | 82 | 22 | 60 | 82 | 0 | 2003-2003=0 | 2006-2006=0 | | 1005 | Trans-Fire Yellow | 41 | 41 | 0 | 16 | 8 | 8 | 16 | 0 | 2003-2003=0 | 2006-2006=0 | | 1006 | Trans-Light Royal Blue | 90 | 90 | 0 | 48 | 11 | 37 | 48 | 0 | 2005-2005=0 | 2005-2005=0 | | 1007 | Reddish Lilac | 49 | 49 | 0 | 22 | 11 | 11 | 22 | 0 | 2004-2004=0 | 2005-2005=0 | | 1008 | Vintage Blue | 24 | 24 | 0 | 4 | 1 | 3 | 4 | 0 | 1949-1949=0 | 1949-1949=0 | | 1009 | Vintage Green | 32 | 32 | 0 | 8 | 1 | 7 | 8 | 0 | 1949-1949=0 | 1949-1949=0 | | 1010 | Vintage Red | 31 | 31 | 0 | 8 | 1 | 7 | 8 | 0 | 1949-1949=0 | 1949-1949=0 | | 1011 | Vintage Yellow | 24 | 24 | 0 | 4 | 1 | 3 | 4 | 0 | 1949-1949=0 | 1949-1949=0 | | 1012 | Fabuland Orange | 5 | 5 | 0 | 3 | 3 | 0 | 3 | 0 | 1983-1983=0 | 1987-1987=0 | | 1013 | Modulex White | 2996 | 2996 | 0 | 756 | 23 | 733 | 756 | 0 | 1963-1963=0 | 1963-1963=0 | | 1014 | Modulex Light Bluish Gray | 10 | 10 | 0 | 10 | 1 | 9 | 10 | 0 | 1963-1963=0 | 1963-1963=0 | | 1015 | Modulex Light Gray | 2249 | 2249 | 0 | 62 | 23 | 39 | 62 | 0 | 1963-1963=0 | 1963-1963=0 | | 1016 | Modulex Charcoal Gray | 2 | 2 | 0 | 2 | 1 | 1 | 2 | 0 | 1963-1963=0 | 1963-1963=0 | | 1017 | Modulex Tile Gray | 219 | 219 | 0 | 218 | 1 | 217 | 218 | 0 | 1963-1963=0 | 1963-1963=0 | | 1018 | Modulex Black | 2499 | 2499 | 0 | 310 | 23 | 287 | 310 | 0 | 1963-1963=0 | 1963-1963=0 | | 1019 | Modulex Tile Brown | 158 | 158 | 0 | 157 | 1 | 156 | 157 | 0 | 1963-1963=0 | 1963-1963=0 | | 1020 | Modulex Terracotta | 1622 | 1622 | 0 | 38 | 16 | 22 | 38 | 0 | 1963-1963=0 | 1963-1963=0 | | 1021 | Modulex Brown | 2223 | 2223 | 0 | 36 | 23 | 13 | 36 | 0 | 1963-1963=0 | 1963-1963=0 | | 1022 | Modulex Buff | 1626 | 1626 | 0 | 42 | 16 | 26 | 42 | 0 | 1963-1963=0 | 1963-1963=0 | | 1023 | Modulex Red | 26 | 26 | 0 | 26 | 1 | 25 | 26 | 0 | 1963-1963=0 | 1963-1963=0 | | 1024 | Modulex Pink Red | 7 | 7 | 0 | 7 | 1 | 6 | 7 | 0 | 1963-1963=0 | 1963-1963=0 | | 1025 | Modulex Orange | 26 | 26 | 0 | 25 | 1 | 24 | 25 | 0 | 1963-1963=0 | 1963-1963=0 | | 1026 | Modulex Light Orange | 7 | 7 | 0 | 7 | 1 | 6 | 7 | 0 | 1963-1963=0 | 1963-1963=0 | | 1027 | Modulex Light Yellow | 8 | 8 | 0 | 8 | 1 | 7 | 8 | 0 | 1963-1963=0 | 1963-1963=0 | | 1028 | Modulex Ochre Yellow | 1107 | 1107 | 0 | 18 | 12 | 6 | 18 | 0 | 1963-1963=0 | 1963-1963=0 | | 1029 | Modulex Lemon | 23 | 23 | 0 | 23 | 1 | 22 | 23 | 0 | 1963-1963=0 | 1963-1963=0 | | 1030 | Modulex Pastel Green | 35 | 35 | 0 | 34 | 1 | 33 | 34 | 0 | 1963-1963=0 | 1963-1963=0 | | 1031 | Modulex Olive Green | 1111 | 1111 | 0 | 21 | 12 | 9 | 21 | 0 | 1963-1963=0 | 1963-1963=0 | | 1032 | Modulex Aqua Green | 16 | 16 | 0 | 16 | 1 | 15 | 16 | 0 | 1963-1963=0 | 1963-1963=0 | | 1033 | Modulex Teal Blue | 1104 | 1104 | 0 | 15 | 12 | 3 | 15 | 0 | 1963-1963=0 | 1963-1963=0 | | 1034 | Modulex Tile Blue | 80 | 80 | 0 | 79 | 1 | 78 | 79 | 0 | 1963-1963=0 | 1963-1963=0 | | 1035 | Modulex Medium Blue | 7 | 7 | 0 | 7 | 1 | 6 | 7 | 0 | 1963-1963=0 | 1963-1963=0 | | 1036 | Modulex Pastel Blue | 19 | 19 | 0 | 19 | 1 | 18 | 19 | 0 | 1963-1963=0 | 1963-1963=0 | | 1037 | Modulex Violet | 7 | 7 | 0 | 7 | 1 | 6 | 7 | 0 | 1963-1963=0 | 1963-1963=0 | | 1038 | Modulex Pink | 18 | 18 | 0 | 18 | 1 | 17 | 18 | 0 | 1963-1963=0 | 1963-1963=0 | | 1039 | Modulex Clear | 1394 | 1394 | 0 | 71 | 25 | 46 | 71 | 0 | 1963-1963=0 | 1963-1963=0 | | 1050 | Coral | 6687 | 6687 | 0 | 1543 | 555 | 988 | 1537 | 6 | 2019-2019=0 | 2025-2025=0 | | 1051 | Pastel Blue | 734 | 734 | 0 | 101 | 5 | 96 | 101 | 0 | 2000-2000=0 | 2011-2011=0 | | 1052 | Glitter Trans-Orange | 1 | 1 | 0 | 1 | 1 | 0 | 1 | 0 | 2020-2020=0 | 2020-2020=0 | | 1053 | Opal Trans-Light Blue | 816 | 813 | 3 | 218 | 145 | 73 | 218 | 0 | 2020-2020=0 | 2025-2025=0 | | 1054 | Opal Trans-Dark Pink | 125 | 125 | 0 | 60 | 49 | 11 | 60 | 0 | 2020-2020=0 | 2025-2025=0 | | 1055 | Opal Trans-Clear | 691 | 691 | 0 | 128 | 110 | 18 | 127 | 1 | 2020-2020=0 | 2025-2025=0 | | 1056 | Opal Trans-Brown | 140 | 140 | 0 | 16 | 12 | 4 | 16 | 0 | 2020-2020=0 | 2023-2023=0 | | 1057 | Trans-Light Bright Green | 119 | 119 | 0 | 48 | 20 | 28 | 48 | 0 | 2003-2003=0 | 2006-2006=0 | | 1058 | Trans-Light Green | 42 | 42 | 0 | 16 | 6 | 10 | 16 | 0 | 2005-2005=0 | 2006-2006=0 | | 1059 | Opal Trans-Purple | 249 | 249 | 0 | 83 | 58 | 25 | 79 | 4 | 2020-2020=0 | 2025-2025=0 | | 1060 | Opal Trans-Bright Green | 125 | 125 | 0 | 20 | 17 | 3 | 20 | 0 | 2021-2021=0 | 2025-2025=0 | | 1061 | Opal Trans-Dark Blue | 207 | 207 | 0 | 51 | 41 | 10 | 51 | 0 | 2021-2021=0 | 2025-2025=0 | | 1062 | Vibrant Yellow | 1862 | 1860 | 2 | 570 | 159 | 411 | 570 | 0 | 2022-2022=0 | 2025-2025=0 | | 1063 | Pearl Copper | 72 | 72 | 0 | 45 | 20 | 25 | 45 | 0 | 2017-2017=0 | 2020-2020=0 | | 1064 | Fabuland Red | 23 | 23 | 0 | 16 | 15 | 1 | 16 | 0 | 1979-1979=0 | 1994-1994=0 | | 1065 | Reddish Gold | 79 | 79 | 0 | 68 | 27 | 41 | 68 | 0 | 2002-2002=0 | 2006-2006=0 | | 1066 | Curry | 10 | 10 | 0 | 6 | 5 | 1 | 6 | 0 | 2004-2004=0 | 2005-2005=0 | | 1067 | Dark Nougat | 10 | 10 | 0 | 10 | 10 | 0 | 10 | 0 | 2001-2001=0 | 2004-2004=0 | | 1068 | Bright Reddish Orange | 16 | 16 | 0 | 13 | 5 | 8 | 13 | 0 | 2003-2003=0 | 2004-2004=0 | | 1069 | Pearl Red | 24 | 24 | 0 | 14 | 7 | 7 | 14 | 0 | 2003-2003=0 | 2006-2006=0 | | 1070 | Pearl Blue | 21 | 21 | 0 | 16 | 8 | 8 | 16 | 0 | 2003-2003=0 | 2009-2009=0 | | 1071 | Pearl Green | 21 | 21 | 0 | 15 | 7 | 8 | 15 | 0 | 2003-2003=0 | 2006-2006=0 | | 1072 | Pearl Brown | 35 | 35 | 0 | 17 | 7 | 10 | 17 | 0 | 2003-2003=0 | 2006-2006=0 | | 1073 | Pearl Black | 35 | 35 | 0 | 19 | 10 | 9 | 19 | 0 | 2000-2000=0 | 2006-2006=0 | | 1074 | Duplo Blue | 6 | 6 | 0 | 6 | 5 | 1 | 6 | 0 | 2003-2003=0 | 2004-2004=0 | | 1075 | Duplo Medium Blue | 1 | 1 | 0 | 1 | 1 | 0 | 1 | 0 | 2004-2004=0 | 2004-2004=0 | | 1076 | Duplo Lime | 5 | 5 | 0 | 3 | 1 | 2 | 3 | 0 | 1992-1992=0 | 1992-1992=0 | | 1077 | Fabuland Lime | 16 | 16 | 0 | 15 | 5 | 10 | 15 | 0 | 1982-1982=0 | 1986-1986=0 | | 1078 | Duplo Medium Green | 1 | 1 | 0 | 1 | 1 | 0 | 1 | 0 | 2003-2003=0 | 2003-2003=0 | | 1079 | Duplo Light Green | 1 | 1 | 0 | 1 | 1 | 0 | 1 | 0 | 2004-2004=0 | 2004-2004=0 | | 1080 | Light Tan | 1 | 1 | 0 | 1 | 1 | 0 | 1 | 0 | 2006-2006=0 | 2006-2006=0 | | 1081 | Rust Orange | 3 | 3 | 0 | 3 | 2 | 1 | 3 | 0 | 2004-2004=0 | 2005-2005=0 | | 1082 | Clikits Pink | 32 | 32 | 0 | 10 | 3 | 7 | 10 | 0 | 2006-2006=0 | 2006-2006=0 | | 1083 | Two-tone Copper | 2 | 2 | 0 | 2 | 1 | 1 | 2 | 0 | 2001-2001=0 | 2001-2001=0 | | 1084 | Two-tone Gold | 6 | 6 | 0 | 6 | 1 | 5 | 6 | 0 | 2002-2002=0 | 2002-2002=0 | | 1085 | Two-tone Silver | 6 | 6 | 0 | 6 | 1 | 5 | 6 | 0 | 2002-2002=0 | 2002-2002=0 | | 1086 | Pearl Lime | 41 | 41 | 0 | 39 | 3 | 36 | 39 | 0 | 2002-2002=0 | 2004-2004=0 | | 1087 | Duplo Pink | 47 | 47 | 0 | 21 | 6 | 15 | 21 | 0 | 1992-1992=0 | 1993-1993=0 | | 1088 | Medium Brown | 172 | 171 | 1 | 171 | 95 | 76 | 171 | 0 | 2022-2022=0 | 2025-2025=0 | | 1089 | Warm Tan | 362 | 362 | 0 | 311 | 131 | 180 | 311 | 0 | 2022-2022=0 | 2025-2025=0 | | 1090 | Duplo Turquoise | 2 | 2 | 0 | 2 | 1 | 1 | 2 | 0 | 2003-2003=0 | 2003-2003=0 | | 1091 | Warm Yellowish Orange | 19 | 19 | 0 | 19 | 2 | 17 | 19 | 0 | 2004-2004=0 | 2004-2004=0 | | 1092 | Metallic Copper | 52 | 51 | 1 | 18 | 14 | 4 | 18 | 0 | 2008-2008=0 | 2012-2012=0 | | 1093 | Light Lilac | 51 | 51 | 0 | 19 | 16 | 3 | 19 | 0 | 2003-2003=0 | 2011-2011=0 | | 1094 | Trans-Medium Purple | 258 | 258 | 0 | 92 | 27 | 65 | 92 | 0 | 2003-2003=0 | 2006-2006=0 | | 1095 | Trans-Black | 759 | 759 | 0 | 137 | 80 | 57 | 137 | 0 | 2023-2023=0 | 2025-2025=0 | | 1097 | Glitter Trans-Medium Purple | 6 | 6 | 0 | 3 | 2 | 1 | 3 | 0 | 2005-2005=0 | 2005-2005=0 | | 1098 | Glitter Trans-Green | 1 | 1 | 0 | 1 | 1 | 0 | 1 | 0 | 2000-2000=0 | 2000-2000=0 | | 1099 | Glitter Trans-Pink | 2 | 2 | 0 | 1 | 1 | 0 | 1 | 0 | 2005-2005=0 | 2005-2005=0 | | 1100 | Clikits Yellow | 22 | 22 | 0 | 6 | 5 | 1 | 6 | 0 | 2003-2003=0 | 2004-2004=0 | | 1101 | Duplo Dark Purple | 1 | 1 | 0 | 1 | 1 | 0 | 1 | 0 | 2003-2003=0 | 2003-2003=0 | | 1102 | Trans-Neon Red | 22 | 22 | 0 | 9 | 9 | 0 | 9 | 0 | 2001-2001=0 | 2004-2004=0 | | 1103 | Pearl Titanium | 7053 | 6962 | 91 | 3072 | 1374 | 1698 | 3066 | 6 | 2010-2010=0 | 2026-2025=1 | | 1104 | HO Aqua | 1 | 1 | 0 | 1 | 1 | 0 | 1 | 0 | 1958-1958=0 | 1958-1958=0 | | 1105 | HO Azure | 1 | 1 | 0 | 1 | 1 | 0 | 1 | 0 | 1963-1963=0 | 1963-1963=0 | | 1106 | HO Blue-gray | 3 | 3 | 0 | 3 | 3 | 0 | 3 | 0 | 1958-1958=0 | 1970-1970=0 | | 1107 | HO Cyan | 1 | 1 | 0 | 1 | 1 | 0 | 1 | 0 | 1958-1958=0 | 1958-1958=0 | | 1108 | HO Dark Aqua | 1 | 1 | 0 | 1 | 1 | 0 | 1 | 0 | 1958-1958=0 | 1958-1958=0 | | 1109 | HO Dark Blue | 9 | 9 | 0 | 9 | 9 | 0 | 9 | 0 | 1958-1958=0 | 1965-1965=0 | | 1110 | HO Dark Gray | 11 | 11 | 0 | 11 | 10 | 1 | 11 | 0 | 1961-1961=0 | 1964-1964=0 | | 1111 | HO Dark Green | 4 | 4 | 0 | 4 | 4 | 0 | 4 | 0 | 1958-1958=0 | 1964-1964=0 | | 1112 | HO Dark Lime | 1 | 1 | 0 | 1 | 1 | 0 | 1 | 0 | 1958-1958=0 | 1958-1958=0 | | 1113 | HO Dark Red | 9 | 10 | -1 | 9 | 10 | -1 | 10 | -1 | 1958-1958=0 | 1964-1964=0 | | 1114 | HO Dark Sand Green | 1 | 1 | 0 | 1 | 1 | 0 | 1 | 0 | 1958-1958=0 | 1958-1958=0 | | 1115 | HO Dark Turquoise | 1 | 1 | 0 | 1 | 1 | 0 | 1 | 0 | 1965-1965=0 | 1965-1965=0 | | 1116 | HO Earth Orange | 2 | 2 | 0 | 2 | 2 | 0 | 2 | 0 | 1957-1957=0 | 1958-1958=0 | | 1117 | HO Gold | 1 | 1 | 0 | 1 | 1 | 0 | 1 | 0 | 1958-1958=0 | 1958-1958=0 | | 1118 | HO Light Aqua | 1 | 1 | 0 | 1 | 1 | 0 | 1 | 0 | 1958-1958=0 | 1958-1958=0 | | 1119 | HO Light Brown | 1 | 1 | 0 | 1 | 1 | 0 | 1 | 0 | 1957-1957=0 | 1957-1957=0 | | 1120 | HO Light Gold | 2 | 2 | 0 | 2 | 2 | 0 | 2 | 0 | 1957-1957=0 | 1958-1958=0 | | 1121 | HO Light Tan | 4 | 4 | 0 | 4 | 4 | 0 | 4 | 0 | 1958-1958=0 | 1964-1964=0 | | 1122 | HO Light Yellow | 1 | 1 | 0 | 1 | 1 | 0 | 1 | 0 | 1958-1958=0 | 1958-1958=0 | | 1123 | HO Medium Blue | 2 | 2 | 0 | 2 | 2 | 0 | 2 | 0 | 1958-1958=0 | 1958-1958=0 | | 1124 | HO Medium Red | 4 | 4 | 0 | 4 | 3 | 1 | 4 | 0 | 1957-1957=0 | 1958-1958=0 | | 1125 | HO Metallic Blue | 3 | 3 | 0 | 3 | 3 | 0 | 3 | 0 | 1958-1958=0 | 1961-1961=0 | | 1126 | HO Metallic Dark Gray | 2 | 2 | 0 | 2 | 2 | 0 | 2 | 0 | 1958-1958=0 | 1959-1959=0 | | 1127 | HO Metallic Green | 1 | 1 | 0 | 1 | 1 | 0 | 1 | 0 | 1958-1958=0 | 1958-1958=0 | | 1128 | HO Metallic Sand Blue | 1 | 1 | 0 | 1 | 1 | 0 | 1 | 0 | 1958-1958=0 | 1958-1958=0 | | 1129 | HO Olive Green | 12 | 12 | 0 | 12 | 7 | 5 | 12 | 0 | 1957-1957=0 | 1965-1965=0 | | 1130 | HO Rose | 1 | 1 | 0 | 1 | 1 | 0 | 1 | 0 | 1958-1958=0 | 1958-1958=0 | | 1131 | HO Sand Blue | 3 | 3 | 0 | 3 | 3 | 0 | 3 | 0 | 1957-1957=0 | 1965-1965=0 | | 1132 | HO Sand Green | 3 | 3 | 0 | 3 | 3 | 0 | 3 | 0 | 1958-1958=0 | 1964-1964=0 | | 1133 | HO Tan | 3 | 3 | 0 | 3 | 3 | 0 | 3 | 0 | 1957-1957=0 | 1964-1964=0 | | 1134 | HO Titanium | 1 | 1 | 0 | 1 | 1 | 0 | 1 | 0 | 1958-1958=0 | 1958-1958=0 | | 1135 | Metal | 48 | 49 | -1 | 23 | 24 | -1 | 24 | -1 | 1957-1957=0 | 2006-2006=0 | | 1136 | Reddish Orange | 2093 | 2093 | 0 | 471 | 176 | 295 | 470 | 1 | 2024-2024=0 | 2025-2025=0 | | 1137 | Sienna Brown | 43 | 43 | 0 | 43 | 19 | 24 | 43 | 0 | 2024-2024=0 | 2025-2025=0 | | 1138 | Umber Brown | 9 | 9 | 0 | 9 | 7 | 2 | 9 | 0 | 2024-2024=0 | 2025-2025=0 | | 1139 | Opal Trans-Yellow | 9 | 9 | 0 | 7 | 6 | 1 | 7 | 0 | 2024-2024=0 | 2025-2025=0 | | 1140 | Neon Orange | 8 | 8 | 0 | 3 | 3 | 0 | 3 | 0 | 1999-1999=0 | 1999-1999=0 | | 1141 | Neon Green | 13 | 13 | 0 | 7 | 3 | 4 | 7 | 0 | 1999-1999=0 | 1999-1999=0 | | 1142 | Dark Olive Green | 11 | 11 | 0 | 2 | 2 | 0 | 2 | 0 | 2000-2000=0 | 2001-2001=0 | | 1143 | Glitter Milky White | 4 | 4 | 0 | 4 | 3 | 1 | 4 | 0 | 1999-1999=0 | 2005-2005=0 | | 1144 | Chrome Red | 4 | 4 | 0 | 4 | 2 | 2 | 4 | 0 | 2003-2003=0 | 2009-2009=0 | | 9999 | [No Color/Any Color] | 9577 | 9559 | 18 | 9351 | 4955 | 4396 | 9351 | 0 | 1955-1955=0 | 2025-2025=0 | +------+------------------------------+-------------+--------------+------+------------+-------------+--------+-------------------+-------+--------------+--------------+