SELECTp0_.idASid_0,p0_.createdAScreated_1,p0_.visibleASvisible_2,p0_.newsletterASnewsletter_3,p0_.date_debutASdate_debut_4,p0_.date_finASdate_fin_5,p0_.urlASurl_6,p0_.titreAStitre_7,p0_.contenuAScontenu_8FROMpopupp0_WHEREp0_.visible=?AND ((p0_.date_fin>=?ORp0_.date_finISNULL)) AND ((p0_.date_debut<=?ORp0_.date_debutISNULL)) ORDER BYp0_.date_debutDESCLIMIT1
SELECTp0_.idASid_0,p0_.createdAScreated_1,p0_.visibleASvisible_2,p0_.newsletterASnewsletter_3,p0_.date_debutASdate_debut_4,p0_.date_finASdate_fin_5,p0_.urlASurl_6,p0_.titreAStitre_7,p0_.contenuAScontenu_8FROMpopupp0_WHEREp0_.visible=?AND (
(
p0_.date_fin>=?ORp0_.date_finISNULL
)
)
AND (
(
p0_.date_debut<=?ORp0_.date_debutISNULL
)
)
ORDER BYp0_.date_debutDESCLIMIT1
SELECTp0_.idASid_0,p0_.createdAScreated_1,p0_.visibleASvisible_2,p0_.newsletterASnewsletter_3,p0_.date_debutASdate_debut_4,p0_.date_finASdate_fin_5,p0_.urlASurl_6,p0_.titreAStitre_7,p0_.contenuAScontenu_8FROMpopupp0_WHEREp0_.visible=1AND ((p0_.date_fin>='2026-09-24 16:23:59'ORp0_.date_finISNULL)) AND ((p0_.date_debut<='2026-09-24 16:23:59'ORp0_.date_debutISNULL)) ORDER BYp0_.date_debutDESCLIMIT1;
SELECTp0_.createdAScreated_0,p0_.updatedASupdated_1,p0_.idASid_2,p0_.visibleASvisible_3,p0_.archiveASarchive_4,p0_.exclude_columbusASexclude_columbus_5,p0_.nouveauASnouveau_6,p0_.precommandeASprecommande_7,p0_.precommande_dateASprecommande_date_8,p0_.offre_specialeASoffre_speciale_9,p0_.cadeauAScadeau_10,p0_.goodieASgoodie_11,p0_.declinaisonASdeclinaison_12,p0_.declinaison_principaleASdeclinaison_principale_13,p0_.referenceASreference_14,p0_.titreAStitre_15,p0_.titre_brouillonAStitre_brouillon_16,p0_.contenuAScontenu_17,p0_.contenu_brouillonAScontenu_brouillon_18,p0_.contenu2AScontenu2_19,p0_.contenu2_brouillonAScontenu2_brouillon_20,p0_.slugASslug_21,p0_.prix_achat_htASprix_achat_ht_22,p0_.montantHTASmontantHT_23,p0_.montantTTCASmontantTTC_24,p0_.montantActuelTTCASmontantActuelTTC_25,p0_.tvaAStva_26,p0_.stockASstock_27,p0_.alerte_stockASalerte_stock_28,p0_.stock_emaplacementASstock_emaplacement_29,p0_.poidsASpoids_30,p0_.recherche_keywordASrecherche_keyword_31,p0_.recherche_slugASrecherche_slug_32,p0_.recherche_carac_attr_slugASrecherche_carac_attr_slug_33,p0_.produits_associesASproduits_associes_34,p0_.meta_titleASmeta_title_35,p0_.meta_keywordASmeta_keyword_36,p0_.meta_descriptionASmeta_description_37,p0_.note_avisASnote_avis_38,p0_.nb_avisASnb_avis_39,p0_.image_panorama_nameASimage_panorama_name_40,p0_.image_panorama_updated_atASimage_panorama_updated_at_41,p0_.image_portrait_nameASimage_portrait_name_42,p0_.image_portrait_updated_atASimage_portrait_updated_at_43,p0_.image_nameASimage_name_44,p0_.image_updated_atASimage_updated_at_45,p0_.image_altASimage_alt_46,p0_.image_name_brouillonASimage_name_brouillon_47,p0_.image_updated_at_brouillonASimage_updated_at_brouillon_48,p0_.total_caAStotal_ca_49,p0_.count_commandeAScount_commande_50,p0_.is_customizableASis_customizable_51,COALESCE(MIN(c1_.ordre),99999) ASsclr_52,p0_.parent_idASparent_id_53FROMproduitp0_LEFT JOINcategorie_produitc1_ONp0_.id=c1_.produit_idWHEREp0_.visible=?AND ((p0_.cadeauISNULLORp0_.cadeau=0)) AND ((p0_.declinaisonISNULLORp0_.declinaison=0)) AND (c1_.categorie_idIN (?)) GROUP BYp0_.idORDER BYsclr_52ASC,p0_.idDESC
SELECTp0_.createdAScreated_0,p0_.updatedASupdated_1,p0_.idASid_2,p0_.visibleASvisible_3,p0_.archiveASarchive_4,p0_.exclude_columbusASexclude_columbus_5,p0_.nouveauASnouveau_6,p0_.precommandeASprecommande_7,p0_.precommande_dateASprecommande_date_8,p0_.offre_specialeASoffre_speciale_9,p0_.cadeauAScadeau_10,p0_.goodieASgoodie_11,p0_.declinaisonASdeclinaison_12,p0_.declinaison_principaleASdeclinaison_principale_13,p0_.referenceASreference_14,p0_.titreAStitre_15,p0_.titre_brouillonAStitre_brouillon_16,p0_.contenuAScontenu_17,p0_.contenu_brouillonAScontenu_brouillon_18,p0_.contenu2AScontenu2_19,p0_.contenu2_brouillonAScontenu2_brouillon_20,p0_.slugASslug_21,p0_.prix_achat_htASprix_achat_ht_22,p0_.montantHTASmontantHT_23,p0_.montantTTCASmontantTTC_24,p0_.montantActuelTTCASmontantActuelTTC_25,p0_.tvaAStva_26,p0_.stockASstock_27,p0_.alerte_stockASalerte_stock_28,p0_.stock_emaplacementASstock_emaplacement_29,p0_.poidsASpoids_30,p0_.recherche_keywordASrecherche_keyword_31,p0_.recherche_slugASrecherche_slug_32,p0_.recherche_carac_attr_slugASrecherche_carac_attr_slug_33,p0_.produits_associesASproduits_associes_34,p0_.meta_titleASmeta_title_35,p0_.meta_keywordASmeta_keyword_36,p0_.meta_descriptionASmeta_description_37,p0_.note_avisASnote_avis_38,p0_.nb_avisASnb_avis_39,p0_.image_panorama_nameASimage_panorama_name_40,p0_.image_panorama_updated_atASimage_panorama_updated_at_41,p0_.image_portrait_nameASimage_portrait_name_42,p0_.image_portrait_updated_atASimage_portrait_updated_at_43,p0_.image_nameASimage_name_44,p0_.image_updated_atASimage_updated_at_45,p0_.image_altASimage_alt_46,p0_.image_name_brouillonASimage_name_brouillon_47,p0_.image_updated_at_brouillonASimage_updated_at_brouillon_48,p0_.total_caAStotal_ca_49,p0_.count_commandeAScount_commande_50,p0_.is_customizableASis_customizable_51,COALESCE(
MIN(c1_.ordre),99999
) ASsclr_52,p0_.parent_idASparent_id_53FROMproduitp0_LEFT JOINcategorie_produitc1_ONp0_.id=c1_.produit_idWHEREp0_.visible=?AND (
(
p0_.cadeauISNULLORp0_.cadeau=0
)
)
AND (
(
p0_.declinaisonISNULLORp0_.declinaison=0
)
)
AND (
c1_.categorie_idIN (?)
)
GROUP BYp0_.idORDER BYsclr_52ASC,p0_.idDESC
SELECTp0_.createdAScreated_0,p0_.updatedASupdated_1,p0_.idASid_2,p0_.visibleASvisible_3,p0_.archiveASarchive_4,p0_.exclude_columbusASexclude_columbus_5,p0_.nouveauASnouveau_6,p0_.precommandeASprecommande_7,p0_.precommande_dateASprecommande_date_8,p0_.offre_specialeASoffre_speciale_9,p0_.cadeauAScadeau_10,p0_.goodieASgoodie_11,p0_.declinaisonASdeclinaison_12,p0_.declinaison_principaleASdeclinaison_principale_13,p0_.referenceASreference_14,p0_.titreAStitre_15,p0_.titre_brouillonAStitre_brouillon_16,p0_.contenuAScontenu_17,p0_.contenu_brouillonAScontenu_brouillon_18,p0_.contenu2AScontenu2_19,p0_.contenu2_brouillonAScontenu2_brouillon_20,p0_.slugASslug_21,p0_.prix_achat_htASprix_achat_ht_22,p0_.montantHTASmontantHT_23,p0_.montantTTCASmontantTTC_24,p0_.montantActuelTTCASmontantActuelTTC_25,p0_.tvaAStva_26,p0_.stockASstock_27,p0_.alerte_stockASalerte_stock_28,p0_.stock_emaplacementASstock_emaplacement_29,p0_.poidsASpoids_30,p0_.recherche_keywordASrecherche_keyword_31,p0_.recherche_slugASrecherche_slug_32,p0_.recherche_carac_attr_slugASrecherche_carac_attr_slug_33,p0_.produits_associesASproduits_associes_34,p0_.meta_titleASmeta_title_35,p0_.meta_keywordASmeta_keyword_36,p0_.meta_descriptionASmeta_description_37,p0_.note_avisASnote_avis_38,p0_.nb_avisASnb_avis_39,p0_.image_panorama_nameASimage_panorama_name_40,p0_.image_panorama_updated_atASimage_panorama_updated_at_41,p0_.image_portrait_nameASimage_portrait_name_42,p0_.image_portrait_updated_atASimage_portrait_updated_at_43,p0_.image_nameASimage_name_44,p0_.image_updated_atASimage_updated_at_45,p0_.image_altASimage_alt_46,p0_.image_name_brouillonASimage_name_brouillon_47,p0_.image_updated_at_brouillonASimage_updated_at_brouillon_48,p0_.total_caAStotal_ca_49,p0_.count_commandeAScount_commande_50,p0_.is_customizableASis_customizable_51,COALESCE(MIN(c1_.ordre),99999) ASsclr_52,p0_.parent_idASparent_id_53FROMproduitp0_LEFT JOINcategorie_produitc1_ONp0_.id=c1_.produit_idWHEREp0_.visible=1AND ((p0_.cadeauISNULLORp0_.cadeau=0)) AND ((p0_.declinaisonISNULLORp0_.declinaison=0)) AND (c1_.categorie_idIN (114)) GROUP BYp0_.idORDER BYsclr_52ASC,p0_.idDESC;
SELECTCOUNT(*) ASdctrn_countFROM (SELECTp0_.createdAScreated_0,p0_.updatedASupdated_1,p0_.idASid_2,p0_.visibleASvisible_3,p0_.archiveASarchive_4,p0_.exclude_columbusASexclude_columbus_5,p0_.nouveauASnouveau_6,p0_.precommandeASprecommande_7,p0_.precommande_dateASprecommande_date_8,p0_.offre_specialeASoffre_speciale_9,p0_.cadeauAScadeau_10,p0_.goodieASgoodie_11,p0_.declinaisonASdeclinaison_12,p0_.declinaison_principaleASdeclinaison_principale_13,p0_.referenceASreference_14,p0_.titreAStitre_15,p0_.titre_brouillonAStitre_brouillon_16,p0_.contenuAScontenu_17,p0_.contenu_brouillonAScontenu_brouillon_18,p0_.contenu2AScontenu2_19,p0_.contenu2_brouillonAScontenu2_brouillon_20,p0_.slugASslug_21,p0_.prix_achat_htASprix_achat_ht_22,p0_.montantHTASmontantHT_23,p0_.montantTTCASmontantTTC_24,p0_.montantActuelTTCASmontantActuelTTC_25,p0_.tvaAStva_26,p0_.stockASstock_27,p0_.alerte_stockASalerte_stock_28,p0_.stock_emaplacementASstock_emaplacement_29,p0_.poidsASpoids_30,p0_.recherche_keywordASrecherche_keyword_31,p0_.recherche_slugASrecherche_slug_32,p0_.recherche_carac_attr_slugASrecherche_carac_attr_slug_33,p0_.produits_associesASproduits_associes_34,p0_.meta_titleASmeta_title_35,p0_.meta_keywordASmeta_keyword_36,p0_.meta_descriptionASmeta_description_37,p0_.note_avisASnote_avis_38,p0_.nb_avisASnb_avis_39,p0_.image_panorama_nameASimage_panorama_name_40,p0_.image_panorama_updated_atASimage_panorama_updated_at_41,p0_.image_portrait_nameASimage_portrait_name_42,p0_.image_portrait_updated_atASimage_portrait_updated_at_43,p0_.image_nameASimage_name_44,p0_.image_updated_atASimage_updated_at_45,p0_.image_altASimage_alt_46,p0_.image_name_brouillonASimage_name_brouillon_47,p0_.image_updated_at_brouillonASimage_updated_at_brouillon_48,p0_.total_caAStotal_ca_49,p0_.count_commandeAScount_commande_50,p0_.is_customizableASis_customizable_51,COALESCE(MIN(c1_.ordre),99999) ASsclr_52FROMproduitp0_LEFT JOINcategorie_produitc1_ONp0_.id=c1_.produit_idWHEREp0_.visible=?AND ((p0_.cadeauISNULLORp0_.cadeau=0)) AND ((p0_.declinaisonISNULLORp0_.declinaison=0)) AND (c1_.categorie_idIN (?)) GROUP BYp0_.idORDER BYsclr_52ASC,p0_.idDESC) dctrn_table
SELECTCOUNT(*) ASdctrn_countFROM
(
SELECTp0_.createdAScreated_0,p0_.updatedASupdated_1,p0_.idASid_2,p0_.visibleASvisible_3,p0_.archiveASarchive_4,p0_.exclude_columbusASexclude_columbus_5,p0_.nouveauASnouveau_6,p0_.precommandeASprecommande_7,p0_.precommande_dateASprecommande_date_8,p0_.offre_specialeASoffre_speciale_9,p0_.cadeauAScadeau_10,p0_.goodieASgoodie_11,p0_.declinaisonASdeclinaison_12,p0_.declinaison_principaleASdeclinaison_principale_13,p0_.referenceASreference_14,p0_.titreAStitre_15,p0_.titre_brouillonAStitre_brouillon_16,p0_.contenuAScontenu_17,p0_.contenu_brouillonAScontenu_brouillon_18,p0_.contenu2AScontenu2_19,p0_.contenu2_brouillonAScontenu2_brouillon_20,p0_.slugASslug_21,p0_.prix_achat_htASprix_achat_ht_22,p0_.montantHTASmontantHT_23,p0_.montantTTCASmontantTTC_24,p0_.montantActuelTTCASmontantActuelTTC_25,p0_.tvaAStva_26,p0_.stockASstock_27,p0_.alerte_stockASalerte_stock_28,p0_.stock_emaplacementASstock_emaplacement_29,p0_.poidsASpoids_30,p0_.recherche_keywordASrecherche_keyword_31,p0_.recherche_slugASrecherche_slug_32,p0_.recherche_carac_attr_slugASrecherche_carac_attr_slug_33,p0_.produits_associesASproduits_associes_34,p0_.meta_titleASmeta_title_35,p0_.meta_keywordASmeta_keyword_36,p0_.meta_descriptionASmeta_description_37,p0_.note_avisASnote_avis_38,p0_.nb_avisASnb_avis_39,p0_.image_panorama_nameASimage_panorama_name_40,p0_.image_panorama_updated_atASimage_panorama_updated_at_41,p0_.image_portrait_nameASimage_portrait_name_42,p0_.image_portrait_updated_atASimage_portrait_updated_at_43,p0_.image_nameASimage_name_44,p0_.image_updated_atASimage_updated_at_45,p0_.image_altASimage_alt_46,p0_.image_name_brouillonASimage_name_brouillon_47,p0_.image_updated_at_brouillonASimage_updated_at_brouillon_48,p0_.total_caAStotal_ca_49,p0_.count_commandeAScount_commande_50,p0_.is_customizableASis_customizable_51,COALESCE(
MIN(c1_.ordre),99999
) ASsclr_52FROMproduitp0_LEFT JOINcategorie_produitc1_ONp0_.id=c1_.produit_idWHEREp0_.visible=?AND (
(
p0_.cadeauISNULLORp0_.cadeau=0
)
)
AND (
(
p0_.declinaisonISNULLORp0_.declinaison=0
)
)
AND (
c1_.categorie_idIN (?)
)
GROUP BYp0_.idORDER BYsclr_52ASC,p0_.idDESC
) dctrn_table
SELECTCOUNT(*) ASdctrn_countFROM (SELECTp0_.createdAScreated_0,p0_.updatedASupdated_1,p0_.idASid_2,p0_.visibleASvisible_3,p0_.archiveASarchive_4,p0_.exclude_columbusASexclude_columbus_5,p0_.nouveauASnouveau_6,p0_.precommandeASprecommande_7,p0_.precommande_dateASprecommande_date_8,p0_.offre_specialeASoffre_speciale_9,p0_.cadeauAScadeau_10,p0_.goodieASgoodie_11,p0_.declinaisonASdeclinaison_12,p0_.declinaison_principaleASdeclinaison_principale_13,p0_.referenceASreference_14,p0_.titreAStitre_15,p0_.titre_brouillonAStitre_brouillon_16,p0_.contenuAScontenu_17,p0_.contenu_brouillonAScontenu_brouillon_18,p0_.contenu2AScontenu2_19,p0_.contenu2_brouillonAScontenu2_brouillon_20,p0_.slugASslug_21,p0_.prix_achat_htASprix_achat_ht_22,p0_.montantHTASmontantHT_23,p0_.montantTTCASmontantTTC_24,p0_.montantActuelTTCASmontantActuelTTC_25,p0_.tvaAStva_26,p0_.stockASstock_27,p0_.alerte_stockASalerte_stock_28,p0_.stock_emaplacementASstock_emaplacement_29,p0_.poidsASpoids_30,p0_.recherche_keywordASrecherche_keyword_31,p0_.recherche_slugASrecherche_slug_32,p0_.recherche_carac_attr_slugASrecherche_carac_attr_slug_33,p0_.produits_associesASproduits_associes_34,p0_.meta_titleASmeta_title_35,p0_.meta_keywordASmeta_keyword_36,p0_.meta_descriptionASmeta_description_37,p0_.note_avisASnote_avis_38,p0_.nb_avisASnb_avis_39,p0_.image_panorama_nameASimage_panorama_name_40,p0_.image_panorama_updated_atASimage_panorama_updated_at_41,p0_.image_portrait_nameASimage_portrait_name_42,p0_.image_portrait_updated_atASimage_portrait_updated_at_43,p0_.image_nameASimage_name_44,p0_.image_updated_atASimage_updated_at_45,p0_.image_altASimage_alt_46,p0_.image_name_brouillonASimage_name_brouillon_47,p0_.image_updated_at_brouillonASimage_updated_at_brouillon_48,p0_.total_caAStotal_ca_49,p0_.count_commandeAScount_commande_50,p0_.is_customizableASis_customizable_51,COALESCE(MIN(c1_.ordre),99999) ASsclr_52FROMproduitp0_LEFT JOINcategorie_produitc1_ONp0_.id=c1_.produit_idWHEREp0_.visible=1AND ((p0_.cadeauISNULLORp0_.cadeau=0)) AND ((p0_.declinaisonISNULLORp0_.declinaison=0)) AND (c1_.categorie_idIN (114)) GROUP BYp0_.idORDER BYsclr_52ASC,p0_.idDESC) dctrn_table;
SELECTp0_.createdAScreated_0,p0_.updatedASupdated_1,p0_.idASid_2,p0_.visibleASvisible_3,p0_.archiveASarchive_4,p0_.exclude_columbusASexclude_columbus_5,p0_.nouveauASnouveau_6,p0_.precommandeASprecommande_7,p0_.precommande_dateASprecommande_date_8,p0_.offre_specialeASoffre_speciale_9,p0_.cadeauAScadeau_10,p0_.goodieASgoodie_11,p0_.declinaisonASdeclinaison_12,p0_.declinaison_principaleASdeclinaison_principale_13,p0_.referenceASreference_14,p0_.titreAStitre_15,p0_.titre_brouillonAStitre_brouillon_16,p0_.contenuAScontenu_17,p0_.contenu_brouillonAScontenu_brouillon_18,p0_.contenu2AScontenu2_19,p0_.contenu2_brouillonAScontenu2_brouillon_20,p0_.slugASslug_21,p0_.prix_achat_htASprix_achat_ht_22,p0_.montantHTASmontantHT_23,p0_.montantTTCASmontantTTC_24,p0_.montantActuelTTCASmontantActuelTTC_25,p0_.tvaAStva_26,p0_.stockASstock_27,p0_.alerte_stockASalerte_stock_28,p0_.stock_emaplacementASstock_emaplacement_29,p0_.poidsASpoids_30,p0_.recherche_keywordASrecherche_keyword_31,p0_.recherche_slugASrecherche_slug_32,p0_.recherche_carac_attr_slugASrecherche_carac_attr_slug_33,p0_.produits_associesASproduits_associes_34,p0_.meta_titleASmeta_title_35,p0_.meta_keywordASmeta_keyword_36,p0_.meta_descriptionASmeta_description_37,p0_.note_avisASnote_avis_38,p0_.nb_avisASnb_avis_39,p0_.image_panorama_nameASimage_panorama_name_40,p0_.image_panorama_updated_atASimage_panorama_updated_at_41,p0_.image_portrait_nameASimage_portrait_name_42,p0_.image_portrait_updated_atASimage_portrait_updated_at_43,p0_.image_nameASimage_name_44,p0_.image_updated_atASimage_updated_at_45,p0_.image_altASimage_alt_46,p0_.image_name_brouillonASimage_name_brouillon_47,p0_.image_updated_at_brouillonASimage_updated_at_brouillon_48,p0_.total_caAStotal_ca_49,p0_.count_commandeAScount_commande_50,p0_.is_customizableASis_customizable_51,COALESCE(MIN(c1_.ordre),99999) ASsclr_52,p0_.parent_idASparent_id_53FROMproduitp0_LEFT JOINcategorie_produitc1_ONp0_.id=c1_.produit_idWHEREp0_.visible=?AND ((p0_.cadeauISNULLORp0_.cadeau=0)) AND ((p0_.declinaisonISNULLORp0_.declinaison=0)) AND (c1_.categorie_idIN (?)) ANDp0_.idIN (?,?,?,?,?,?,?,?,?,?) GROUP BYp0_.idORDER BYsclr_52ASC,p0_.idDESC
SELECTp0_.createdAScreated_0,p0_.updatedASupdated_1,p0_.idASid_2,p0_.visibleASvisible_3,p0_.archiveASarchive_4,p0_.exclude_columbusASexclude_columbus_5,p0_.nouveauASnouveau_6,p0_.precommandeASprecommande_7,p0_.precommande_dateASprecommande_date_8,p0_.offre_specialeASoffre_speciale_9,p0_.cadeauAScadeau_10,p0_.goodieASgoodie_11,p0_.declinaisonASdeclinaison_12,p0_.declinaison_principaleASdeclinaison_principale_13,p0_.referenceASreference_14,p0_.titreAStitre_15,p0_.titre_brouillonAStitre_brouillon_16,p0_.contenuAScontenu_17,p0_.contenu_brouillonAScontenu_brouillon_18,p0_.contenu2AScontenu2_19,p0_.contenu2_brouillonAScontenu2_brouillon_20,p0_.slugASslug_21,p0_.prix_achat_htASprix_achat_ht_22,p0_.montantHTASmontantHT_23,p0_.montantTTCASmontantTTC_24,p0_.montantActuelTTCASmontantActuelTTC_25,p0_.tvaAStva_26,p0_.stockASstock_27,p0_.alerte_stockASalerte_stock_28,p0_.stock_emaplacementASstock_emaplacement_29,p0_.poidsASpoids_30,p0_.recherche_keywordASrecherche_keyword_31,p0_.recherche_slugASrecherche_slug_32,p0_.recherche_carac_attr_slugASrecherche_carac_attr_slug_33,p0_.produits_associesASproduits_associes_34,p0_.meta_titleASmeta_title_35,p0_.meta_keywordASmeta_keyword_36,p0_.meta_descriptionASmeta_description_37,p0_.note_avisASnote_avis_38,p0_.nb_avisASnb_avis_39,p0_.image_panorama_nameASimage_panorama_name_40,p0_.image_panorama_updated_atASimage_panorama_updated_at_41,p0_.image_portrait_nameASimage_portrait_name_42,p0_.image_portrait_updated_atASimage_portrait_updated_at_43,p0_.image_nameASimage_name_44,p0_.image_updated_atASimage_updated_at_45,p0_.image_altASimage_alt_46,p0_.image_name_brouillonASimage_name_brouillon_47,p0_.image_updated_at_brouillonASimage_updated_at_brouillon_48,p0_.total_caAStotal_ca_49,p0_.count_commandeAScount_commande_50,p0_.is_customizableASis_customizable_51,COALESCE(
MIN(c1_.ordre),99999
) ASsclr_52,p0_.parent_idASparent_id_53FROMproduitp0_LEFT JOINcategorie_produitc1_ONp0_.id=c1_.produit_idWHEREp0_.visible=?AND (
(
p0_.cadeauISNULLORp0_.cadeau=0
)
)
AND (
(
p0_.declinaisonISNULLORp0_.declinaison=0
)
)
AND (
c1_.categorie_idIN (?)
)
ANDp0_.idIN (?,?,?,?,?,?,?,?,?,?)
GROUP BYp0_.idORDER BYsclr_52ASC,p0_.idDESC
SELECTp0_.createdAScreated_0,p0_.updatedASupdated_1,p0_.idASid_2,p0_.visibleASvisible_3,p0_.archiveASarchive_4,p0_.exclude_columbusASexclude_columbus_5,p0_.nouveauASnouveau_6,p0_.precommandeASprecommande_7,p0_.precommande_dateASprecommande_date_8,p0_.offre_specialeASoffre_speciale_9,p0_.cadeauAScadeau_10,p0_.goodieASgoodie_11,p0_.declinaisonASdeclinaison_12,p0_.declinaison_principaleASdeclinaison_principale_13,p0_.referenceASreference_14,p0_.titreAStitre_15,p0_.titre_brouillonAStitre_brouillon_16,p0_.contenuAScontenu_17,p0_.contenu_brouillonAScontenu_brouillon_18,p0_.contenu2AScontenu2_19,p0_.contenu2_brouillonAScontenu2_brouillon_20,p0_.slugASslug_21,p0_.prix_achat_htASprix_achat_ht_22,p0_.montantHTASmontantHT_23,p0_.montantTTCASmontantTTC_24,p0_.montantActuelTTCASmontantActuelTTC_25,p0_.tvaAStva_26,p0_.stockASstock_27,p0_.alerte_stockASalerte_stock_28,p0_.stock_emaplacementASstock_emaplacement_29,p0_.poidsASpoids_30,p0_.recherche_keywordASrecherche_keyword_31,p0_.recherche_slugASrecherche_slug_32,p0_.recherche_carac_attr_slugASrecherche_carac_attr_slug_33,p0_.produits_associesASproduits_associes_34,p0_.meta_titleASmeta_title_35,p0_.meta_keywordASmeta_keyword_36,p0_.meta_descriptionASmeta_description_37,p0_.note_avisASnote_avis_38,p0_.nb_avisASnb_avis_39,p0_.image_panorama_nameASimage_panorama_name_40,p0_.image_panorama_updated_atASimage_panorama_updated_at_41,p0_.image_portrait_nameASimage_portrait_name_42,p0_.image_portrait_updated_atASimage_portrait_updated_at_43,p0_.image_nameASimage_name_44,p0_.image_updated_atASimage_updated_at_45,p0_.image_altASimage_alt_46,p0_.image_name_brouillonASimage_name_brouillon_47,p0_.image_updated_at_brouillonASimage_updated_at_brouillon_48,p0_.total_caAStotal_ca_49,p0_.count_commandeAScount_commande_50,p0_.is_customizableASis_customizable_51,COALESCE(MIN(c1_.ordre),99999) ASsclr_52,p0_.parent_idASparent_id_53FROMproduitp0_LEFT JOINcategorie_produitc1_ONp0_.id=c1_.produit_idWHEREp0_.visible=1AND ((p0_.cadeauISNULLORp0_.cadeau=0)) AND ((p0_.declinaisonISNULLORp0_.declinaison=0)) AND (c1_.categorie_idIN (114)) ANDp0_.idIN (101,100,585,584,586,587,595,596,594,56) GROUP BYp0_.idORDER BYsclr_52ASC,p0_.idDESC;