Triad Scooters consists of a talented team with over a combined 20 years of experience in scooter manufacturing. It designs unique scooters to cater to present times as well as the future, designed by riders for riders. Every single scooter part and accessory has been meticulously manufactured for high-performance, allowing Triad Scooters to establish itself as a leading brand within the market.

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 (168904, 174945, 174946, 174947, 174948, 174949, 175163, 175164, 175165, 175166, 175167, 175168, 175169, 175170))) AND (e.created_in <= '1660327200') AND (e.updated_in > '1660327200') ORDER BY FIELD(e.entity_id,168904,174945,174946,174947,174948,174949,175163,175164,175165,175166,175167,175168,175169,175170)

Showing 38 out of 38