ETHIC

Ethic is not a brand coming out of nowhere, even though it’s all new, it already has a past, a story, objectives, some wishes, and a certain legitimacy. In an environment ruled by money, they made the choice of reducing margins, betting on the development, respecting their sport’s spirit. They want high quality parts to be accessible to anyone. The objective is to make everyone realize that something else is possible, to make the riders independent, and allow them to make the choices that will give the good image of scootering.

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 (244680, 237577, 237565, 245916, 207053, 98676, 98677, 99221, 99222, 99223, 99225, 99232, 101014, 101041, 101044, 101047, 101197, 101205, 101206, 101214, 101217, 101224, 101247, 101248))) AND (e.created_in <= '1638356402') AND (e.updated_in > '1638356402') ORDER BY FIELD(e.entity_id,244680,237577,237565,245916,207053,98676,98677,99221,99222,99223,99225,99232,101014,101041,101044,101047,101197,101205,101206,101214,101217,101224,101247,101248)
Page