SCOOTER WHEELS

Scooter wheels have become one of the most important parts of the set up as freestyling and big tricks has become the norm. Eagle Sport Metal Core Wheels lead the way, manufacturing wheels that breed confidence when riding, they will not let you down, Wheels typically range between 100mm - 200mm depending on application but here at SkateHut we stock loads of wheels to suit everyones needs.

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 = '5' LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 5 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 (98683, 229089, 233551, 233618, 233634, 233635, 233636, 233641, 237575, 237576, 237577, 237578, 237583, 237590, 238796, 229085, 229086, 229087, 233617, 233639, 237580, 237584, 237588, 237589))) AND (e.created_in <= '1637884861') AND (e.updated_in > '1637884861') ORDER BY FIELD(e.entity_id,98683,229089,233551,233618,233634,233635,233636,233641,237575,237576,237577,237578,237583,237590,238796,229085,229086,229087,233617,233639,237580,237584,237588,237589)
Page