Browse a full range of the best scooter grips in the UK! Shop grips with maximum comfort, maximum grip and magnificent design. Handlebar grips are an important part of the scooter, they are available in foam or rubber forms. The more comfortable you are with the grips, the more confidence you will have going into jumps and performing bar spins. Find scooter parts that will make your tricks more fluid, here at SkateHut. We have a wide range of grips that cover the need of every rider. Use the price, colour and product filters at the side to find the right grips for you!
GBP
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 (101608, 233623, 238801, 238803, 238807, 238808, 245289, 251765, 251766, 253871, 62700, 101624, 101621, 101628, 101622, 101625, 101195, 101623, 160480, 101196, 160482, 101615, 101626, 101736))) AND (e.created_in <= '1653674400') AND (e.updated_in > '1653674400') ORDER BY FIELD(e.entity_id,101608,233623,238801,238803,238807,238808,245289,251765,251766,253871,62700,101624,101621,101628,101622,101625,101195,101623,160480,101196,160482,101615,101626,101736)
We use cookies and other similar technologies to improve your browsing experience and the functionality of our site. By clicking "Accept All Cookies", you consent to the storing on your device of all the technologies described in our Privacy Policy.
