Make your first impression on the track count with a pair of the best roller derby skates that you can buy. When you're looking to buy roller derby skates, you'll want durability, comfort, grip and precision. So, you'll want Skates by leading brands like Riedell, Sure-Grip and Jackson to help you perform at your best. Luckily, we stock all of these brands and more right under one roof here at Skatehut. We're experts in selling skateboards, scooters and skates and we only stock brands that we approve of. All our roller derby skates for sale are made from the highest quality materials to deliver the comfort and performance you need on the track, whether you're a beginner or a pro. Plus, you won't find a better price for skates of this quality. Explore our full collection online for stylish and cheap roller derby skates that'll make sure you stand miles ahead from your competitors.
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 (119291, 119290))) AND (e.created_in <= '1667588400') AND (e.updated_in > '1667588400') ORDER BY FIELD(e.entity_id,119291,119290)