SELECT 1 AS `status`, `e`.`entity_id`, `e`.`type_id`, `e`.`attribute_set_id`, `e`.`sku`, `cat_index`.`position` AS `cat_index_position`, `permission_index_product`.`grant_catalog_category_view`, `permission_index_product`.`grant_catalog_product_price`, `permission_index_product`.`grant_checkout_items`, `e`.`name`, `e`.`price`, `e`.`small_image`, `e`.`tax_class_id`, `e`.`url_key`, `e`.`thumbnail`, `e`.`short_description`, `e`.`special_price`, `e`.`special_from_date`, `e`.`special_to_date`, `e`.`news_from_date`, `e`.`news_to_date`, `e`.`required_options`, `e`.`price_type`, `e`.`weight_type`, `e`.`price_view`, `e`.`shipment_type`, `e`.`image_label`, `e`.`small_image_label`, `e`.`thumbnail_label`, `e`.`links_exist`, `e`.`giftcard_amounts`, `e`.`allow_open_amount`, `e`.`open_amount_min`, `e`.`open_amount_max`, `e`.`cost`, `e`.`onsale`, `e`.`size_guide`, `e`.`marques`, `e`.`marques_value`, `e`.`taillets`, `e`.`taillets_value`, `e`.`plocalisation`, `e`.`plocalisation2`, `e`.`store_view_special_price`, `e`.`discipline`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(`price_index`.`tier_price`, 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` FROM `catalog_product_flat_14` AS `e`
INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id='14' AND cat_index.visibility IN(2, 4) AND cat_index.category_id='163'
LEFT JOIN `enterprise_catalogpermissions_index_product` AS `permission_index_product` ON permission_index_product.category_id = cat_index.category_id AND permission_index_product.product_id = cat_index.product_id AND permission_index_product.store_id = cat_index.store_id AND permission_index_product.customer_group_id=0
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '9' AND price_index.customer_group_id = 0 WHERE (permission_index_product.grant_catalog_category_view != -2
OR permission_index_product.grant_catalog_category_view IS NULL) AND (permission_index_product.grant_catalog_product_price != -2
OR permission_index_product.grant_catalog_product_price IS NULL) AND (((price_index.min_price ) * 1) >= 30) AND (((price_index.min_price ) * 1) < 40) ORDER BY CAST(e.classement_produit as DECIMAL(10,5)) asc, CAST(e.classement_produit as DECIMAL(10,5)) asc LIMIT 48