CRISP SCOOTERS

Crisp Scooters was conceived from the idea of a premium quality scooter with looks to match. The Crisp production team set about searching for the best materials and craftsmanship to make the ultimate in scooter riding a reality. After a lot of testing, trial and error they unleashed their first premium scooter, The Ultima, in the sleek looking ‘Stone Silver’ and tough as ‘Black Chrome’. The full range of parts soon followed. The response was massive with the production team struggling to keep up with demand. Crisp scooters are now slowly expanding and are starting to be sold around the world. The UK and AUS teams feature some of the best up and coming riders going hard everyday and loving it. And this is only the beginning….

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 (98961, 98962, 99108, 99144, 99197, 99198, 99199, 99200, 99201, 99202, 124566, 124567, 124568, 124569, 127047, 127049, 127050, 127051))) AND (e.created_in <= '1638356402') AND (e.updated_in > '1638356402') ORDER BY FIELD(e.entity_id,98961,98962,99108,99144,99197,99198,99199,99200,99201,99202,124566,124567,124568,124569,127047,127049,127050,127051)