GBP £

For Sales & Advice Call Us on 0121 501 1111

Search

Menu
Settings
  • AUD A$
  • CAD CA$
  • USD $

    • BMX GRIPS

    For the best in BMX grips from leading industry names, look no further than the selection of BMX handlebar grips we have here at SkateHut. An essential part of any BMX, your handlebar grips help you stay in control better when riding or pulling tricks. We are proud to say we have bike grips from big brands such as Cult, ODI and Raptor in a variety of colours and styles to suit your setup. So take a look through our collection of BMW grips today and place an order with 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 (235291, 62661, 62666, 62667, 62676, 62681, 62686, 62698, 62700, 62701, 62702, 62704, 62713, 62714, 62716, 62719, 62721, 62724, 62725, 127840, 127841, 127842, 127847, 127927))) AND (e.created_in <= '1638356402') AND (e.updated_in > '1638356402') ORDER BY FIELD(e.entity_id,235291,62661,62666,62667,62676,62681,62686,62698,62700,62701,62702,62704,62713,62714,62716,62719,62721,62724,62725,127840,127841,127842,127847,127927)
    Page