In order to maintain consistency within the LEGO community, The Holo-Brick Archives uses the official LEGO set numbers and names or those standardised by Bricklink.com and Brickset.com wherever possible. In some cases, where this information is not available, The Holo-Brick Archives will employ a temporary reference number.
WordPress database error: [Table 'holobrickarchives.lego_sets' doesn't exist]
SELECT
s.*,
t.type_name AS set_type,
sub.name AS subtheme,
p.packaging_type AS packaging,
e.name AS era,
src.name AS movie,
a.availability AS availability
FROM lego_sets s
LEFT JOIN lego_set_type t ON t.type_id = s.set_type_id
LEFT JOIN lego_subthemes sub ON sub.subtheme_id = s.subtheme_id
LEFT JOIN lego_packaging p ON p.packaging_id = s.packaging_id
LEFT JOIN lego_set_era e ON e.category_id = s.era_id
LEFT JOIN lego_source src ON src.movie_id = s.movie_id
LEFT JOIN lego_availability a ON a.availability_id = s.availability_id
WHERE s.set_number = '9509'
LIMIT 1
Sorry, that set does not exist in our archives.
Please click on your back button and try again.

