.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 | +---------------------+ -- Themes along with all their ancestors composed in a chain. CREATE TEMPORARY VIEW theme_chains AS WITH RECURSIVE rec(id, last_parent_id, ids_chain, names_chain, chain_size) AS (SELECT id, parent_id, id, name, 1 FROM themes WHERE parent_id IS NULL UNION SELECT t.id , rec.id , rec.ids_chain || ',' || t.id , rec.names_chain || ' → ' || t.name , rec.chain_size + 1 FROM rec JOIN themes t ON t.parent_id = rec.id ) SELECT id, ids_chain, names_chain, chain_size FROM rec ORDER BY names_chain COLLATE NOCASE; SELECT * FROM theme_chains; +-----+-------------+----------------------------------------------------------------------+------------+ | id | ids_chain | names_chain | chain_size | +-----+-------------+----------------------------------------------------------------------+------------+ | 279 | 279 | 4 Juniors | 1 | | 280 | 279,280 | 4 Juniors → Jack Stone | 2 | | 287 | 279,287 | 4 Juniors → Spider-Man | 2 | | 296 | 296 | Adventurers | 1 | | 297 | 296,297 | Adventurers → Desert | 2 | | 298 | 296,298 | Adventurers → Dino Island | 2 | | 299 | 296,299 | Adventurers → Jungle | 2 | | 300 | 296,300 | Adventurers → Orient Expedition | 2 | | 302 | 302 | Agents | 1 | | 303 | 302,303 | Agents → Ultra Agents | 2 | | 304 | 304 | Alpha Team | 1 | | 306 | 304,306 | Alpha Team → Mission Deep Freeze | 2 | | 305 | 304,305 | Alpha Team → Mission Deep Sea | 2 | | 606 | 606 | Angry Birds | 1 | | 752 | 752 | Animal Crossing | 1 | | 307 | 307 | Aquazone | 1 | | 308 | 307,308 | Aquazone → Aquanauts | 2 | | 309 | 307,309 | Aquazone → Aquaraiders I | 2 | | 310 | 307,310 | Aquazone → Aquaraiders II | 2 | | 311 | 307,311 | Aquazone → Aquasharks | 2 | | 312 | 307,312 | Aquazone → Hydronauts | 2 | | 313 | 307,313 | Aquazone → Stingrays | 2 | | 252 | 252 | Architecture | 1 | | 253 | 252,253 | Architecture → Skylines | 2 | | 315 | 315 | Atlantis | 1 | | 724 | 724 | Avatar | 1 | | 317 | 317 | Avatar: The Last Airbender | 1 | | 318 | 318 | Belville | 1 | | 270 | 270 | Ben 10 | 1 | | 324 | 324 | Bionicle | 1 | | 341 | 324,341 | Bionicle → Playsets | 2 | | 360 | 324,360 | Bionicle → Protectors | 2 | | 363 | 363 | Boat | 1 | | 497 | 497 | Books | 1 | | 760 | 497,760 | Books → Activity Books | 2 | | 761 | 497,761 | Books → Activity Books with LEGO Parts | 2 | | 757 | 497,757 | Books → Ideas Books | 2 | | 758 | 497,758 | Books → Non-fiction Books | 2 | | 759 | 497,759 | Books → Story Books | 2 | | 498 | 497,498 | Books → Technic | 2 | | 694 | 694 | Brick Sketches | 1 | | 610 | 610 | Brickheadz | 1 | | 719 | 719 | BrickLink Designer Program | 1 | | 364 | 364 | Building Set with People | 1 | | 254 | 254 | Bulk Bricks | 1 | | 269 | 269 | Cars | 1 | | 186 | 186 | Castle | 1 | | 187 | 186,187 | Castle → Black Falcons | 2 | | 188 | 186,188 | Castle → Black Knights | 2 | | 189 | 186,189 | Castle → Classic Castle | 2 | | 191 | 186,191 | Castle → Dark Forest | 2 | | 190 | 186,190 | Castle → Dragon Knights | 2 | | 193 | 186,193 | Castle → Fantasy Era | 2 | | 194 | 186,194 | Castle → Forestmen | 2 | | 195 | 186,195 | Castle → Fright Knights | 2 | | 196 | 186,196 | Castle → Kingdoms | 2 | | 197 | 186,197 | Castle → Knights Kingdom I | 2 | | 198 | 186,198 | Castle → Knights Kingdom II | 2 | | 199 | 186,199 | Castle → Lion Knights | 2 | | 201 | 186,201 | Castle → Royal Knights | 2 | | 203 | 186,203 | Castle → Wolfpack | 2 | | 686 | 686 | Chinese Traditional Festivals | 1 | | 52 | 52 | City | 1 | | 53 | 52,53 | City → Airport | 2 | | 65 | 52,65 | City → Arctic | 2 | | 54 | 52,54 | City → Cargo | 2 | | 55 | 52,55 | City → Coast Guard | 2 | | 56 | 52,56 | City → Construction | 2 | | 57 | 52,57 | City → Farm | 2 | | 58 | 52,58 | City → Fire | 2 | | 59 | 52,59 | City → Harbor | 2 | | 60 | 52,60 | City → Hospital | 2 | | 614 | 52,614 | City → Jungle | 2 | | 679 | 52,679 | City → Mars Exploration | 2 | | 64 | 52,64 | City → Off-Road | 2 | | 61 | 52,61 | City → Police | 2 | | 744 | 52,744 | City → Stuntz | 2 | | 63 | 52,63 | City → Traffic | 2 | | 66 | 52,66 | City → Trains | 2 | | 621 | 621 | Classic | 1 | | 500 | 500 | Clikits | 1 | | 535 | 535 | Collectible Minifigures | 1 | | 684 | 535,684 | Collectible Minifigures → DC Super Heroes | 2 | | 557 | 535,557 | Collectible Minifigures → DFB Minifigures | 2 | | 745 | 535,745 | Collectible Minifigures → Disney 100 | 2 | | 555 | 535,555 | Collectible Minifigures → Disney Series 1 | 2 | | 677 | 535,677 | Collectible Minifigures → Disney Series 2 | 2 | | 767 | 535,767 | Collectible Minifigures → Dungeons & Dragons | 2 | | 656 | 535,656 | Collectible Minifigures → Harry Potter and Fantastic Beasts Series 1 | 2 | | 691 | 535,691 | Collectible Minifigures → Harry Potter and Fantastic Beasts Series 2 | 2 | | 714 | 535,714 | Collectible Minifigures → Looney Tunes | 2 | | 715 | 535,715 | Collectible Minifigures → Marvel Series 1 | 2 | | 750 | 535,750 | Collectible Minifigures → Marvel Series 2 | 2 | | 536 | 535,536 | Collectible Minifigures → Series 1 Minifigures | 2 | | 545 | 535,545 | Collectible Minifigures → Series 10 Minifigures | 2 | | 547 | 535,547 | Collectible Minifigures → Series 11 Minifigures | 2 | | 548 | 535,548 | Collectible Minifigures → Series 12 Minifigures | 2 | | 551 | 535,551 | Collectible Minifigures → Series 13 Minifigures | 2 | | 552 | 535,552 | Collectible Minifigures → Series 14 Minifigures | 2 | | 554 | 535,554 | Collectible Minifigures → Series 15 Minifigures | 2 | | 556 | 535,556 | Collectible Minifigures → Series 16 Minifigures | 2 | | 611 | 535,611 | Collectible Minifigures → Series 17 Minifigures | 2 | | 622 | 535,622 | Collectible Minifigures → Series 18 Minifigures | 2 | | 681 | 535,681 | Collectible Minifigures → Series 19 Minifigures | 2 | | 537 | 535,537 | Collectible Minifigures → Series 2 Minifigures | 2 | | 692 | 535,692 | Collectible Minifigures → Series 20 Minifigures | 2 | | 712 | 535,712 | Collectible Minifigures → Series 21 Minifigures | 2 | | 718 | 535,718 | Collectible Minifigures → Series 22 Minifigures | 2 | | 725 | 535,725 | Collectible Minifigures → Series 23 Minifigures | 2 | | 743 | 535,743 | Collectible Minifigures → Series 24 Minifigures | 2 | | 753 | 535,753 | Collectible Minifigures → Series 25 Minifigures | 2 | | 762 | 535,762 | Collectible Minifigures → Series 26 Minifigures | 2 | | 538 | 535,538 | Collectible Minifigures → Series 3 Minifigures | 2 | | 539 | 535,539 | Collectible Minifigures → Series 4 Minifigures | 2 | | 540 | 535,540 | Collectible Minifigures → Series 5 Minifigures | 2 | | 541 | 535,541 | Collectible Minifigures → Series 6 Minifigures | 2 | | 542 | 535,542 | Collectible Minifigures → Series 7 Minifigures | 2 | | 543 | 535,543 | Collectible Minifigures → Series 8 Minifigures | 2 | | 544 | 535,544 | Collectible Minifigures → Series 9 Minifigures | 2 | | 546 | 535,546 | Collectible Minifigures → Team GB | 2 | | 609 | 535,609 | Collectible Minifigures → The LEGO Batman Movie Series 1 | 2 | | 711 | 535,711 | Collectible Minifigures → The LEGO Batman Movie Series 2 | 2 | | 549 | 535,549 | Collectible Minifigures → The LEGO Movie | 2 | | 675 | 535,675 | Collectible Minifigures → The LEGO Movie II | 2 | | 618 | 535,618 | Collectible Minifigures → The LEGO Ninjago Movie | 2 | | 720 | 535,720 | Collectible Minifigures → The Muppets | 2 | | 550 | 535,550 | Collectible Minifigures → The Simpsons Series 1 | 2 | | 553 | 535,553 | Collectible Minifigures → The Simpsons Series 2 | 2 | | 22 | 22 | Creator | 1 | | 672 | 22,672 | Creator → Creator 3-in-1 | 2 | | 673 | 22,673 | Creator → Creator Expert | 2 | | 204 | 22,204 | Creator → Designer Sets | 2 | | 674 | 22,674 | Creator → Early Creator | 2 | | 406 | 22,406 | Creator → Inventor | 2 | | 478 | 22,478 | Creator → X-Pod | 2 | | 617 | 617 | DC Super Hero Girls | 1 | | 763 | 763 | Despicable Me 4 | 1 | | 604 | 604 | Dimensions | 1 | | 481 | 481 | Dino | 1 | | 385 | 385 | Dino Attack / Dino 2010 | 1 | | 386 | 386 | Dinosaurs | 1 | | 387 | 387 | Discovery | 1 | | 608 | 608 | Disney | 1 | | 579 | 608,579 | Disney → Disney Princess | 2 | | 687 | 608,687 | Disney → Frozen | 2 | | 388 | 608,388 | Disney → Mickey Mouse | 2 | | 263 | 608,263 | Disney → Pirates of the Caribbean | 2 | | 271 | 608,271 | Disney → Prince of Persia | 2 | | 688 | 688 | DOTS | 1 | | 749 | 749 | Dreamzzz | 1 | | 504 | 504 | Duplo | 1 | | 657 | 504,657 | Duplo → Action Wheelers | 2 | | 505 | 504,505 | Duplo → Basic Set | 2 | | 626 | 504,626 | Duplo → Bob the Builder | 2 | | 647 | 504,647 | Duplo → Castle | 2 | | 653 | 504,653 | Duplo → DC Comics | 2 | | 658 | 504,658 | Duplo → Dino | 2 | | 754 | 504,754 | Duplo → Disney | 2 | | 506 | 504,754,506 | Duplo → Disney → Cars | 3 | | 640 | 504,754,640 | Duplo → Disney → Disney Princess | 3 | | 648 | 504,754,648 | Duplo → Disney → Doc McStuffins | 3 | | 638 | 504,754,638 | Duplo → Disney → Jake and the Never Land Pirates | 3 | | 641 | 504,754,641 | Duplo → Disney → Mickey & Friends | 3 | | 629 | 504,754,629 | Duplo → Disney → Miles From Tomorrowland | 3 | | 627 | 504,754,627 | Duplo → Disney → Planes | 3 | | 633 | 504,754,633 | Duplo → Disney → Toy Story | 3 | | 635 | 504,754,635 | Duplo → Disney → Winnie the Pooh | 3 | | 659 | 504,659 | Duplo → Dolls | 2 | | 628 | 504,628 | Duplo → Dora the Explorer | 2 | | 722 | 504,722 | Duplo → Jurassic World | 2 | | 660 | 504,660 | Duplo → Little Forest Friends | 2 | | 661 | 504,661 | Duplo → Little Robots | 2 | | 630 | 504,630 | Duplo → Marvel | 2 | | 651 | 504,651 | Duplo → Pirates | 2 | | 652 | 504,652 | Duplo → Playhouse | 2 | | 662 | 504,662 | Duplo → Princess Castle | 2 | | 663 | 504,663 | Duplo → Rattles | 2 | | 639 | 504,639 | Duplo → Sofia the First | 2 | | 631 | 504,631 | Duplo → Thomas & Friends | 2 | | 664 | 504,664 | Duplo → Toolo | 2 | | 632 | 504,632 | Duplo → Town | 2 | | 650 | 504,632,650 | Duplo → Town → Legoville | 3 | | 636 | 504,632,636 | Duplo → Town → My Town | 3 | | 634 | 504,634 | Duplo → Trains | 2 | | 665 | 504,665 | Duplo → Western | 2 | | 666 | 504,666 | Duplo → Zooters | 2 | | 507 | 507 | Educational and Dacta | 1 | | 511 | 507,511 | Educational and Dacta → Building Set with People | 2 | | 516 | 507,516 | Educational and Dacta → Duplo and Explore | 2 | | 517 | 507,517 | Educational and Dacta → Learning | 2 | | 518 | 507,518 | Educational and Dacta → Mindstorms | 2 | | 519 | 507,518,519 | Educational and Dacta → Mindstorms → NXT | 3 | | 520 | 507,518,520 | Educational and Dacta → Mindstorms → RCX | 3 | | 521 | 507,518,521 | Educational and Dacta → Mindstorms → WeDo | 3 | | 523 | 507,523 | Educational and Dacta → Samsonite | 2 | | 510 | 507,510 | Educational and Dacta → Serious Play | 2 | | 524 | 507,524 | Educational and Dacta → Service Packs | 2 | | 525 | 507,524,525 | Educational and Dacta → Service Packs → Technic | 3 | | 526 | 507,526 | Educational and Dacta → Soft Bricks | 2 | | 509 | 507,509 | Educational and Dacta → SPIKE | 2 | | 528 | 507,528 | Educational and Dacta → Supplemental | 2 | | 529 | 507,529 | Educational and Dacta → Technic | 2 | | 530 | 507,529,530 | Educational and Dacta → Technic → Control Lab | 3 | | 531 | 507,529,531 | Educational and Dacta → Technic → eLAB | 3 | | 533 | 507,533 | Educational and Dacta → Town | 2 | | 534 | 507,534 | Educational and Dacta → Universal Building Set | 2 | | 600 | 600 | Elves | 1 | | 389 | 389 | Exo-Force | 1 | | 390 | 390 | Fabuland | 1 | | 397 | 397 | Factory | 1 | | 398 | 398 | FIRST LEGO League | 1 | | 671 | 671 | Forma | 1 | | 766 | 766 | Fortnite | 1 | | 399 | 399 | Freestyle | 1 | | 494 | 494 | Friends | 1 | | 590 | 590 | Fusion | 1 | | 748 | 748 | Gabby's Dollhouse | 1 | | 685 | 685 | Galidor | 1 | | 502 | 502 | Games | 1 | | 501 | 501 | Gear | 1 | | 730 | 501,730 | Gear → Audio and Visual Media | 2 | | 731 | 501,731 | Gear → Bag and Luggage Tags | 2 | | 732 | 501,732 | Gear → Clocks and Watches | 2 | | 733 | 501,733 | Gear → Houseware | 2 | | 503 | 501,503 | Gear → Key Chain | 2 | | 734 | 501,734 | Gear → Magnets | 2 | | 735 | 501,735 | Gear → Plush Toys | 2 | | 736 | 501,736 | Gear → Posters and Art Prints | 2 | | 737 | 501,737 | Gear → Role Play Toys and Costumes | 2 | | 738 | 501,738 | Gear → Seasonal | 2 | | 739 | 501,739 | Gear → Stationery and Office Supplies | 2 | | 740 | 501,740 | Gear → Storage | 2 | | 741 | 501,741 | Gear → Tabletop Games and Puzzles | 2 | | 742 | 501,742 | Gear → Video Games and Accessories | 2 | | 607 | 607 | Ghostbusters | 1 | | 246 | 246 | Harry Potter | 1 | | 667 | 246,667 | Harry Potter → Fantastic Beasts | 2 | | 400 | 400 | Hero Factory | 1 | | 401 | 400,401 | Hero Factory → Heroes | 2 | | 403 | 400,403 | Hero Factory → Villains | 2 | | 676 | 676 | Hidden Side | 1 | | 404 | 404 | Hobby Sets | 1 | | 405 | 405 | Homemaker | 1 | | 721 | 721 | Icons | 1 | | 264 | 264 | Indiana Jones | 1 | | 407 | 407 | Island Xtreme Stunts | 1 | | 591 | 591 | Juniors | 1 | | 615 | 591,615 | Juniors → Cars | 2 | | 592 | 591,592 | Juniors → DC Comics Super Heroes | 2 | | 593 | 591,593 | Juniors → Disney Princess | 2 | | 595 | 591,595 | Juniors → Friends | 2 | | 620 | 591,620 | Juniors → Jurassic World: Fallen Kingdom | 2 | | 596 | 591,596 | Juniors → Marvel Super Heroes | 2 | | 597 | 591,597 | Juniors → Ninjago | 2 | | 602 | 602 | Jurassic World | 1 | | 571 | 571 | Legends of Chima | 1 | | 573 | 571,573 | Legends of Chima → Constraction | 2 | | 572 | 571,572 | Legends of Chima → Speedorz | 2 | | 709 | 709 | LEGO Art | 1 | | 408 | 408 | LEGO Brand Store | 1 | | 619 | 408,619 | LEGO Brand Store → Cities of Wonders | 2 | | 409 | 408,409 | LEGO Brand Store → Monthly Mini Model Build | 2 | | 410 | 408,410 | LEGO Brand Store → Pick A Model | 2 | | 599 | 599 | LEGO Exclusive | 1 | | 576 | 576 | LEGO Ideas and CUUSOO | 1 | | 683 | 683 | LEGO Originals | 1 | | 411 | 411 | Legoland | 1 | | 425 | 425 | Legoland Parks | 1 | | 412 | 411,412 | Legoland → Airport | 2 | | 413 | 411,413 | Legoland → Building | 2 | | 414 | 411,414 | Legoland → Castle | 2 | | 415 | 411,415 | Legoland → Coast Guard | 2 | | 416 | 411,416 | Legoland → Construction | 2 | | 417 | 411,417 | Legoland → Fire | 2 | | 418 | 411,418 | Legoland → Gas Station | 2 | | 419 | 411,419 | Legoland → Harbor | 2 | | 420 | 411,420 | Legoland → Hospital | 2 | | 421 | 411,421 | Legoland → Police | 2 | | 422 | 411,422 | Legoland → Space | 2 | | 423 | 411,423 | Legoland → Vehicle | 2 | | 424 | 411,424 | Legoland → Western | 2 | | 34 | 34 | Make & Create | 1 | | 35 | 34,35 | Make & Create → Bricks & More | 2 | | 432 | 432 | Master Builder Academy | 1 | | 258 | 258 | Mindstorms | 1 | | 262 | 258,262 | Mindstorms → EV3 | 2 | | 259 | 258,259 | Mindstorms → NXT | 2 | | 260 | 258,260 | Mindstorms → RCX | 2 | | 261 | 258,261 | Mindstorms → Star Wars | 2 | | 577 | 577 | Minecraft | 1 | | 689 | 689 | Minions | 1 | | 433 | 433 | Minitalia | 1 | | 580 | 580 | Mixels | 1 | | 278 | 278 | Model Team | 1 | | 155 | 155 | Modular Buildings | 1 | | 156 | 155,156 | Modular Buildings → Mini | 2 | | 716 | 716 | Modulex | 1 | | 693 | 693 | Monkie Kid | 1 | | 558 | 558 | Monster Fighters | 1 | | 605 | 605 | Nexo Knights | 1 | | 434 | 434 | Ninja | 1 | | 435 | 435 | Ninjago | 1 | | 616 | 435,616 | Ninjago → The LEGO Ninjago Movie | 2 | | 301 | 301 | Other | 1 | | 746 | 301,746 | Other → Database Sets | 2 | | 669 | 669 | Overwatch | 1 | | 437 | 437 | Pharaoh's Quest | 1 | | 147 | 147 | Pirates | 1 | | 148 | 147,148 | Pirates → Pirates I | 2 | | 153 | 147,153 | Pirates → Pirates II | 2 | | 154 | 147,154 | Pirates → Pirates III | 2 | | 438 | 438 | Power Functions | 1 | | 655 | 438,655 | Power Functions → Powered Up | 2 | | 439 | 439 | Power Miners | 1 | | 440 | 440 | Primo | 1 | | 598 | 598 | Promotional | 1 | | 729 | 598,729 | Promotional → Airlines | 2 | | 157 | 598,157 | Promotional → Bricktober | 2 | | 471 | 598,471 | Promotional → Ferries | 2 | | 728 | 598,728 | Promotional → McDonalds | 2 | | 441 | 441 | Quatro | 1 | | 112 | 112 | Racers | 1 | | 114 | 112,114 | Racers → Ferrari | 2 | | 118 | 112,118 | Racers → Promotional | 2 | | 122 | 112,122 | Racers → RC | 2 | | 123 | 112,123 | Racers → World Racers | 2 | | 442 | 442 | Rock Raiders | 1 | | 668 | 668 | Scala | 1 | | 603 | 603 | Scooby-Doo | 1 | | 276 | 276 | Sculptures | 1 | | 277 | 276,277 | Sculptures → Mosaic | 2 | | 206 | 206 | Seasonal | 1 | | 207 | 206,207 | Seasonal → Advent | 2 | | 210 | 206,207,210 | Seasonal → Advent → Belville | 3 | | 211 | 206,207,211 | Seasonal → Advent → Castle | 3 | | 208 | 206,207,208 | Seasonal → Advent → City | 3 | | 212 | 206,207,212 | Seasonal → Advent → Classic Basic | 3 | | 213 | 206,207,213 | Seasonal → Advent → Clikits | 3 | | 214 | 206,207,214 | Seasonal → Advent → Creator | 3 | | 216 | 206,207,216 | Seasonal → Advent → Friends | 3 | | 710 | 206,207,710 | Seasonal → Advent → Harry Potter | 3 | | 751 | 206,207,751 | Seasonal → Advent → Marvel | 3 | | 215 | 206,207,215 | Seasonal → Advent → Pirates | 3 | | 209 | 206,207,209 | Seasonal → Advent → Star Wars | 3 | | 227 | 206,227 | Seasonal → Christmas | 2 | | 228 | 206,227,228 | Seasonal → Christmas → Creator | 3 | | 229 | 206,229 | Seasonal → Easter | 2 | | 230 | 206,230 | Seasonal → Halloween | 2 | | 231 | 206,231 | Seasonal → Thanksgiving | 2 | | 232 | 206,232 | Seasonal → Valentine | 2 | | 443 | 443 | Service Packs | 1 | | 453 | 443,453 | Service Packs → Technic | 2 | | 456 | 443,456 | Service Packs → Train | 2 | | 747 | 747 | Sonic The Hedgehog | 1 | | 126 | 126 | Space | 1 | | 127 | 126,127 | Space → Alien Conquest | 2 | | 128 | 126,128 | Space → Blacktron I | 2 | | 129 | 126,129 | Space → Blacktron II | 2 | | 130 | 126,130 | Space → Classic Space | 2 | | 131 | 126,131 | Space → Exploriens | 2 | | 132 | 126,132 | Space → Futuron | 2 | | 146 | 126,146 | Space → Galaxy Squad | 2 | | 133 | 126,133 | Space → Ice Planet 2002 | 2 | | 134 | 126,134 | Space → Insectoids | 2 | | 135 | 126,135 | Space → Life On Mars | 2 | | 136 | 126,136 | Space → M:Tron | 2 | | 137 | 126,137 | Space → Mars Mission | 2 | | 138 | 126,138 | Space → RoboForce | 2 | | 139 | 126,139 | Space → Space Police I | 2 | | 140 | 126,140 | Space → Space Police II | 2 | | 141 | 126,141 | Space → Space Police III | 2 | | 142 | 126,142 | Space → Spyrius | 2 | | 143 | 126,143 | Space → Supplemental | 2 | | 144 | 126,144 | Space → UFO | 2 | | 145 | 126,145 | Space → Unitron | 2 | | 601 | 601 | Speed Champions | 1 | | 717 | 717 | Speed Racer | 1 | | 272 | 272 | SpongeBob SquarePants | 1 | | 458 | 458 | Sports | 1 | | 459 | 458,459 | Sports → Basketball | 2 | | 460 | 458,460 | Sports → Gravity Games | 2 | | 461 | 458,461 | Sports → Hockey | 2 | | 462 | 458,462 | Sports → Soccer | 2 | | 463 | 463 | Spybotics | 1 | | 158 | 158 | Star Wars | 1 | | 171 | 158,171 | Star Wars → Ultimate Collector Series | 2 | | 680 | 680 | Stranger Things | 1 | | 273 | 273 | Studios | 1 | | 274 | 273,274 | Studios → Jurassic Park III | 2 | | 695 | 695 | Super Heroes DC | 1 | | 697 | 695,697 | Super Heroes DC → Batman | 2 | | 708 | 695,697,708 | Super Heroes DC → Batman → The LEGO Batman Movie | 3 | | 698 | 695,697,698 | Super Heroes DC → Batman → UCS | 3 | | 700 | 695,700 | Super Heroes DC → Justice League | 2 | | 701 | 695,701 | Super Heroes DC → Superman | 2 | | 696 | 696 | Super Heroes Marvel | 1 | | 702 | 696,702 | Super Heroes Marvel → Avengers | 2 | | 704 | 696,704 | Super Heroes Marvel → Guardians of the Galaxy | 2 | | 705 | 696,705 | Super Heroes Marvel → Iron Man | 2 | | 706 | 696,706 | Super Heroes Marvel → Spider-Man | 2 | | 755 | 696,706,755 | Super Heroes Marvel → Spider-Man → Spidey and His Amazing Friends | 3 | | 707 | 696,707 | Super Heroes Marvel → X-Men | 2 | | 690 | 690 | Super Mario | 1 | | 365 | 365 | System | 1 | | 368 | 365,368 | System → HO 1:87 Vehicles | 2 | | 369 | 365,369 | System → Jumbo Bricks | 2 | | 756 | 365,756 | System → Samsonite | 2 | | 371 | 365,371 | System → Supplemental | 2 | | 372 | 365,372 | System → Town Plan | 2 | | 1 | 1 | Technic | 1 | | 3 | 1,3 | Technic → Competition | 2 | | 4 | 1,4 | Technic → Expert Builder | 2 | | 16 | 1,16 | Technic → RoboRiders | 2 | | 17 | 1,17 | Technic → Speed Slammers | 2 | | 18 | 1,18 | Technic → Star Wars | 2 | | 19 | 1,19 | Technic → Supplemental | 2 | | 20 | 1,20 | Technic → Throwbot Slizer | 2 | | 21 | 1,21 | Technic → Universal Building Set | 2 | | 570 | 570 | Teenage Mutant Ninja Turtles | 1 | | 561 | 561 | The Hobbit and Lord of the Rings | 1 | | 562 | 561,562 | The Hobbit and Lord of the Rings → The Hobbit | 2 | | 566 | 561,566 | The Hobbit and Lord of the Rings → The Lord of the Rings | 2 | | 764 | 764 | The Legend of Zelda | 1 | | 578 | 578 | The LEGO Movie | 1 | | 670 | 578,670 | The LEGO Movie → The LEGO Movie II | 2 | | 575 | 575 | The Lone Ranger | 1 | | 654 | 654 | The Powerpuff Girls | 1 | | 464 | 464 | Time Cruisers | 1 | | 50 | 50 | Town | 1 | | 51 | 50,51 | Town → Arctic | 2 | | 106 | 50,106 | Town → City Center | 2 | | 67 | 50,67 | Town → Classic Town | 2 | | 86 | 50,86 | Town → Divers | 2 | | 87 | 50,87 | Town → Extreme Team | 2 | | 88 | 50,88 | Town → Launch Command | 2 | | 89 | 50,89 | Town → Outback | 2 | | 90 | 50,90 | Town → Paradisa | 2 | | 91 | 50,91 | Town → Race | 2 | | 92 | 50,92 | Town → Res-Q | 2 | | 93 | 50,93 | Town → Space Port | 2 | | 94 | 50,94 | Town → Town Jr. | 2 | | 104 | 50,104 | Town → Town Plan | 2 | | 105 | 50,105 | Town → World City | 2 | | 275 | 275 | Toy Story | 1 | | 233 | 233 | Train | 1 | | 234 | 233,234 | Train → 12V | 2 | | 235 | 233,235 | Train → 4.5V | 2 | | 236 | 233,236 | Train → 9V | 2 | | 240 | 233,240 | Train → RC Train | 2 | | 241 | 233,241 | Train → Supplemental | 2 | | 682 | 682 | Trolls: World Tour | 1 | | 625 | 625 | Unikitty! | 1 | | 465 | 465 | Universal Building Set | 1 | | 467 | 465,467 | Universal Building Set → Basic | 2 | | 470 | 465,470 | Universal Building Set → Classic Basic | 2 | | 472 | 465,472 | Universal Building Set → Gears | 2 | | 473 | 465,473 | Universal Building Set → Supplemental | 2 | | 560 | 560 | Universe | 1 | | 559 | 559 | Value Packs | 1 | | 713 | 713 | VIDIYO | 1 | | 474 | 474 | Vikings | 1 | | 768 | 768 | Wednesday | 1 | | 475 | 475 | Western | 1 | | 765 | 765 | Wicked | 1 | | 646 | 646 | Xtra | 1 | | 480 | 480 | Znap | 1 | +-----+-------------+----------------------------------------------------------------------+------------+