WordPress database error: [Table 'admin_main.wp_yoast_primary_term' doesn't exist] SELECT * FROM `wp_yoast_primary_term` WHERE `post_id` = '616811' AND `taxonomy` = 'category' LIMIT 1
WordPress database error: [Table 'admin_main.wp_yoast_primary_term' doesn't exist] SELECT * FROM `wp_yoast_primary_term` WHERE `post_id` = '616811' AND `taxonomy` = 'category' LIMIT 1
WordPress database error: [Table 'admin_main.wp_yoast_indexable_hierarchy' doesn't exist] DELETE FROM `wp_yoast_indexable_hierarchy` WHERE `indexable_id` = '0'
WordPress database error: [Table 'admin_main.wp_yoast_indexable' doesn't exist] SELECT * FROM `wp_yoast_indexable` WHERE `object_id` = '100' AND `object_type` = 'user' LIMIT 1
WordPress database error: [Table 'admin_main.wp_yoast_indexable' doesn't exist] SELECT * FROM `wp_yoast_indexable` WHERE `object_id` = '100' AND `object_type` = 'user' LIMIT 1
WordPress database error: [Table 'admin_main.wp_users' doesn't exist] SELECT * FROM wp_users WHERE ID = '100' LIMIT 1
WordPress database error: [Table 'admin_main.wp_users' doesn't exist] SELECT * FROM wp_users WHERE ID = '100' LIMIT 1
WordPress database error: [Table 'admin_main.wp_users' doesn't exist] SELECT * FROM wp_users WHERE ID = '100' LIMIT 1
WordPress database error: [Table 'admin_main.wp_users' doesn't exist] SELECT * FROM wp_users WHERE ID = '100' LIMIT 1
WordPress database error: [Table 'admin_main.wp_yoast_indexable' doesn't exist] SELECT `id` FROM `wp_yoast_indexable` WHERE `object_type` = 'post' AND `object_sub_type` IN ('post') AND `author_id` = '100' AND `is_public` = '1' LIMIT 1
WordPress database error: [Table 'admin_main.wp_yoast_indexable' doesn't exist] SELECT `id` FROM `wp_yoast_indexable` WHERE `object_type` = 'post' AND `object_sub_type` IN ('post') AND `author_id` = '100' AND `is_public` = '1' LIMIT 1
WordPress database error: [Table 'admin_main.wp_yoast_indexable' doesn't exist] SELECT `id` FROM `wp_yoast_indexable` WHERE `object_type` = 'post' AND `object_sub_type` IN ('post') AND `author_id` = '100' AND `is_public` IS NULL LIMIT 1
WordPress database error: [Table 'admin_main.wp_yoast_indexable' doesn't exist] SELECT `id` FROM `wp_yoast_indexable` WHERE `object_type` = 'post' AND `object_sub_type` IN ('post') AND `author_id` = '100' AND `is_public` IS NULL LIMIT 1
WordPress database error: [Table 'admin_main.wp_users' doesn't exist] SELECT * FROM wp_users WHERE ID = '100' LIMIT 1
WordPress database error: [Table 'admin_main.wp_yoast_indexable' doesn't exist] SELECT * FROM `wp_yoast_indexable` WHERE `object_id` = '13872' AND `object_type` = 'user' LIMIT 1
WordPress database error: [Table 'admin_main.wp_yoast_indexable' doesn't exist] SELECT * FROM `wp_yoast_indexable` WHERE `object_id` = '13872' AND `object_type` = 'user' LIMIT 1
WordPress database error: [Table 'admin_main.wp_yoast_indexable_hierarchy' doesn't exist] SELECT `ancestor_id` FROM `wp_yoast_indexable_hierarchy` WHERE `indexable_id` = '0' ORDER BY `depth` DESC
WordPress database error: [Table 'admin_main.wp_yoast_indexable_hierarchy' doesn't exist] SELECT `ancestor_id` FROM `wp_yoast_indexable_hierarchy` WHERE `indexable_id` = '0' ORDER BY `depth` DESC
WordPress database error: [Table 'admin_main.wp_users' doesn't exist] SELECT * FROM wp_users WHERE ID = '100' LIMIT 1
WordPress database error: [Table 'admin_main.wp_users' doesn't exist] SELECT * FROM wp_users WHERE ID = '100' LIMIT 1
WordPress database error: [Table 'admin_main.wp_users' doesn't exist] SELECT * FROM wp_users WHERE ID = '100' LIMIT 1
WordPress database error: [Table 'admin_main.wp_users' doesn't exist] SELECT * FROM wp_users WHERE ID = '100' LIMIT 1
WordPress database error: [Table 'admin_main.wp_users' doesn't exist] SELECT * FROM wp_users WHERE ID IN (100)
WordPress database error: [Table 'admin_main.wp_users' doesn't exist] SELECT * FROM wp_users WHERE ID = '100' LIMIT 1
WordPress database error: [Table 'admin_main.wp_users' doesn't exist] SELECT * FROM wp_users WHERE ID IN (100)
WordPress database error: [Table 'admin_main.wp_users' doesn't exist] SELECT * FROM wp_users WHERE ID = '100' LIMIT 1
WordPress database error: [Table 'admin_main.wp_users' doesn't exist] SELECT * FROM wp_users WHERE ID = '100' LIMIT 1
WordPress database error: [Table 'admin_main.wp_users' doesn't exist] SELECT * FROM wp_users WHERE ID = '100' LIMIT 1
WordPress database error: [Table 'admin_main.wp_users' doesn't exist] SELECT * FROM wp_users WHERE ID = '100' LIMIT 1
WordPress database error: [Table 'admin_main.wp_users' doesn't exist] SELECT * FROM wp_users WHERE ID = '100' LIMIT 1
WordPress database error: [Table 'admin_main.wp_users' doesn't exist] SELECT * FROM wp_users WHERE ID = '100' LIMIT 1
WordPress database error: [Table 'admin_main.wp_users' doesn't exist] SELECT * FROM wp_users WHERE ID = '100' LIMIT 1
WordPress database error: [Table 'admin_main.wp_users' doesn't exist] SELECT * FROM wp_users WHERE ID IN (100)
WordPress database error: [Table 'admin_main.wp_users' doesn't exist] SELECT * FROM wp_users WHERE ID = '100' LIMIT 1
WordPress database error: [Table 'admin_main.wp_users' doesn't exist] SELECT * FROM wp_users WHERE ID = '100' LIMIT 1
WordPress database error: [Table 'admin_main.wp_users' doesn't exist] SELECT * FROM wp_users WHERE ID = '100' LIMIT 1
WordPress database error: [Table 'admin_main.wp_users' doesn't exist] SELECT * FROM wp_users WHERE ID = '100' LIMIT 1
WordPress database error: [Table 'admin_main.wp_users' doesn't exist] SELECT * FROM wp_users WHERE ID = '100' LIMIT 1
We Found Rare Lego Amazon Prime Day Deals up to 54% Off: Botanicals, Star Wars & More at $
July 9, 2025
E! News Illustration / Photos Courtesy of Lego
Our writers and editors independently determine what we cover and recommend. When you buy through our links, E! may earn a commission. Learn more.
You’re never too old for LEGO (unless you’re literally turning 100), and honestly, building intricate sets is the kind of hobby we fully support in adulthood. But let’s be real: collecting those iconic kits—especially from legacy lines like Star Wars, Nintendo, and the ever-gorgeous Botanicals—can get seriously expensive. That’s why Amazon Prime Day 2025 is the time to treat yourself. Right now, we’re seeing jaw-dropping discounts of up to 54% off on some of the most popular and nostalgic LEGO sets, including that Millennium Falcon build you’ve had in your cart since forever.
One thing to keep in mind: the best LEGO Prime Day deals tend to sell out fast, especially when prices dip this low. If you see something on your wishlist, don’t hesitate. We did the digging for you and rounded up the best Amazon LEGO deals available right now—so you can stock up and save before everything disappears.
Best Prime Day LEGO Set Deals:
LEGO Botanicals Lucky Bamboo Building Set
This bamboo Lego building set is easy to set up and works as a great decor piece for your office desk (trust).
Lego flowers are still everywhere online, and this mini orchid is the latest must-have. It’s 20% off right now, already racked up over 10,000 buys on Amazon, and doubles as a seriously cute centerpiece once built.
Can’t snag a Switch 2? Treat yourself to the next best thing: this iconic 540-piece Lego Piranha Plant set, now 20% off and ready to channel serious Mario energy. It’s just tricky enough to keep you entertained but chill enough for a cozy night in.
LEGO Star Wars Millennium Falcon A New Hope 25th Anniversary Collectable Model
The Millennium Falcon isn’t just the most iconic ship in Star Wars—it’s a certified grail for collectors, Lego-obsessed or not. Right now, you can score this detailed build for 20% off, and it even comes with a 25th anniversary Star Wars Lego brick that’ll make any fan feel nostalgic (and maybe a little ancient).
Whether you’re shopping for a kid or just a Pixar-loving grown-up (no judgment), this Up-inspired LEGO set is currently 54% off, its lowest price ever. Yes, it includes the iconic balloon house, and yes, it’s ridiculously cute.
R2-D2 might just be the most iconic droid in Star Wars, though C-3PO would probably argue otherwise. Either way, this standout Lego set is a fan favorite and a total must-have, especially now that it’s available at a sweet discount.
LEGO Creator 3 in 1 Flowers in Watering Can Building Toy Set
This charming three-in-one Lego set lets you build a watering can, rain boot, or birds, each with movable flowers. One five-star reviewer raved it’s “quick and easy to assemble” and loved that having three build options totally triples the fun.
LEGO Disney Princess Market Adventure Building Toy Set
This Disney-themed set, perfect for kids 6 and up, features four beloved princesses. Build Tiana’s restaurant, Cinderella’s dress shop, Ariel’s treasure shop, and Aurora’s flower shop all in one magical playset.
Where can I find the best 2025 Amazon Prime Day deals?
Stay ahead of jaw-dropping sales by regularly checking E! Insider Shop. We’ve made it easy to shop all the best deals right away by compiling editor-approved Prime Day picks into one convenient place.
When does Prime Day 2025 end?
Amazon Prime Day 2025 runs from July 8 to July 11. However, some deals will still be available after that date. Tune in to the E! Insider Shop to find amazing deals even after the sale ends.
How often does Amazon Prime Day happen?
Amazon Prime Day only officially happens once a year. However, Amazon also hosts an October Prime Day as well as a Big Spring Sale, so there are tons of opportunities to save.
E! Illustration/ Getty Images
How We Choose
The E! Insider Shop editors and writers search the internet to find the best products out there. We interview expert sources, comb through customer reviews, and use our own personal experiences to make shopping easier for our readers.
As an editorial team, we independently create content and determine coverage based on research, reporting and what we think our readers would like to read about. The goal of our content is to provide a service and inform readers who are on the hunt for the latest products to help make their life better. Items are sold by retailer, not E!. Pricing and availability are accurate as of publish time.
E! News Illustration / Photos Courtesy of Lego
