RIEDELL

As an established and trustworthy brand, Riedell is undoubtedly an industry leader in the field of roller skates. Riedell roller skates are used by professionals around the world, which represents how prestigious they are considered to be. Whether an accomplished skater or just starting out, Riedell quad skates are a great investment, and are as sturdy as they are fast. Riedell roller derby boots are particularly popular, and we stock some of the best available. We also stock Riedell bearings for those of you whose boots need some much needed maintenance, so whatever you’re after, you can be sure we have your needs covered.

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 (119266, 119267, 119270, 119271, 119272, 119273, 119282, 122551))) AND (e.created_in <= '1632902400') AND (e.updated_in > '1632902400') ORDER BY FIELD(e.entity_id,119266,119267,119270,119271,119272,119273,119282,122551)