Here at SkateHut, we know how it feels when your board snaps or loses all of its graphics, which is why we stock such a great range of skateboard decks in our excellent online store. With over 600 decks from all of the major skate brands, we’re confident you’ll find the deck you’re looking for, however you like to ride. We’ve got a fantastic selection of colours, graphics and designs to suit any style. Whether you’re creating a whole new board, or changing your existing setup, buy online today and you’ll enjoy our fast delivery and great service. Just use the filters on the left to get your ideal deck! FREE GRIPTAPE WITH EVERY DECK!
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 (261537, 261544, 169150, 137251, 112123, 298275, 298276, 298297, 298298, 130764, 298835, 297483, 297484, 297485, 297487, 297488, 297489, 297490, 297491, 297492, 297493, 297494, 297495, 297496))) AND (e.created_in <= '1656698400') AND (e.updated_in > '1656698400') ORDER BY FIELD(e.entity_id,261537,261544,169150,137251,112123,298275,298276,298297,298298,130764,298835,297483,297484,297485,297487,297488,297489,297490,297491,297492,297493,297494,297495,297496)
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.
