MAXXIS

Maxxis International is committed to delivering high-quality tyres to the world at affordable prices. Well-known for its high-performance bicycle tyres, Maxxis also produces tyres for motorcycle, car, van, truck, HGV, agricultural vehicles and plenty more, all to an outstanding quality. Maxxis products are thoroughly tested in our their own facilities and at the world’s leading tyre test centres. In addition, Maxxis engineers test tyres with their national and world-class champions and teams all over the world. Maxxis utilise the most advanced manufacturing equipment and engineering facilities in the industry, with a stringent professional evaluation before the production of every new tyre. Outfit your ride with Maxxis today!

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 (62095))) AND (e.created_in <= '1638356402') AND (e.updated_in > '1638356402') ORDER BY FIELD(e.entity_id,62095)