QUAD ROLLER SKATES

Shop one of the largest collections of roller skates in the UK. Looking to get into skating for the first time? Quad roller skates can be a great option for boys, girls, men and women alike. With four chunky wheels and a reliable front brake, quad skates offer one of the easiest ways to start skating. Buy your first pair of quad skates, a replacement for your existing ones or add to your collection, we stock roller skates from leading brands such as SFR, Rio Roller and Rookie. Shopping specifically for roller boots? Use the filter options to narrow your search based on price, colour, brand, size and more.

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 (245460, 155154, 155139, 155140, 155151, 155153, 155155, 155156, 119314, 155134, 155135, 155150, 155152, 155157, 153280, 119353, 153275, 167187, 119311, 119310, 119371, 153273, 119362, 153274))) AND (e.created_in <= '1638698403') AND (e.updated_in > '1638698403') ORDER BY FIELD(e.entity_id,245460,155154,155139,155140,155151,155153,155155,155156,119314,155134,155135,155150,155152,155157,153280,119353,153275,167187,119311,119310,119371,153273,119362,153274)
Page