Nitro Circus, the self-styled “action sports collective” are something of a phenomenon. With a tour, various television series and a 3D feature film under their belt, when it comes to extreme sport, there are few as successful and popular as the Nitro Circus crew. Now with their own range of Nitro Circus scooters and Nitro Circus stunt scooters, as well as grind rails and clothing, they’re allowing the general public a pass in to their world, so you too can feel like one of the collective. If you’re feeling particularly adventurous, the Nitro Circus ramps will provide you with all you need to perform your own incredible stunts. With pre-selected bundles available too, you don’t have to go through the hassle of selecting individual pieces to put together an incredible course.

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 (286509, 286799, 131103, 82284, 233444, 233445, 233446, 233447, 235035, 235038, 82285, 82319, 82320, 82321, 82323, 82324, 101691, 108943, 108995, 132339))) AND (e.created_in <= '1656698400') AND (e.updated_in > '1656698400') ORDER BY FIELD(e.entity_id,286509,286799,131103,82284,233444,233445,233446,233447,235035,235038,82285,82319,82320,82321,82323,82324,101691,108943,108995,132339)

20 Items