SCOOTER FORKS

There are 2 main types of scooter fork the 1st being threaded, up until recently this was the main stay of the industry, offering a simple option to connect your forks to the handle bars. The 2nd type are threadless, these can offer greater security and feel between the forks and the handlebars, fitment of threadless forks will require a compression system and threadless headset. Again strength and weight are key when choosing a fork. Here at SkateHut we have a wide range of forks that cover the need of every rider. We stock all the best brands available in the UK.

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 (101429, 245294, 101428, 101421, 101424, 101924, 101917, 160606, 101919, 101920, 101921, 101923, 101422, 101431, 101954, 101425, 102085, 101423, 101947, 160463, 160587, 101432, 101922, 101927))) AND (e.created_in <= '1637884861') AND (e.updated_in > '1637884861') ORDER BY FIELD(e.entity_id,101429,245294,101428,101421,101424,101924,101917,160606,101919,101920,101921,101923,101422,101431,101954,101425,102085,101423,101947,160463,160587,101432,101922,101927)
Page