Ponceuse et Polisseuse

SELECT `e`.`entity_id`, `e`.`type_id`, `e`.`attribute_set_id`, `cat_index`.`position` AS `cat_index_position`, `e`.`name`, `e`.`description`, `e`.`short_description`, `e`.`sku`, `e`.`price`, `e`.`special_price`, `e`.`special_from_date`, `e`.`special_to_date`, `e`.`cost`, `e`.`weight`, `e`.`manufacturer`, `e`.`manufacturer_value`, `e`.`image`, `e`.`small_image`, `e`.`thumbnail`, `e`.`media_gallery`, `e`.`tier_price`, `e`.`color`, `e`.`color_value`, `e`.`news_from_date`, `e`.`news_to_date`, `e`.`gallery`, `e`.`status`, `e`.`tax_class_id`, `e`.`url_key`, `e`.`url_path`, `e`.`minimal_price`, `e`.`visibility`, `e`.`required_options`, `e`.`image_label`, `e`.`small_image_label`, `e`.`thumbnail_label`, `e`.`price_type`, `e`.`weight_type`, `e`.`price_view`, `e`.`delai_livraison`, `e`.`delai_livraison_value`, `e`.`ecotaxe`, `e`.`ecotaxe_value`, `e`.`dimensions_en_mm`, `e`.`dimensions_en_mm_value`, `e`.`lengow_product`, `e`.`ean`, `e`.`description_lengow`, `e`.`nombre_de_marches`, `e`.`nombre_de_marches_value`, `e`.`taille_blaklader`, `e`.`taille_blaklader_value`, `e`.`mode_livraison`, `e`.`mode_livraison_value`, `e`.`bandeau_promo`, `e`.`bandeau_promo_value`, `e`.`gs_lengow`, `e`.`gs_name_lengow`, `e`.`prix_livraison`, `e`.`search_boost`, `e`.`promotion_id`, `e`.`promotion_id_value`, `e`.`google_product_category`, `e`.`top_produits`, `e`.`top_produits_value`, `e`.`mp-finition`, `e`.`mp-finition_value`, `e`.`mp-type-de-meuble-de-sdb`, `e`.`mp-type-de-meuble-de-sdb_value`, `e`.`best_offer`, `e`.`best_offer_type`, `e`.`is_from_mkp`, `e`.`best_offer_shop`, `e`.`mp_couleur_precise`, `e`.`mp_couleur_precise_value`, `e`.`mp_conditionnement`, `e`.`mp_conditionnement_value`, `e`.`has_operator_offer`, `e`.`reference_distel`, `e`.`exclude_from_googleshopping`, `e`.`mp_dimension_plaque_mm`, `e`.`mp_dimension_plaque_mm_value`, `e`.`mp_angle_degres`, `e`.`mp_angle_degres_value`, `e`.`mp_longueur_lavabo_vasque`, `e`.`mp_longueur_lavabo_vasque_value`, `e`.`combustible_poele`, `e`.`combustible_poele_value`, `e`.`mp_pression_en_b`, `e`.`mp_pression_en_b_value`, `e`.`mp_contenance_en_l`, `e`.`mp_contenance_en_l_value`, `e`.`lowest_price_part`, `e`.`lowest_price_pro`, `e`.`mp_couleur_revetement`, `e`.`mp_couleur_revetement_value`, `e`.`mp_surface_revetement`, `e`.`mp_surface_revetement_value`, `e`.`mp_dimensions_revetement`, `e`.`mp_dimensions_revetement_value`, `e`.`mp_dimensions_cm`, `e`.`mp_dimensions_cm_value`, `e`.`display_operator_offer`, `e`.`mp_nb_de_pieces`, `e`.`mp_nb_de_pieces_value`, `e`.`brand_position`, `e`.`tier_price_lot`, `e`.`mp_nombre_de_modules`, `e`.`mp_nombre_de_modules_value`, `e`.`mp_largeur_radiateur`, `e`.`mp_largeur_radiateur_value`, `e`.`is_maxoutil`, `e`.`force_include_googleshopping`, `e`.`mp_porte_reversible`, `e`.`mp_porte_reversible_value`, `e`.`mp_type_de_four`, `e`.`mp_type_de_four_value`, `e`.`mp_type_foyer`, `e`.`mp_type_foyer_value`, `e`.`mp_nombre_foyer`, `e`.`mp_nombre_foyer_value`, `e`.`mp_puissance_four`, `e`.`mp_puissance_four_value`, `e`.`mp_securite_anti_fuite`, `e`.`mp_consommation_eau_an`, `e`.`mp_consommation_eau_an_value`, `e`.`mp_consommation_eau_cycle`, `e`.`mp_consommation_eau_cycle_value`, `e`.`mp_consommation_energie_an`, `e`.`mp_consommation_energie_an_value`, `e`.`mp_consommation_energie_cycle`, `e`.`mp_consommation_energie_cycle_value`, `e`.`mp_type_sechage`, `e`.`mp_type_sechage_value`, `e`.`mp_qualite_sechage`, `e`.`mp_qualite_sechage_value`, `e`.`mp_nombre_couverts`, `e`.`mp_nombre_couverts_value`, `e`.`mp_type_de_rideau`, `e`.`mp_type_de_rideau_value`, `e`.`mp_style`, `e`.`mp_style_value`, `e`.`mp_forme_tapis`, `e`.`mp_forme_tapis_value`, `e`.`mp_modele_tapis`, `e`.`mp_modele_tapis_value`, `e`.`mp_poils_tapis`, `e`.`mp_poils_tapis_value`, `e`.`mp_forme_nappe`, `e`.`mp_forme_nappe_value`, `e`.`mp_trop_plein`, `e`.`mp_trop_plein_value`, `e`.`mp_dimension_sortie_boite`, `e`.`mp_dimension_sortie_boite_value`, `e`.`mp_grille`, `e`.`mp_grille_value`, `e`.`frais_port_gg_shopping`, `e`.`is_ptf3`, price_index.price AS `indexed_price`, `price_index`.`price`, `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`, `_inv`.`stock_status`, IFNULL(_inv.stock_status,0) AS `in_stock` FROM `mage_catalog_product_flat_3` AS `e` INNER JOIN `mage_catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=3 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = 5266 AND cat_index.is_parent=1 INNER JOIN `mage_catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = 3 AND price_index.customer_group_id = 0 LEFT JOIN `mage_cataloginventory_stock_status` AS `_inv` ON _inv.product_id = e.entity_id and _inv.website_id=3 and _inv.stock_id=1 WHERE (e.status = 1) ORDER BY `in_stock` DESC, `cat_index`.`position` asc, `cat_index`.`position` ASC LIMIT 48