SKATEBOARD TRUCK BOLTS

Here at SkateHut, we love to customise our boards, which is why we have a great range of products so that you can add some individuality to yours. Coloured truck bolts are a good way of changing the look of your trucks, so we’ve got them in all sorts of colours. Of course, you might be modifying your board for high performance, and we’ve got you covered there too. We stock tempered steel truck bolts that will help to make sure your board keeps it together in the most demanding situations. Shop online with us today for the very best skate equipment.

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 (111586, 133526, 133527, 133528, 111513, 111582, 111514, 111599, 111600, 111508, 111583, 111596, 111512, 163651, 111592, 111587, 111511, 111510, 111509, 133524, 111598, 176446, 163653, 111593))) AND (e.created_in <= '1637884861') AND (e.updated_in > '1637884861') ORDER BY FIELD(e.entity_id,111586,133526,133527,133528,111513,111582,111514,111599,111600,111508,111583,111596,111512,163651,111592,111587,111511,111510,111509,133524,111598,176446,163653,111593)
Page