LUCKY SCOOTERS

Browse online today for a range of Lucky scooters and Lucky scooter accessories. Here at SkateHut, we’re specialists in sourcing the most desirable skate and scooter brands from across the globe and offering them to our customers at even more desirable prices. Our Lucky scooters are in our special SkateHut price match promise so you can build your very own Lucky scooter without breaking the bank. We also offer accessories like Lucky scooter wheels and scooter bars to help you on your scooter building journey. Shop now for a range of Lucky scooters and Lucky scooter parts so you can create your unique custom scooter here at SkateHut.

Loading...
SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary`, `stock_status_index`.`stock_status` AS `is_salable` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1' LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 1 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product')) INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id WHERE ((stock_status_index.stock_status = 1) AND (e.entity_id IN (238800, 238803, 238799, 238807, 238808, 99012, 99014, 101180, 101292, 101449, 101450, 101668, 101798, 101799, 102136, 102143, 102147, 136655))) AND (e.created_in <= '1641570900') AND (e.updated_in > '1641570900') ORDER BY FIELD(e.entity_id,238800,238803,238799,238807,238808,99012,99014,101180,101292,101449,101450,101668,101798,101799,102136,102143,102147,136655)