ROYAL RACING

Designed to withstand the ruggedness of mountain biking, Royal Racing products are packed to the brim with features. Their jerseys, shorts and gloves have everything you need to stay protected, cool and dry out on the hills. Shop Royal Racing at SkateHut now! Sullivan sports range includes reliable tri scooters, bikes and slider trikes for children. They are a brand which parents can count on and their aim is to give kids the opportunity to have fun in the outdoors safely. Safety is at the heart of what they do; their products have been fully tested in the laboratory as well as on the go!

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 (67632, 225859, 59328, 225860, 225863, 59323, 59325, 67631, 225858, 151970))) AND (e.created_in <= '1638356402') AND (e.updated_in > '1638356402') ORDER BY FIELD(e.entity_id,67632,225859,59328,225860,225863,59323,59325,67631,225858,151970)