MARZOCCHI

In 1949, two brothers founded the Marzocchi brand, which soon went on to produce a championship-winning motorsports suspension and top of the range brands like Ferrari, Lamborghini and Maserati were all-in on Maserati! In 1989, Marzocchi set its eyes on mountain biking, where it’s exceptional ride dynamics products, together with the technology used to make the products, helped to take the sport to another level.

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 (235305, 235302, 235303, 235304, 62123, 62124, 62125, 62126, 62127, 62130, 62132, 62133, 62134, 62372, 135241, 156454, 156456, 156458, 156459, 156463, 156464, 156465, 156468, 156474))) AND (e.created_in <= '1638356402') AND (e.updated_in > '1638356402') ORDER BY FIELD(e.entity_id,235305,235302,235303,235304,62123,62124,62125,62126,62127,62130,62132,62133,62134,62372,135241,156454,156456,156458,156459,156463,156464,156465,156468,156474)
Page