SELECT DISTINCT `e`.*, `cat_index`.`position` AS `cat_index_position`, `stock_status_index`.`stock_status` AS `is_salable`, `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`, `stock_qty`.`stock_status` AS `salable`, `stock_qty`.`qty`, IF(season_sort_option_value_t2.value_id IS NULL, season_sort_option_value_t1.value, season_sort_option_value_t2.value) AS `season_sort`, IF(kind_of_vehicule_sort_option_value_t2.value_id IS NULL, kind_of_vehicule_sort_option_value_t1.value, kind_of_vehicule_sort_option_value_t2.value) AS `kind_of_vehicule_sort` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id='3' INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id AND stock_status_index.website_id = 0 AND stock_status_index.stock_id = 1 INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 INNER JOIN `catalog_product_index_eav` AS `layered_nav_brand` ON `layered_nav_brand`.`entity_id` = `e`.`entity_id` AND `layered_nav_brand`.`attribute_id` = '140' AND `layered_nav_brand`.`store_id` = '1' AND `layered_nav_brand`.`value` IN (13) INNER JOIN `catalog_product_index_eav` AS `layered_nav_width` ON `layered_nav_width`.`entity_id` = `e`.`entity_id` AND `layered_nav_width`.`attribute_id` = '132' AND `layered_nav_width`.`store_id` = '1' AND `layered_nav_width`.`value` IN (98) INNER JOIN `catalog_product_index_eav` AS `layered_nav_height` ON `layered_nav_height`.`entity_id` = `e`.`entity_id` AND `layered_nav_height`.`attribute_id` = '133' AND `layered_nav_height`.`store_id` = '1' AND `layered_nav_height`.`value` IN (42) INNER JOIN `catalog_product_index_eav` AS `layered_nav_diameter` ON `layered_nav_diameter`.`entity_id` = `e`.`entity_id` AND `layered_nav_diameter`.`attribute_id` = '134' AND `layered_nav_diameter`.`store_id` = '1' AND `layered_nav_diameter`.`value` IN (55) LEFT JOIN `cataloginventory_stock_status` AS `stock_qty` ON e.entity_id = stock_qty.product_id LEFT JOIN `catalog_product_entity_int` AS `season_sort_t1` ON e.entity_id=season_sort_t1.entity_id AND season_sort_t1.attribute_id='172' AND season_sort_t1.store_id=0 LEFT JOIN `catalog_product_entity_int` AS `season_sort_t2` ON e.entity_id=season_sort_t2.entity_id AND season_sort_t2.attribute_id='172' AND season_sort_t2.store_id='1' LEFT JOIN `eav_attribute_option_value` AS `season_sort_option_value_t1` ON season_sort_option_value_t1.option_id=IF(season_sort_t2.value_id > 0, season_sort_t2.value, season_sort_t1.value) AND season_sort_option_value_t1.store_id=0 LEFT JOIN `eav_attribute_option_value` AS `season_sort_option_value_t2` ON season_sort_option_value_t2.option_id=IF(season_sort_t2.value_id > 0, season_sort_t2.value, season_sort_t1.value) AND season_sort_option_value_t2.store_id=1 LEFT JOIN `catalog_product_entity_int` AS `kind_of_vehicule_sort_t1` ON e.entity_id=kind_of_vehicule_sort_t1.entity_id AND kind_of_vehicule_sort_t1.attribute_id='171' AND kind_of_vehicule_sort_t1.store_id=0 LEFT JOIN `catalog_product_entity_int` AS `kind_of_vehicule_sort_t2` ON e.entity_id=kind_of_vehicule_sort_t2.entity_id AND kind_of_vehicule_sort_t2.attribute_id='171' AND kind_of_vehicule_sort_t2.store_id='1' LEFT JOIN `eav_attribute_option_value` AS `kind_of_vehicule_sort_option_value_t1` ON kind_of_vehicule_sort_option_value_t1.option_id=IF(kind_of_vehicule_sort_t2.value_id > 0, kind_of_vehicule_sort_t2.value, kind_of_vehicule_sort_t1.value) AND kind_of_vehicule_sort_option_value_t1.store_id=0 LEFT JOIN `eav_attribute_option_value` AS `kind_of_vehicule_sort_option_value_t2` ON kind_of_vehicule_sort_option_value_t2.option_id=IF(kind_of_vehicule_sort_t2.value_id > 0, kind_of_vehicule_sort_t2.value, kind_of_vehicule_sort_t1.value) AND kind_of_vehicule_sort_option_value_t2.store_id=1 WHERE (stock_status_index.stock_status = 1) AND (stock_qty.qty > 1 AND stock_qty.website_id = 0 AND e.price > 1) ORDER BY `cat_index`.`position` ASC, `season_sort` asc, `kind_of_vehicule_sort` asc LIMIT 24