THUNDER

At Skate Hut we have a great selection of Thunder trucks, which, as you probably know, are a staple of the modern-day skating world. Thunder trucks are commonly used by skaters across the world who want to treat their decks with the respect that they deserve. You can browse our extensive and vibrant collection, which includes free delivery on most Thunder trucks, at your leisure. We also offer Thunder bushings, risers and various other accessories which budding and expert skaters alike may like to invest in. Be sure to use the handy filters at the side to help you narrow down the selection.

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 (111826, 111828, 111829, 112343, 112344, 112345, 112625, 125847, 172831, 176499, 176500, 176504, 176505, 176506, 176595))) AND (e.created_in <= '1638356402') AND (e.updated_in > '1638356402') ORDER BY FIELD(e.entity_id,111826,111828,111829,112343,112344,112345,112625,125847,172831,176499,176500,176504,176505,176506,176595)