SKATEBOARD SALE

Our skateboard sale offers incredible value for money, with cheap skateboards from mainstream brands available across the site. Why not beef up your collection and get yourself plenty of boards to experiment on. Not compromising on quality, our discount skateboards are still amongst some of the best available, coming in a variety of styles and prices. Shop the best collection of cheap skateboards right here. We also have spare parts and accessories available too, including an awesome range of decks that come with free MOB grip tape!

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 (110774, 110775, 110776, 110777, 110778, 110779, 110792, 136162, 84141, 84143, 110827, 84145, 110825, 84157, 110830, 84162, 84138, 84144, 84150, 84161, 109055, 154467, 154468, 158665))) AND (e.created_in <= '1638356402') AND (e.updated_in > '1638356402') ORDER BY FIELD(e.entity_id,110774,110775,110776,110777,110778,110779,110792,136162,84141,84143,110827,84145,110825,84157,110830,84162,84138,84144,84150,84161,109055,154467,154468,158665)
Page