District Freestyle Scooter Co. built its reputation as a pioneer of modern freestylescooter products, setting the standard for freestyle scooter design and performance. Many of the greatest riders are, or have been, involved with District product development and testing. No professional rider or shop owner throughout the world exists who is not aware of the District movement. Nevertheless, the real accomplishment is District’s product innovations that redefined the high performance freestyle scooter industry, separating the hardcore equipment from the fold-up toys of the past. As a global team, District has one mission: to forever improve the art and sport of freestyle scooter riding.

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 (254313, 286361, 98926, 127066, 286122, 98927, 98964, 99109, 101187, 101283, 101395, 101513, 101514, 101515, 160542))) AND (e.created_in <= '1653037202') AND (e.updated_in > '1653037202') ORDER BY FIELD(e.entity_id,254313,286361,98926,127066,286122,98927,98964,99109,101187,101283,101395,101513,101514,101515,160542)

15 Items