LOGIC

Logic are one of the best when it comes to the world of scooters. Their range of products stretches to include wheels, SCS clamps, headsets, pegs and grip tape. Their products are at the forefront of innovation in the industry, so it's no surprise that Logic scooters are the choice for riders at every level. At SkateHut we have a range of complete Logic scooters for sale, as well as scooter clamps, bars and headsets for you to create your own setup. Logic scooter bars feature a unique design, with aluminium tubes forming a light but strong support gusset and an extra thick crossbar and down tube that gives strength whilst also keeping the weight down. Logic scooter bars are the lightest and strongest on the market, and they're available to buy on our online shop, along with pegs, clamps and headsets. Make your custom scooter a Logic scooter by choosing quality parts by an industry leader.

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 (160461))) AND (e.created_in <= '1637884861') AND (e.updated_in > '1637884861') ORDER BY FIELD(e.entity_id,160461)