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:24:04'ORp0_.date_finISNULL)) AND ((p0_.date_debut<='2026-09-24 16:24:04'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 (126)) 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 (126)) 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 (126)) ANDp0_.idIN (718,717,681,682,683,684,678,677,675,672) GROUP BYp0_.idORDER BYsclr_52ASC,p0_.idDESC;
SELECTDISTINCTp0_.idASid_0,p0_.visibleASvisible_1,p0_.pageASpage_2,p0_.createdAScreated_3,p0_.updatedASupdated_4,p0_.date_debutASdate_debut_5,p0_.date_finASdate_fin_6,p0_.titreAStitre_7,p0_.slugASslug_8,p0_.contenuAScontenu_9,p0_.image_nameASimage_name_10,p0_.image_updated_atASimage_updated_at_11,p0_.typageAStypage_12,p0_.montantASmontant_13,p0_.montant_minASmontant_min_14,p0_.customer_order_count_minAScustomer_order_count_min_15,p0_.customer_order_count_maxAScustomer_order_count_max_16,p0_.customer_lifetime_spent_minAScustomer_lifetime_spent_min_17,p0_.customer_lifetime_spent_maxAScustomer_lifetime_spent_max_18,p0_.customer_account_age_days_minAScustomer_account_age_days_min_19,p0_.customer_account_age_days_maxAScustomer_account_age_days_max_20,p0_.y_offertASy_offert_21,p0_.meta_titleASmeta_title_22,p0_.meta_keywordASmeta_keyword_23,p0_.meta_descriptionASmeta_description_24,p0_.produit_offert_idASproduit_offert_id_25FROMpromotionp0_LEFT JOINpromotion_produitp2_ONp0_.id=p2_.promotion_idLEFT JOINproduitp1_ONp1_.id=p2_.produit_idLEFT JOINpromotion_categoriep4_ONp0_.id=p4_.promotion_idLEFT JOINcategoriec3_ONc3_.id=p4_.categorie_idWHEREp0_.visible=?AND ((p0_.date_fin>=?ORp0_.date_finISNULL)) AND ((p0_.date_debut<=?ORp0_.date_debutISNULL)) AND ((p0_.date_fin>=?ORp0_.date_finISNULL)) AND ((p0_.date_debut<=?ORp0_.date_debutISNULL)) AND (((p1_.id=?) OR (c3_.idIN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) ANDc3_.idISNOTNULL))) AND ((p0_.montant_minISNULLORp0_.montant_min<=?)) AND (NOT (EXISTS (SELECT1ASsclr_26FROMpromotionp5_INNER JOINpromotion_produit_excludep7_ONp5_.id=p7_.promotion_idINNER JOINproduitp6_ONp6_.id=p7_.produit_idWHEREp5_.id=p0_.idAND ((p6_.id=?ORp6_.id=?))))) AND (NOT (EXISTS (SELECT1ASsclr_27FROMpromotionp8_INNER JOINpromotion_categorie_excludep10_ONp8_.id=p10_.promotion_idINNER JOINcategoriec9_ONc9_.id=p10_.categorie_idINNER JOINcategorie_produitc11_ON (c11_.categorie_id=c9_.idAND (c11_.produit_id=?ORc11_.produit_id=?)) WHEREp8_.id=p0_.id))) ORDER BYp0_.createdDESC
SELECTDISTINCTp0_.idASid_0,p0_.visibleASvisible_1,p0_.pageASpage_2,p0_.createdAScreated_3,p0_.updatedASupdated_4,p0_.date_debutASdate_debut_5,p0_.date_finASdate_fin_6,p0_.titreAStitre_7,p0_.slugASslug_8,p0_.contenuAScontenu_9,p0_.image_nameASimage_name_10,p0_.image_updated_atASimage_updated_at_11,p0_.typageAStypage_12,p0_.montantASmontant_13,p0_.montant_minASmontant_min_14,p0_.customer_order_count_minAScustomer_order_count_min_15,p0_.customer_order_count_maxAScustomer_order_count_max_16,p0_.customer_lifetime_spent_minAScustomer_lifetime_spent_min_17,p0_.customer_lifetime_spent_maxAScustomer_lifetime_spent_max_18,p0_.customer_account_age_days_minAScustomer_account_age_days_min_19,p0_.customer_account_age_days_maxAScustomer_account_age_days_max_20,p0_.y_offertASy_offert_21,p0_.meta_titleASmeta_title_22,p0_.meta_keywordASmeta_keyword_23,p0_.meta_descriptionASmeta_description_24,p0_.produit_offert_idASproduit_offert_id_25FROMpromotionp0_LEFT JOINpromotion_produitp2_ONp0_.id=p2_.promotion_idLEFT JOINproduitp1_ONp1_.id=p2_.produit_idLEFT JOINpromotion_categoriep4_ONp0_.id=p4_.promotion_idLEFT JOINcategoriec3_ONc3_.id=p4_.categorie_idWHEREp0_.visible=?AND (
(
p0_.date_fin>=?ORp0_.date_finISNULL
)
)
AND (
(
p0_.date_debut<=?ORp0_.date_debutISNULL
)
)
AND (
(
p0_.date_fin>=?ORp0_.date_finISNULL
)
)
AND (
(
p0_.date_debut<=?ORp0_.date_debutISNULL
)
)
AND (
(
(p1_.id=?)
OR (
c3_.idIN (
?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?
)
ANDc3_.idISNOTNULL
)
)
)
AND (
(
p0_.montant_minISNULLORp0_.montant_min<=?
)
)
AND (
NOT (
EXISTS (
SELECT1ASsclr_26FROMpromotionp5_INNER JOINpromotion_produit_excludep7_ONp5_.id=p7_.promotion_idINNER JOINproduitp6_ONp6_.id=p7_.produit_idWHEREp5_.id=p0_.idAND (
(
p6_.id=?ORp6_.id=?
)
)
)
)
)
AND (
NOT (
EXISTS (
SELECT1ASsclr_27FROMpromotionp8_INNER JOINpromotion_categorie_excludep10_ONp8_.id=p10_.promotion_idINNER JOINcategoriec9_ONc9_.id=p10_.categorie_idINNER JOINcategorie_produitc11_ON (
c11_.categorie_id=c9_.idAND (
c11_.produit_id=?ORc11_.produit_id=?
)
)
WHEREp8_.id=p0_.id
)
)
)
ORDER BYp0_.createdDESC
SELECTDISTINCTp0_.idASid_0,p0_.visibleASvisible_1,p0_.pageASpage_2,p0_.createdAScreated_3,p0_.updatedASupdated_4,p0_.date_debutASdate_debut_5,p0_.date_finASdate_fin_6,p0_.titreAStitre_7,p0_.slugASslug_8,p0_.contenuAScontenu_9,p0_.image_nameASimage_name_10,p0_.image_updated_atASimage_updated_at_11,p0_.typageAStypage_12,p0_.montantASmontant_13,p0_.montant_minASmontant_min_14,p0_.customer_order_count_minAScustomer_order_count_min_15,p0_.customer_order_count_maxAScustomer_order_count_max_16,p0_.customer_lifetime_spent_minAScustomer_lifetime_spent_min_17,p0_.customer_lifetime_spent_maxAScustomer_lifetime_spent_max_18,p0_.customer_account_age_days_minAScustomer_account_age_days_min_19,p0_.customer_account_age_days_maxAScustomer_account_age_days_max_20,p0_.y_offertASy_offert_21,p0_.meta_titleASmeta_title_22,p0_.meta_keywordASmeta_keyword_23,p0_.meta_descriptionASmeta_description_24,p0_.produit_offert_idASproduit_offert_id_25FROMpromotionp0_LEFT JOINpromotion_produitp2_ONp0_.id=p2_.promotion_idLEFT JOINproduitp1_ONp1_.id=p2_.produit_idLEFT JOINpromotion_categoriep4_ONp0_.id=p4_.promotion_idLEFT JOINcategoriec3_ONc3_.id=p4_.categorie_idWHEREp0_.visible=1AND ((p0_.date_fin>='2026-09-24 16:24:04'ORp0_.date_finISNULL)) AND ((p0_.date_debut<='2026-09-24 16:24:04'ORp0_.date_debutISNULL)) AND ((p0_.date_fin>='2026-09-24 16:24:04'ORp0_.date_finISNULL)) AND ((p0_.date_debut<='2026-09-24 16:24:04'ORp0_.date_debutISNULL)) AND (((p1_.id=13) OR (c3_.idIN (226,216,215,218,219,220,229,217,26,132,164,37,4,162,19,5,163) ANDc3_.idISNOTNULL))) AND ((p0_.montant_minISNULLORp0_.montant_min<=0)) AND (NOT (EXISTS (SELECT1ASsclr_26FROMpromotionp5_INNER JOINpromotion_produit_excludep7_ONp5_.id=p7_.promotion_idINNER JOINproduitp6_ONp6_.id=p7_.produit_idWHEREp5_.id=p0_.idAND ((p6_.id=13ORp6_.id=13))))) AND (NOT (EXISTS (SELECT1ASsclr_27FROMpromotionp8_INNER JOINpromotion_categorie_excludep10_ONp8_.id=p10_.promotion_idINNER JOINcategoriec9_ONc9_.id=p10_.categorie_idINNER JOINcategorie_produitc11_ON (c11_.categorie_id=c9_.idAND (c11_.produit_id=13ORc11_.produit_id=13)) WHEREp8_.id=p0_.id))) ORDER BYp0_.createdDESC;
SELECTDISTINCTp0_.idASid_0,p0_.visibleASvisible_1,p0_.pageASpage_2,p0_.createdAScreated_3,p0_.updatedASupdated_4,p0_.date_debutASdate_debut_5,p0_.date_finASdate_fin_6,p0_.titreAStitre_7,p0_.slugASslug_8,p0_.contenuAScontenu_9,p0_.image_nameASimage_name_10,p0_.image_updated_atASimage_updated_at_11,p0_.typageAStypage_12,p0_.montantASmontant_13,p0_.montant_minASmontant_min_14,p0_.customer_order_count_minAScustomer_order_count_min_15,p0_.customer_order_count_maxAScustomer_order_count_max_16,p0_.customer_lifetime_spent_minAScustomer_lifetime_spent_min_17,p0_.customer_lifetime_spent_maxAScustomer_lifetime_spent_max_18,p0_.customer_account_age_days_minAScustomer_account_age_days_min_19,p0_.customer_account_age_days_maxAScustomer_account_age_days_max_20,p0_.y_offertASy_offert_21,p0_.meta_titleASmeta_title_22,p0_.meta_keywordASmeta_keyword_23,p0_.meta_descriptionASmeta_description_24,p0_.produit_offert_idASproduit_offert_id_25FROMpromotionp0_LEFT JOINpromotion_produitp2_ONp0_.id=p2_.promotion_idLEFT JOINproduitp1_ONp1_.id=p2_.produit_idLEFT JOINpromotion_categoriep4_ONp0_.id=p4_.promotion_idLEFT JOINcategoriec3_ONc3_.id=p4_.categorie_idWHEREp0_.visible=?AND ((p0_.date_fin>=?ORp0_.date_finISNULL)) AND ((p0_.date_debut<=?ORp0_.date_debutISNULL)) AND ((p0_.date_fin>=?ORp0_.date_finISNULL)) AND ((p0_.date_debut<=?ORp0_.date_debutISNULL)) AND (((p1_.id=?) OR (c3_.idIN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) ANDc3_.idISNOTNULL))) AND ((p0_.montant_minISNULLORp0_.montant_min<=?)) AND (NOT (EXISTS (SELECT1ASsclr_26FROMpromotionp5_INNER JOINpromotion_produit_excludep7_ONp5_.id=p7_.promotion_idINNER JOINproduitp6_ONp6_.id=p7_.produit_idWHEREp5_.id=p0_.idAND ((p6_.id=?ORp6_.id=?))))) AND (NOT (EXISTS (SELECT1ASsclr_27FROMpromotionp8_INNER JOINpromotion_categorie_excludep10_ONp8_.id=p10_.promotion_idINNER JOINcategoriec9_ONc9_.id=p10_.categorie_idINNER JOINcategorie_produitc11_ON (c11_.categorie_id=c9_.idAND (c11_.produit_id=?ORc11_.produit_id=?)) WHEREp8_.id=p0_.id))) ORDER BYp0_.createdDESC
SELECTDISTINCTp0_.idASid_0,p0_.visibleASvisible_1,p0_.pageASpage_2,p0_.createdAScreated_3,p0_.updatedASupdated_4,p0_.date_debutASdate_debut_5,p0_.date_finASdate_fin_6,p0_.titreAStitre_7,p0_.slugASslug_8,p0_.contenuAScontenu_9,p0_.image_nameASimage_name_10,p0_.image_updated_atASimage_updated_at_11,p0_.typageAStypage_12,p0_.montantASmontant_13,p0_.montant_minASmontant_min_14,p0_.customer_order_count_minAScustomer_order_count_min_15,p0_.customer_order_count_maxAScustomer_order_count_max_16,p0_.customer_lifetime_spent_minAScustomer_lifetime_spent_min_17,p0_.customer_lifetime_spent_maxAScustomer_lifetime_spent_max_18,p0_.customer_account_age_days_minAScustomer_account_age_days_min_19,p0_.customer_account_age_days_maxAScustomer_account_age_days_max_20,p0_.y_offertASy_offert_21,p0_.meta_titleASmeta_title_22,p0_.meta_keywordASmeta_keyword_23,p0_.meta_descriptionASmeta_description_24,p0_.produit_offert_idASproduit_offert_id_25FROMpromotionp0_LEFT JOINpromotion_produitp2_ONp0_.id=p2_.promotion_idLEFT JOINproduitp1_ONp1_.id=p2_.produit_idLEFT JOINpromotion_categoriep4_ONp0_.id=p4_.promotion_idLEFT JOINcategoriec3_ONc3_.id=p4_.categorie_idWHEREp0_.visible=?AND (
(
p0_.date_fin>=?ORp0_.date_finISNULL
)
)
AND (
(
p0_.date_debut<=?ORp0_.date_debutISNULL
)
)
AND (
(
p0_.date_fin>=?ORp0_.date_finISNULL
)
)
AND (
(
p0_.date_debut<=?ORp0_.date_debutISNULL
)
)
AND (
(
(p1_.id=?)
OR (
c3_.idIN (
?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?
)
ANDc3_.idISNOTNULL
)
)
)
AND (
(
p0_.montant_minISNULLORp0_.montant_min<=?
)
)
AND (
NOT (
EXISTS (
SELECT1ASsclr_26FROMpromotionp5_INNER JOINpromotion_produit_excludep7_ONp5_.id=p7_.promotion_idINNER JOINproduitp6_ONp6_.id=p7_.produit_idWHEREp5_.id=p0_.idAND (
(
p6_.id=?ORp6_.id=?
)
)
)
)
)
AND (
NOT (
EXISTS (
SELECT1ASsclr_27FROMpromotionp8_INNER JOINpromotion_categorie_excludep10_ONp8_.id=p10_.promotion_idINNER JOINcategoriec9_ONc9_.id=p10_.categorie_idINNER JOINcategorie_produitc11_ON (
c11_.categorie_id=c9_.idAND (
c11_.produit_id=?ORc11_.produit_id=?
)
)
WHEREp8_.id=p0_.id
)
)
)
ORDER BYp0_.createdDESC
SELECTDISTINCTp0_.idASid_0,p0_.visibleASvisible_1,p0_.pageASpage_2,p0_.createdAScreated_3,p0_.updatedASupdated_4,p0_.date_debutASdate_debut_5,p0_.date_finASdate_fin_6,p0_.titreAStitre_7,p0_.slugASslug_8,p0_.contenuAScontenu_9,p0_.image_nameASimage_name_10,p0_.image_updated_atASimage_updated_at_11,p0_.typageAStypage_12,p0_.montantASmontant_13,p0_.montant_minASmontant_min_14,p0_.customer_order_count_minAScustomer_order_count_min_15,p0_.customer_order_count_maxAScustomer_order_count_max_16,p0_.customer_lifetime_spent_minAScustomer_lifetime_spent_min_17,p0_.customer_lifetime_spent_maxAScustomer_lifetime_spent_max_18,p0_.customer_account_age_days_minAScustomer_account_age_days_min_19,p0_.customer_account_age_days_maxAScustomer_account_age_days_max_20,p0_.y_offertASy_offert_21,p0_.meta_titleASmeta_title_22,p0_.meta_keywordASmeta_keyword_23,p0_.meta_descriptionASmeta_description_24,p0_.produit_offert_idASproduit_offert_id_25FROMpromotionp0_LEFT JOINpromotion_produitp2_ONp0_.id=p2_.promotion_idLEFT JOINproduitp1_ONp1_.id=p2_.produit_idLEFT JOINpromotion_categoriep4_ONp0_.id=p4_.promotion_idLEFT JOINcategoriec3_ONc3_.id=p4_.categorie_idWHEREp0_.visible=1AND ((p0_.date_fin>='2026-09-24 16:24:04'ORp0_.date_finISNULL)) AND ((p0_.date_debut<='2026-09-24 16:24:04'ORp0_.date_debutISNULL)) AND ((p0_.date_fin>='2026-09-24 16:24:04'ORp0_.date_finISNULL)) AND ((p0_.date_debut<='2026-09-24 16:24:04'ORp0_.date_debutISNULL)) AND (((p1_.id=30) OR (c3_.idIN (64,226,215,216,217,218,219,220,229,181,185,26,190,175,174,46,37,19,4,5,59) ANDc3_.idISNOTNULL))) AND ((p0_.montant_minISNULLORp0_.montant_min<=0)) AND (NOT (EXISTS (SELECT1ASsclr_26FROMpromotionp5_INNER JOINpromotion_produit_excludep7_ONp5_.id=p7_.promotion_idINNER JOINproduitp6_ONp6_.id=p7_.produit_idWHEREp5_.id=p0_.idAND ((p6_.id=30ORp6_.id=30))))) AND (NOT (EXISTS (SELECT1ASsclr_27FROMpromotionp8_INNER JOINpromotion_categorie_excludep10_ONp8_.id=p10_.promotion_idINNER JOINcategoriec9_ONc9_.id=p10_.categorie_idINNER JOINcategorie_produitc11_ON (c11_.categorie_id=c9_.idAND (c11_.produit_id=30ORc11_.produit_id=30)) WHEREp8_.id=p0_.id))) ORDER BYp0_.createdDESC;
SELECTDISTINCTp0_.idASid_0,p0_.visibleASvisible_1,p0_.pageASpage_2,p0_.createdAScreated_3,p0_.updatedASupdated_4,p0_.date_debutASdate_debut_5,p0_.date_finASdate_fin_6,p0_.titreAStitre_7,p0_.slugASslug_8,p0_.contenuAScontenu_9,p0_.image_nameASimage_name_10,p0_.image_updated_atASimage_updated_at_11,p0_.typageAStypage_12,p0_.montantASmontant_13,p0_.montant_minASmontant_min_14,p0_.customer_order_count_minAScustomer_order_count_min_15,p0_.customer_order_count_maxAScustomer_order_count_max_16,p0_.customer_lifetime_spent_minAScustomer_lifetime_spent_min_17,p0_.customer_lifetime_spent_maxAScustomer_lifetime_spent_max_18,p0_.customer_account_age_days_minAScustomer_account_age_days_min_19,p0_.customer_account_age_days_maxAScustomer_account_age_days_max_20,p0_.y_offertASy_offert_21,p0_.meta_titleASmeta_title_22,p0_.meta_keywordASmeta_keyword_23,p0_.meta_descriptionASmeta_description_24,p0_.produit_offert_idASproduit_offert_id_25FROMpromotionp0_LEFT JOINpromotion_produitp2_ONp0_.id=p2_.promotion_idLEFT JOINproduitp1_ONp1_.id=p2_.produit_idLEFT JOINpromotion_categoriep4_ONp0_.id=p4_.promotion_idLEFT JOINcategoriec3_ONc3_.id=p4_.categorie_idWHEREp0_.visible=?AND ((p0_.date_fin>=?ORp0_.date_finISNULL)) AND ((p0_.date_debut<=?ORp0_.date_debutISNULL)) AND ((p0_.date_fin>=?ORp0_.date_finISNULL)) AND ((p0_.date_debut<=?ORp0_.date_debutISNULL)) AND (((p1_.id=?) OR (c3_.idIN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) ANDc3_.idISNOTNULL))) AND ((p0_.montant_minISNULLORp0_.montant_min<=?)) AND (NOT (EXISTS (SELECT1ASsclr_26FROMpromotionp5_INNER JOINpromotion_produit_excludep7_ONp5_.id=p7_.promotion_idINNER JOINproduitp6_ONp6_.id=p7_.produit_idWHEREp5_.id=p0_.idAND ((p6_.id=?ORp6_.id=?))))) AND (NOT (EXISTS (SELECT1ASsclr_27FROMpromotionp8_INNER JOINpromotion_categorie_excludep10_ONp8_.id=p10_.promotion_idINNER JOINcategoriec9_ONc9_.id=p10_.categorie_idINNER JOINcategorie_produitc11_ON (c11_.categorie_id=c9_.idAND (c11_.produit_id=?ORc11_.produit_id=?)) WHEREp8_.id=p0_.id))) ORDER BYp0_.createdDESC
SELECTDISTINCTp0_.idASid_0,p0_.visibleASvisible_1,p0_.pageASpage_2,p0_.createdAScreated_3,p0_.updatedASupdated_4,p0_.date_debutASdate_debut_5,p0_.date_finASdate_fin_6,p0_.titreAStitre_7,p0_.slugASslug_8,p0_.contenuAScontenu_9,p0_.image_nameASimage_name_10,p0_.image_updated_atASimage_updated_at_11,p0_.typageAStypage_12,p0_.montantASmontant_13,p0_.montant_minASmontant_min_14,p0_.customer_order_count_minAScustomer_order_count_min_15,p0_.customer_order_count_maxAScustomer_order_count_max_16,p0_.customer_lifetime_spent_minAScustomer_lifetime_spent_min_17,p0_.customer_lifetime_spent_maxAScustomer_lifetime_spent_max_18,p0_.customer_account_age_days_minAScustomer_account_age_days_min_19,p0_.customer_account_age_days_maxAScustomer_account_age_days_max_20,p0_.y_offertASy_offert_21,p0_.meta_titleASmeta_title_22,p0_.meta_keywordASmeta_keyword_23,p0_.meta_descriptionASmeta_description_24,p0_.produit_offert_idASproduit_offert_id_25FROMpromotionp0_LEFT JOINpromotion_produitp2_ONp0_.id=p2_.promotion_idLEFT JOINproduitp1_ONp1_.id=p2_.produit_idLEFT JOINpromotion_categoriep4_ONp0_.id=p4_.promotion_idLEFT JOINcategoriec3_ONc3_.id=p4_.categorie_idWHEREp0_.visible=?AND (
(
p0_.date_fin>=?ORp0_.date_finISNULL
)
)
AND (
(
p0_.date_debut<=?ORp0_.date_debutISNULL
)
)
AND (
(
p0_.date_fin>=?ORp0_.date_finISNULL
)
)
AND (
(
p0_.date_debut<=?ORp0_.date_debutISNULL
)
)
AND (
(
(p1_.id=?)
OR (
c3_.idIN (
?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?
)
ANDc3_.idISNOTNULL
)
)
)
AND (
(
p0_.montant_minISNULLORp0_.montant_min<=?
)
)
AND (
NOT (
EXISTS (
SELECT1ASsclr_26FROMpromotionp5_INNER JOINpromotion_produit_excludep7_ONp5_.id=p7_.promotion_idINNER JOINproduitp6_ONp6_.id=p7_.produit_idWHEREp5_.id=p0_.idAND (
(
p6_.id=?ORp6_.id=?
)
)
)
)
)
AND (
NOT (
EXISTS (
SELECT1ASsclr_27FROMpromotionp8_INNER JOINpromotion_categorie_excludep10_ONp8_.id=p10_.promotion_idINNER JOINcategoriec9_ONc9_.id=p10_.categorie_idINNER JOINcategorie_produitc11_ON (
c11_.categorie_id=c9_.idAND (
c11_.produit_id=?ORc11_.produit_id=?
)
)
WHEREp8_.id=p0_.id
)
)
)
ORDER BYp0_.createdDESC
SELECTDISTINCTp0_.idASid_0,p0_.visibleASvisible_1,p0_.pageASpage_2,p0_.createdAScreated_3,p0_.updatedASupdated_4,p0_.date_debutASdate_debut_5,p0_.date_finASdate_fin_6,p0_.titreAStitre_7,p0_.slugASslug_8,p0_.contenuAScontenu_9,p0_.image_nameASimage_name_10,p0_.image_updated_atASimage_updated_at_11,p0_.typageAStypage_12,p0_.montantASmontant_13,p0_.montant_minASmontant_min_14,p0_.customer_order_count_minAScustomer_order_count_min_15,p0_.customer_order_count_maxAScustomer_order_count_max_16,p0_.customer_lifetime_spent_minAScustomer_lifetime_spent_min_17,p0_.customer_lifetime_spent_maxAScustomer_lifetime_spent_max_18,p0_.customer_account_age_days_minAScustomer_account_age_days_min_19,p0_.customer_account_age_days_maxAScustomer_account_age_days_max_20,p0_.y_offertASy_offert_21,p0_.meta_titleASmeta_title_22,p0_.meta_keywordASmeta_keyword_23,p0_.meta_descriptionASmeta_description_24,p0_.produit_offert_idASproduit_offert_id_25FROMpromotionp0_LEFT JOINpromotion_produitp2_ONp0_.id=p2_.promotion_idLEFT JOINproduitp1_ONp1_.id=p2_.produit_idLEFT JOINpromotion_categoriep4_ONp0_.id=p4_.promotion_idLEFT JOINcategoriec3_ONc3_.id=p4_.categorie_idWHEREp0_.visible=1AND ((p0_.date_fin>='2026-09-24 16:24:04'ORp0_.date_finISNULL)) AND ((p0_.date_debut<='2026-09-24 16:24:04'ORp0_.date_debutISNULL)) AND ((p0_.date_fin>='2026-09-24 16:24:04'ORp0_.date_finISNULL)) AND ((p0_.date_debut<='2026-09-24 16:24:04'ORp0_.date_debutISNULL)) AND (((p1_.id=9) OR (c3_.idIN (65,226,229,220,219,218,217,216,215,214,21,58,83,19,5,2,9,59) ANDc3_.idISNOTNULL))) AND ((p0_.montant_minISNULLORp0_.montant_min<=0)) AND (NOT (EXISTS (SELECT1ASsclr_26FROMpromotionp5_INNER JOINpromotion_produit_excludep7_ONp5_.id=p7_.promotion_idINNER JOINproduitp6_ONp6_.id=p7_.produit_idWHEREp5_.id=p0_.idAND ((p6_.id=9ORp6_.id=9))))) AND (NOT (EXISTS (SELECT1ASsclr_27FROMpromotionp8_INNER JOINpromotion_categorie_excludep10_ONp8_.id=p10_.promotion_idINNER JOINcategoriec9_ONc9_.id=p10_.categorie_idINNER JOINcategorie_produitc11_ON (c11_.categorie_id=c9_.idAND (c11_.produit_id=9ORc11_.produit_id=9)) WHEREp8_.id=p0_.id))) ORDER BYp0_.createdDESC;
SELECTDISTINCTp0_.idASid_0,p0_.visibleASvisible_1,p0_.pageASpage_2,p0_.createdAScreated_3,p0_.updatedASupdated_4,p0_.date_debutASdate_debut_5,p0_.date_finASdate_fin_6,p0_.titreAStitre_7,p0_.slugASslug_8,p0_.contenuAScontenu_9,p0_.image_nameASimage_name_10,p0_.image_updated_atASimage_updated_at_11,p0_.typageAStypage_12,p0_.montantASmontant_13,p0_.montant_minASmontant_min_14,p0_.customer_order_count_minAScustomer_order_count_min_15,p0_.customer_order_count_maxAScustomer_order_count_max_16,p0_.customer_lifetime_spent_minAScustomer_lifetime_spent_min_17,p0_.customer_lifetime_spent_maxAScustomer_lifetime_spent_max_18,p0_.customer_account_age_days_minAScustomer_account_age_days_min_19,p0_.customer_account_age_days_maxAScustomer_account_age_days_max_20,p0_.y_offertASy_offert_21,p0_.meta_titleASmeta_title_22,p0_.meta_keywordASmeta_keyword_23,p0_.meta_descriptionASmeta_description_24,p0_.produit_offert_idASproduit_offert_id_25FROMpromotionp0_LEFT JOINpromotion_produitp2_ONp0_.id=p2_.promotion_idLEFT JOINproduitp1_ONp1_.id=p2_.produit_idLEFT JOINpromotion_categoriep4_ONp0_.id=p4_.promotion_idLEFT JOINcategoriec3_ONc3_.id=p4_.categorie_idWHEREp0_.visible=?AND ((p0_.date_fin>=?ORp0_.date_finISNULL)) AND ((p0_.date_debut<=?ORp0_.date_debutISNULL)) AND ((p0_.date_fin>=?ORp0_.date_finISNULL)) AND ((p0_.date_debut<=?ORp0_.date_debutISNULL)) AND (((p1_.id=?) OR (c3_.idIN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) ANDc3_.idISNOTNULL))) AND ((p0_.montant_minISNULLORp0_.montant_min<=?)) AND (NOT (EXISTS (SELECT1ASsclr_26FROMpromotionp5_INNER JOINpromotion_produit_excludep7_ONp5_.id=p7_.promotion_idINNER JOINproduitp6_ONp6_.id=p7_.produit_idWHEREp5_.id=p0_.idAND ((p6_.id=?ORp6_.id=?))))) AND (NOT (EXISTS (SELECT1ASsclr_27FROMpromotionp8_INNER JOINpromotion_categorie_excludep10_ONp8_.id=p10_.promotion_idINNER JOINcategoriec9_ONc9_.id=p10_.categorie_idINNER JOINcategorie_produitc11_ON (c11_.categorie_id=c9_.idAND (c11_.produit_id=?ORc11_.produit_id=?)) WHEREp8_.id=p0_.id))) ORDER BYp0_.createdDESC
SELECTDISTINCTp0_.idASid_0,p0_.visibleASvisible_1,p0_.pageASpage_2,p0_.createdAScreated_3,p0_.updatedASupdated_4,p0_.date_debutASdate_debut_5,p0_.date_finASdate_fin_6,p0_.titreAStitre_7,p0_.slugASslug_8,p0_.contenuAScontenu_9,p0_.image_nameASimage_name_10,p0_.image_updated_atASimage_updated_at_11,p0_.typageAStypage_12,p0_.montantASmontant_13,p0_.montant_minASmontant_min_14,p0_.customer_order_count_minAScustomer_order_count_min_15,p0_.customer_order_count_maxAScustomer_order_count_max_16,p0_.customer_lifetime_spent_minAScustomer_lifetime_spent_min_17,p0_.customer_lifetime_spent_maxAScustomer_lifetime_spent_max_18,p0_.customer_account_age_days_minAScustomer_account_age_days_min_19,p0_.customer_account_age_days_maxAScustomer_account_age_days_max_20,p0_.y_offertASy_offert_21,p0_.meta_titleASmeta_title_22,p0_.meta_keywordASmeta_keyword_23,p0_.meta_descriptionASmeta_description_24,p0_.produit_offert_idASproduit_offert_id_25FROMpromotionp0_LEFT JOINpromotion_produitp2_ONp0_.id=p2_.promotion_idLEFT JOINproduitp1_ONp1_.id=p2_.produit_idLEFT JOINpromotion_categoriep4_ONp0_.id=p4_.promotion_idLEFT JOINcategoriec3_ONc3_.id=p4_.categorie_idWHEREp0_.visible=?AND (
(
p0_.date_fin>=?ORp0_.date_finISNULL
)
)
AND (
(
p0_.date_debut<=?ORp0_.date_debutISNULL
)
)
AND (
(
p0_.date_fin>=?ORp0_.date_finISNULL
)
)
AND (
(
p0_.date_debut<=?ORp0_.date_debutISNULL
)
)
AND (
(
(p1_.id=?)
OR (
c3_.idIN (
?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?
)
ANDc3_.idISNOTNULL
)
)
)
AND (
(
p0_.montant_minISNULLORp0_.montant_min<=?
)
)
AND (
NOT (
EXISTS (
SELECT1ASsclr_26FROMpromotionp5_INNER JOINpromotion_produit_excludep7_ONp5_.id=p7_.promotion_idINNER JOINproduitp6_ONp6_.id=p7_.produit_idWHEREp5_.id=p0_.idAND (
(
p6_.id=?ORp6_.id=?
)
)
)
)
)
AND (
NOT (
EXISTS (
SELECT1ASsclr_27FROMpromotionp8_INNER JOINpromotion_categorie_excludep10_ONp8_.id=p10_.promotion_idINNER JOINcategoriec9_ONc9_.id=p10_.categorie_idINNER JOINcategorie_produitc11_ON (
c11_.categorie_id=c9_.idAND (
c11_.produit_id=?ORc11_.produit_id=?
)
)
WHEREp8_.id=p0_.id
)
)
)
ORDER BYp0_.createdDESC
SELECTDISTINCTp0_.idASid_0,p0_.visibleASvisible_1,p0_.pageASpage_2,p0_.createdAScreated_3,p0_.updatedASupdated_4,p0_.date_debutASdate_debut_5,p0_.date_finASdate_fin_6,p0_.titreAStitre_7,p0_.slugASslug_8,p0_.contenuAScontenu_9,p0_.image_nameASimage_name_10,p0_.image_updated_atASimage_updated_at_11,p0_.typageAStypage_12,p0_.montantASmontant_13,p0_.montant_minASmontant_min_14,p0_.customer_order_count_minAScustomer_order_count_min_15,p0_.customer_order_count_maxAScustomer_order_count_max_16,p0_.customer_lifetime_spent_minAScustomer_lifetime_spent_min_17,p0_.customer_lifetime_spent_maxAScustomer_lifetime_spent_max_18,p0_.customer_account_age_days_minAScustomer_account_age_days_min_19,p0_.customer_account_age_days_maxAScustomer_account_age_days_max_20,p0_.y_offertASy_offert_21,p0_.meta_titleASmeta_title_22,p0_.meta_keywordASmeta_keyword_23,p0_.meta_descriptionASmeta_description_24,p0_.produit_offert_idASproduit_offert_id_25FROMpromotionp0_LEFT JOINpromotion_produitp2_ONp0_.id=p2_.promotion_idLEFT JOINproduitp1_ONp1_.id=p2_.produit_idLEFT JOINpromotion_categoriep4_ONp0_.id=p4_.promotion_idLEFT JOINcategoriec3_ONc3_.id=p4_.categorie_idWHEREp0_.visible=1AND ((p0_.date_fin>='2026-09-24 16:24:04'ORp0_.date_finISNULL)) AND ((p0_.date_debut<='2026-09-24 16:24:04'ORp0_.date_debutISNULL)) AND ((p0_.date_fin>='2026-09-24 16:24:04'ORp0_.date_finISNULL)) AND ((p0_.date_debut<='2026-09-24 16:24:04'ORp0_.date_debutISNULL)) AND (((p1_.id=46) OR (c3_.idIN (63,226,223,229,220,219,218,217,175,29,174,46,190,166,185,36,20,4,163,5,162,59,3) ANDc3_.idISNOTNULL))) AND ((p0_.montant_minISNULLORp0_.montant_min<=0)) AND (NOT (EXISTS (SELECT1ASsclr_26FROMpromotionp5_INNER JOINpromotion_produit_excludep7_ONp5_.id=p7_.promotion_idINNER JOINproduitp6_ONp6_.id=p7_.produit_idWHEREp5_.id=p0_.idAND ((p6_.id=46ORp6_.id=46))))) AND (NOT (EXISTS (SELECT1ASsclr_27FROMpromotionp8_INNER JOINpromotion_categorie_excludep10_ONp8_.id=p10_.promotion_idINNER JOINcategoriec9_ONc9_.id=p10_.categorie_idINNER JOINcategorie_produitc11_ON (c11_.categorie_id=c9_.idAND (c11_.produit_id=46ORc11_.produit_id=46)) WHEREp8_.id=p0_.id))) ORDER BYp0_.createdDESC;
SELECTDISTINCTp0_.idASid_0,p0_.visibleASvisible_1,p0_.pageASpage_2,p0_.createdAScreated_3,p0_.updatedASupdated_4,p0_.date_debutASdate_debut_5,p0_.date_finASdate_fin_6,p0_.titreAStitre_7,p0_.slugASslug_8,p0_.contenuAScontenu_9,p0_.image_nameASimage_name_10,p0_.image_updated_atASimage_updated_at_11,p0_.typageAStypage_12,p0_.montantASmontant_13,p0_.montant_minASmontant_min_14,p0_.customer_order_count_minAScustomer_order_count_min_15,p0_.customer_order_count_maxAScustomer_order_count_max_16,p0_.customer_lifetime_spent_minAScustomer_lifetime_spent_min_17,p0_.customer_lifetime_spent_maxAScustomer_lifetime_spent_max_18,p0_.customer_account_age_days_minAScustomer_account_age_days_min_19,p0_.customer_account_age_days_maxAScustomer_account_age_days_max_20,p0_.y_offertASy_offert_21,p0_.meta_titleASmeta_title_22,p0_.meta_keywordASmeta_keyword_23,p0_.meta_descriptionASmeta_description_24,p0_.produit_offert_idASproduit_offert_id_25FROMpromotionp0_LEFT JOINpromotion_produitp2_ONp0_.id=p2_.promotion_idLEFT JOINproduitp1_ONp1_.id=p2_.produit_idLEFT JOINpromotion_categoriep4_ONp0_.id=p4_.promotion_idLEFT JOINcategoriec3_ONc3_.id=p4_.categorie_idWHEREp0_.visible=?AND ((p0_.date_fin>=?ORp0_.date_finISNULL)) AND ((p0_.date_debut<=?ORp0_.date_debutISNULL)) AND ((p0_.date_fin>=?ORp0_.date_finISNULL)) AND ((p0_.date_debut<=?ORp0_.date_debutISNULL)) AND (((p1_.id=?ORp1_.id=?) OR (c3_.idIN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) ANDc3_.idISNOTNULL))) AND ((p0_.montant_minISNULLORp0_.montant_min<=?)) AND (NOT (EXISTS (SELECT1ASsclr_26FROMpromotionp5_INNER JOINpromotion_produit_excludep7_ONp5_.id=p7_.promotion_idINNER JOINproduitp6_ONp6_.id=p7_.produit_idWHEREp5_.id=p0_.idAND ((p6_.id=?ORp6_.id=?))))) AND (NOT (EXISTS (SELECT1ASsclr_27FROMpromotionp8_INNER JOINpromotion_categorie_excludep10_ONp8_.id=p10_.promotion_idINNER JOINcategoriec9_ONc9_.id=p10_.categorie_idINNER JOINcategorie_produitc11_ON (c11_.categorie_id=c9_.idAND (c11_.produit_id=?ORc11_.produit_id=?)) WHEREp8_.id=p0_.id))) ORDER BYp0_.createdDESC
SELECTDISTINCTp0_.idASid_0,p0_.visibleASvisible_1,p0_.pageASpage_2,p0_.createdAScreated_3,p0_.updatedASupdated_4,p0_.date_debutASdate_debut_5,p0_.date_finASdate_fin_6,p0_.titreAStitre_7,p0_.slugASslug_8,p0_.contenuAScontenu_9,p0_.image_nameASimage_name_10,p0_.image_updated_atASimage_updated_at_11,p0_.typageAStypage_12,p0_.montantASmontant_13,p0_.montant_minASmontant_min_14,p0_.customer_order_count_minAScustomer_order_count_min_15,p0_.customer_order_count_maxAScustomer_order_count_max_16,p0_.customer_lifetime_spent_minAScustomer_lifetime_spent_min_17,p0_.customer_lifetime_spent_maxAScustomer_lifetime_spent_max_18,p0_.customer_account_age_days_minAScustomer_account_age_days_min_19,p0_.customer_account_age_days_maxAScustomer_account_age_days_max_20,p0_.y_offertASy_offert_21,p0_.meta_titleASmeta_title_22,p0_.meta_keywordASmeta_keyword_23,p0_.meta_descriptionASmeta_description_24,p0_.produit_offert_idASproduit_offert_id_25FROMpromotionp0_LEFT JOINpromotion_produitp2_ONp0_.id=p2_.promotion_idLEFT JOINproduitp1_ONp1_.id=p2_.produit_idLEFT JOINpromotion_categoriep4_ONp0_.id=p4_.promotion_idLEFT JOINcategoriec3_ONc3_.id=p4_.categorie_idWHEREp0_.visible=?AND (
(
p0_.date_fin>=?ORp0_.date_finISNULL
)
)
AND (
(
p0_.date_debut<=?ORp0_.date_debutISNULL
)
)
AND (
(
p0_.date_fin>=?ORp0_.date_finISNULL
)
)
AND (
(
p0_.date_debut<=?ORp0_.date_debutISNULL
)
)
AND (
(
(
p1_.id=?ORp1_.id=?
)
OR (
c3_.idIN (
?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?
)
ANDc3_.idISNOTNULL
)
)
)
AND (
(
p0_.montant_minISNULLORp0_.montant_min<=?
)
)
AND (
NOT (
EXISTS (
SELECT1ASsclr_26FROMpromotionp5_INNER JOINpromotion_produit_excludep7_ONp5_.id=p7_.promotion_idINNER JOINproduitp6_ONp6_.id=p7_.produit_idWHEREp5_.id=p0_.idAND (
(
p6_.id=?ORp6_.id=?
)
)
)
)
)
AND (
NOT (
EXISTS (
SELECT1ASsclr_27FROMpromotionp8_INNER JOINpromotion_categorie_excludep10_ONp8_.id=p10_.promotion_idINNER JOINcategoriec9_ONc9_.id=p10_.categorie_idINNER JOINcategorie_produitc11_ON (
c11_.categorie_id=c9_.idAND (
c11_.produit_id=?ORc11_.produit_id=?
)
)
WHEREp8_.id=p0_.id
)
)
)
ORDER BYp0_.createdDESC
SELECTDISTINCTp0_.idASid_0,p0_.visibleASvisible_1,p0_.pageASpage_2,p0_.createdAScreated_3,p0_.updatedASupdated_4,p0_.date_debutASdate_debut_5,p0_.date_finASdate_fin_6,p0_.titreAStitre_7,p0_.slugASslug_8,p0_.contenuAScontenu_9,p0_.image_nameASimage_name_10,p0_.image_updated_atASimage_updated_at_11,p0_.typageAStypage_12,p0_.montantASmontant_13,p0_.montant_minASmontant_min_14,p0_.customer_order_count_minAScustomer_order_count_min_15,p0_.customer_order_count_maxAScustomer_order_count_max_16,p0_.customer_lifetime_spent_minAScustomer_lifetime_spent_min_17,p0_.customer_lifetime_spent_maxAScustomer_lifetime_spent_max_18,p0_.customer_account_age_days_minAScustomer_account_age_days_min_19,p0_.customer_account_age_days_maxAScustomer_account_age_days_max_20,p0_.y_offertASy_offert_21,p0_.meta_titleASmeta_title_22,p0_.meta_keywordASmeta_keyword_23,p0_.meta_descriptionASmeta_description_24,p0_.produit_offert_idASproduit_offert_id_25FROMpromotionp0_LEFT JOINpromotion_produitp2_ONp0_.id=p2_.promotion_idLEFT JOINproduitp1_ONp1_.id=p2_.produit_idLEFT JOINpromotion_categoriep4_ONp0_.id=p4_.promotion_idLEFT JOINcategoriec3_ONc3_.id=p4_.categorie_idWHEREp0_.visible=1AND ((p0_.date_fin>='2026-09-24 16:24:04'ORp0_.date_finISNULL)) AND ((p0_.date_debut<='2026-09-24 16:24:04'ORp0_.date_debutISNULL)) AND ((p0_.date_fin>='2026-09-24 16:24:04'ORp0_.date_finISNULL)) AND ((p0_.date_debut<='2026-09-24 16:24:04'ORp0_.date_debutISNULL)) AND (((p1_.id=718ORp1_.id=716) OR (c3_.idIN (226,229,220,219,218,217,216,215,214,185,170,126,191,127,8,128,133,163) ANDc3_.idISNOTNULL))) AND ((p0_.montant_minISNULLORp0_.montant_min<=0)) AND (NOT (EXISTS (SELECT1ASsclr_26FROMpromotionp5_INNER JOINpromotion_produit_excludep7_ONp5_.id=p7_.promotion_idINNER JOINproduitp6_ONp6_.id=p7_.produit_idWHEREp5_.id=p0_.idAND ((p6_.id=718ORp6_.id=716))))) AND (NOT (EXISTS (SELECT1ASsclr_27FROMpromotionp8_INNER JOINpromotion_categorie_excludep10_ONp8_.id=p10_.promotion_idINNER JOINcategoriec9_ONc9_.id=p10_.categorie_idINNER JOINcategorie_produitc11_ON (c11_.categorie_id=c9_.idAND (c11_.produit_id=718ORc11_.produit_id=716)) WHEREp8_.id=p0_.id))) ORDER BYp0_.createdDESC;
SELECTDISTINCTp0_.idASid_0,p0_.visibleASvisible_1,p0_.pageASpage_2,p0_.createdAScreated_3,p0_.updatedASupdated_4,p0_.date_debutASdate_debut_5,p0_.date_finASdate_fin_6,p0_.titreAStitre_7,p0_.slugASslug_8,p0_.contenuAScontenu_9,p0_.image_nameASimage_name_10,p0_.image_updated_atASimage_updated_at_11,p0_.typageAStypage_12,p0_.montantASmontant_13,p0_.montant_minASmontant_min_14,p0_.customer_order_count_minAScustomer_order_count_min_15,p0_.customer_order_count_maxAScustomer_order_count_max_16,p0_.customer_lifetime_spent_minAScustomer_lifetime_spent_min_17,p0_.customer_lifetime_spent_maxAScustomer_lifetime_spent_max_18,p0_.customer_account_age_days_minAScustomer_account_age_days_min_19,p0_.customer_account_age_days_maxAScustomer_account_age_days_max_20,p0_.y_offertASy_offert_21,p0_.meta_titleASmeta_title_22,p0_.meta_keywordASmeta_keyword_23,p0_.meta_descriptionASmeta_description_24,p0_.produit_offert_idASproduit_offert_id_25FROMpromotionp0_LEFT JOINpromotion_produitp2_ONp0_.id=p2_.promotion_idLEFT JOINproduitp1_ONp1_.id=p2_.produit_idLEFT JOINpromotion_categoriep4_ONp0_.id=p4_.promotion_idLEFT JOINcategoriec3_ONc3_.id=p4_.categorie_idWHEREp0_.visible=?AND ((p0_.date_fin>=?ORp0_.date_finISNULL)) AND ((p0_.date_debut<=?ORp0_.date_debutISNULL)) AND ((p0_.date_fin>=?ORp0_.date_finISNULL)) AND ((p0_.date_debut<=?ORp0_.date_debutISNULL)) AND (((p1_.id=?ORp1_.id=?) OR (c3_.idIN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) ANDc3_.idISNOTNULL))) AND ((p0_.montant_minISNULLORp0_.montant_min<=?)) AND (NOT (EXISTS (SELECT1ASsclr_26FROMpromotionp5_INNER JOINpromotion_produit_excludep7_ONp5_.id=p7_.promotion_idINNER JOINproduitp6_ONp6_.id=p7_.produit_idWHEREp5_.id=p0_.idAND ((p6_.id=?ORp6_.id=?))))) AND (NOT (EXISTS (SELECT1ASsclr_27FROMpromotionp8_INNER JOINpromotion_categorie_excludep10_ONp8_.id=p10_.promotion_idINNER JOINcategoriec9_ONc9_.id=p10_.categorie_idINNER JOINcategorie_produitc11_ON (c11_.categorie_id=c9_.idAND (c11_.produit_id=?ORc11_.produit_id=?)) WHEREp8_.id=p0_.id))) ORDER BYp0_.createdDESC
SELECTDISTINCTp0_.idASid_0,p0_.visibleASvisible_1,p0_.pageASpage_2,p0_.createdAScreated_3,p0_.updatedASupdated_4,p0_.date_debutASdate_debut_5,p0_.date_finASdate_fin_6,p0_.titreAStitre_7,p0_.slugASslug_8,p0_.contenuAScontenu_9,p0_.image_nameASimage_name_10,p0_.image_updated_atASimage_updated_at_11,p0_.typageAStypage_12,p0_.montantASmontant_13,p0_.montant_minASmontant_min_14,p0_.customer_order_count_minAScustomer_order_count_min_15,p0_.customer_order_count_maxAScustomer_order_count_max_16,p0_.customer_lifetime_spent_minAScustomer_lifetime_spent_min_17,p0_.customer_lifetime_spent_maxAScustomer_lifetime_spent_max_18,p0_.customer_account_age_days_minAScustomer_account_age_days_min_19,p0_.customer_account_age_days_maxAScustomer_account_age_days_max_20,p0_.y_offertASy_offert_21,p0_.meta_titleASmeta_title_22,p0_.meta_keywordASmeta_keyword_23,p0_.meta_descriptionASmeta_description_24,p0_.produit_offert_idASproduit_offert_id_25FROMpromotionp0_LEFT JOINpromotion_produitp2_ONp0_.id=p2_.promotion_idLEFT JOINproduitp1_ONp1_.id=p2_.produit_idLEFT JOINpromotion_categoriep4_ONp0_.id=p4_.promotion_idLEFT JOINcategoriec3_ONc3_.id=p4_.categorie_idWHEREp0_.visible=?AND (
(
p0_.date_fin>=?ORp0_.date_finISNULL
)
)
AND (
(
p0_.date_debut<=?ORp0_.date_debutISNULL
)
)
AND (
(
p0_.date_fin>=?ORp0_.date_finISNULL
)
)
AND (
(
p0_.date_debut<=?ORp0_.date_debutISNULL
)
)
AND (
(
(
p1_.id=?ORp1_.id=?
)
OR (
c3_.idIN (
?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?
)
ANDc3_.idISNOTNULL
)
)
)
AND (
(
p0_.montant_minISNULLORp0_.montant_min<=?
)
)
AND (
NOT (
EXISTS (
SELECT1ASsclr_26FROMpromotionp5_INNER JOINpromotion_produit_excludep7_ONp5_.id=p7_.promotion_idINNER JOINproduitp6_ONp6_.id=p7_.produit_idWHEREp5_.id=p0_.idAND (
(
p6_.id=?ORp6_.id=?
)
)
)
)
)
AND (
NOT (
EXISTS (
SELECT1ASsclr_27FROMpromotionp8_INNER JOINpromotion_categorie_excludep10_ONp8_.id=p10_.promotion_idINNER JOINcategoriec9_ONc9_.id=p10_.categorie_idINNER JOINcategorie_produitc11_ON (
c11_.categorie_id=c9_.idAND (
c11_.produit_id=?ORc11_.produit_id=?
)
)
WHEREp8_.id=p0_.id
)
)
)
ORDER BYp0_.createdDESC
SELECTDISTINCTp0_.idASid_0,p0_.visibleASvisible_1,p0_.pageASpage_2,p0_.createdAScreated_3,p0_.updatedASupdated_4,p0_.date_debutASdate_debut_5,p0_.date_finASdate_fin_6,p0_.titreAStitre_7,p0_.slugASslug_8,p0_.contenuAScontenu_9,p0_.image_nameASimage_name_10,p0_.image_updated_atASimage_updated_at_11,p0_.typageAStypage_12,p0_.montantASmontant_13,p0_.montant_minASmontant_min_14,p0_.customer_order_count_minAScustomer_order_count_min_15,p0_.customer_order_count_maxAScustomer_order_count_max_16,p0_.customer_lifetime_spent_minAScustomer_lifetime_spent_min_17,p0_.customer_lifetime_spent_maxAScustomer_lifetime_spent_max_18,p0_.customer_account_age_days_minAScustomer_account_age_days_min_19,p0_.customer_account_age_days_maxAScustomer_account_age_days_max_20,p0_.y_offertASy_offert_21,p0_.meta_titleASmeta_title_22,p0_.meta_keywordASmeta_keyword_23,p0_.meta_descriptionASmeta_description_24,p0_.produit_offert_idASproduit_offert_id_25FROMpromotionp0_LEFT JOINpromotion_produitp2_ONp0_.id=p2_.promotion_idLEFT JOINproduitp1_ONp1_.id=p2_.produit_idLEFT JOINpromotion_categoriep4_ONp0_.id=p4_.promotion_idLEFT JOINcategoriec3_ONc3_.id=p4_.categorie_idWHEREp0_.visible=1AND ((p0_.date_fin>='2026-09-24 16:24:04'ORp0_.date_finISNULL)) AND ((p0_.date_debut<='2026-09-24 16:24:04'ORp0_.date_debutISNULL)) AND ((p0_.date_fin>='2026-09-24 16:24:04'ORp0_.date_finISNULL)) AND ((p0_.date_debut<='2026-09-24 16:24:04'ORp0_.date_debutISNULL)) AND (((p1_.id=717ORp1_.id=716) OR (c3_.idIN (226,215,214,217,216,218,219,220,229,185,170,126,116,191,171,133,127,8,128,163) ANDc3_.idISNOTNULL))) AND ((p0_.montant_minISNULLORp0_.montant_min<=0)) AND (NOT (EXISTS (SELECT1ASsclr_26FROMpromotionp5_INNER JOINpromotion_produit_excludep7_ONp5_.id=p7_.promotion_idINNER JOINproduitp6_ONp6_.id=p7_.produit_idWHEREp5_.id=p0_.idAND ((p6_.id=717ORp6_.id=716))))) AND (NOT (EXISTS (SELECT1ASsclr_27FROMpromotionp8_INNER JOINpromotion_categorie_excludep10_ONp8_.id=p10_.promotion_idINNER JOINcategoriec9_ONc9_.id=p10_.categorie_idINNER JOINcategorie_produitc11_ON (c11_.categorie_id=c9_.idAND (c11_.produit_id=717ORc11_.produit_id=716)) WHEREp8_.id=p0_.id))) ORDER BYp0_.createdDESC;
SELECTDISTINCTp0_.idASid_0,p0_.visibleASvisible_1,p0_.pageASpage_2,p0_.createdAScreated_3,p0_.updatedASupdated_4,p0_.date_debutASdate_debut_5,p0_.date_finASdate_fin_6,p0_.titreAStitre_7,p0_.slugASslug_8,p0_.contenuAScontenu_9,p0_.image_nameASimage_name_10,p0_.image_updated_atASimage_updated_at_11,p0_.typageAStypage_12,p0_.montantASmontant_13,p0_.montant_minASmontant_min_14,p0_.customer_order_count_minAScustomer_order_count_min_15,p0_.customer_order_count_maxAScustomer_order_count_max_16,p0_.customer_lifetime_spent_minAScustomer_lifetime_spent_min_17,p0_.customer_lifetime_spent_maxAScustomer_lifetime_spent_max_18,p0_.customer_account_age_days_minAScustomer_account_age_days_min_19,p0_.customer_account_age_days_maxAScustomer_account_age_days_max_20,p0_.y_offertASy_offert_21,p0_.meta_titleASmeta_title_22,p0_.meta_keywordASmeta_keyword_23,p0_.meta_descriptionASmeta_description_24,p0_.produit_offert_idASproduit_offert_id_25FROMpromotionp0_LEFT JOINpromotion_produitp2_ONp0_.id=p2_.promotion_idLEFT JOINproduitp1_ONp1_.id=p2_.produit_idLEFT JOINpromotion_categoriep4_ONp0_.id=p4_.promotion_idLEFT JOINcategoriec3_ONc3_.id=p4_.categorie_idWHEREp0_.visible=?AND ((p0_.date_fin>=?ORp0_.date_finISNULL)) AND ((p0_.date_debut<=?ORp0_.date_debutISNULL)) AND ((p0_.date_fin>=?ORp0_.date_finISNULL)) AND ((p0_.date_debut<=?ORp0_.date_debutISNULL)) AND (((p1_.id=?) OR (c3_.idIN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) ANDc3_.idISNOTNULL))) AND ((p0_.montant_minISNULLORp0_.montant_min<=?)) AND (NOT (EXISTS (SELECT1ASsclr_26FROMpromotionp5_INNER JOINpromotion_produit_excludep7_ONp5_.id=p7_.promotion_idINNER JOINproduitp6_ONp6_.id=p7_.produit_idWHEREp5_.id=p0_.idAND ((p6_.id=?ORp6_.id=?))))) AND (NOT (EXISTS (SELECT1ASsclr_27FROMpromotionp8_INNER JOINpromotion_categorie_excludep10_ONp8_.id=p10_.promotion_idINNER JOINcategoriec9_ONc9_.id=p10_.categorie_idINNER JOINcategorie_produitc11_ON (c11_.categorie_id=c9_.idAND (c11_.produit_id=?ORc11_.produit_id=?)) WHEREp8_.id=p0_.id))) ORDER BYp0_.createdDESC
SELECTDISTINCTp0_.idASid_0,p0_.visibleASvisible_1,p0_.pageASpage_2,p0_.createdAScreated_3,p0_.updatedASupdated_4,p0_.date_debutASdate_debut_5,p0_.date_finASdate_fin_6,p0_.titreAStitre_7,p0_.slugASslug_8,p0_.contenuAScontenu_9,p0_.image_nameASimage_name_10,p0_.image_updated_atASimage_updated_at_11,p0_.typageAStypage_12,p0_.montantASmontant_13,p0_.montant_minASmontant_min_14,p0_.customer_order_count_minAScustomer_order_count_min_15,p0_.customer_order_count_maxAScustomer_order_count_max_16,p0_.customer_lifetime_spent_minAScustomer_lifetime_spent_min_17,p0_.customer_lifetime_spent_maxAScustomer_lifetime_spent_max_18,p0_.customer_account_age_days_minAScustomer_account_age_days_min_19,p0_.customer_account_age_days_maxAScustomer_account_age_days_max_20,p0_.y_offertASy_offert_21,p0_.meta_titleASmeta_title_22,p0_.meta_keywordASmeta_keyword_23,p0_.meta_descriptionASmeta_description_24,p0_.produit_offert_idASproduit_offert_id_25FROMpromotionp0_LEFT JOINpromotion_produitp2_ONp0_.id=p2_.promotion_idLEFT JOINproduitp1_ONp1_.id=p2_.produit_idLEFT JOINpromotion_categoriep4_ONp0_.id=p4_.promotion_idLEFT JOINcategoriec3_ONc3_.id=p4_.categorie_idWHEREp0_.visible=?AND (
(
p0_.date_fin>=?ORp0_.date_finISNULL
)
)
AND (
(
p0_.date_debut<=?ORp0_.date_debutISNULL
)
)
AND (
(
p0_.date_fin>=?ORp0_.date_finISNULL
)
)
AND (
(
p0_.date_debut<=?ORp0_.date_debutISNULL
)
)
AND (
(
(p1_.id=?)
OR (
c3_.idIN (
?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?
)
ANDc3_.idISNOTNULL
)
)
)
AND (
(
p0_.montant_minISNULLORp0_.montant_min<=?
)
)
AND (
NOT (
EXISTS (
SELECT1ASsclr_26FROMpromotionp5_INNER JOINpromotion_produit_excludep7_ONp5_.id=p7_.promotion_idINNER JOINproduitp6_ONp6_.id=p7_.produit_idWHEREp5_.id=p0_.idAND (
(
p6_.id=?ORp6_.id=?
)
)
)
)
)
AND (
NOT (
EXISTS (
SELECT1ASsclr_27FROMpromotionp8_INNER JOINpromotion_categorie_excludep10_ONp8_.id=p10_.promotion_idINNER JOINcategoriec9_ONc9_.id=p10_.categorie_idINNER JOINcategorie_produitc11_ON (
c11_.categorie_id=c9_.idAND (
c11_.produit_id=?ORc11_.produit_id=?
)
)
WHEREp8_.id=p0_.id
)
)
)
ORDER BYp0_.createdDESC
SELECTDISTINCTp0_.idASid_0,p0_.visibleASvisible_1,p0_.pageASpage_2,p0_.createdAScreated_3,p0_.updatedASupdated_4,p0_.date_debutASdate_debut_5,p0_.date_finASdate_fin_6,p0_.titreAStitre_7,p0_.slugASslug_8,p0_.contenuAScontenu_9,p0_.image_nameASimage_name_10,p0_.image_updated_atASimage_updated_at_11,p0_.typageAStypage_12,p0_.montantASmontant_13,p0_.montant_minASmontant_min_14,p0_.customer_order_count_minAScustomer_order_count_min_15,p0_.customer_order_count_maxAScustomer_order_count_max_16,p0_.customer_lifetime_spent_minAScustomer_lifetime_spent_min_17,p0_.customer_lifetime_spent_maxAScustomer_lifetime_spent_max_18,p0_.customer_account_age_days_minAScustomer_account_age_days_min_19,p0_.customer_account_age_days_maxAScustomer_account_age_days_max_20,p0_.y_offertASy_offert_21,p0_.meta_titleASmeta_title_22,p0_.meta_keywordASmeta_keyword_23,p0_.meta_descriptionASmeta_description_24,p0_.produit_offert_idASproduit_offert_id_25FROMpromotionp0_LEFT JOINpromotion_produitp2_ONp0_.id=p2_.promotion_idLEFT JOINproduitp1_ONp1_.id=p2_.produit_idLEFT JOINpromotion_categoriep4_ONp0_.id=p4_.promotion_idLEFT JOINcategoriec3_ONc3_.id=p4_.categorie_idWHEREp0_.visible=1AND ((p0_.date_fin>='2026-09-24 16:24:04'ORp0_.date_finISNULL)) AND ((p0_.date_debut<='2026-09-24 16:24:04'ORp0_.date_debutISNULL)) AND ((p0_.date_fin>='2026-09-24 16:24:04'ORp0_.date_finISNULL)) AND ((p0_.date_debut<='2026-09-24 16:24:04'ORp0_.date_debutISNULL)) AND (((p1_.id=681) OR (c3_.idIN (226,229,220,219,218,217,216,215,171,126,170,116,154,17,128,133,8,10,134,15,61,163) ANDc3_.idISNOTNULL))) AND ((p0_.montant_minISNULLORp0_.montant_min<=0)) AND (NOT (EXISTS (SELECT1ASsclr_26FROMpromotionp5_INNER JOINpromotion_produit_excludep7_ONp5_.id=p7_.promotion_idINNER JOINproduitp6_ONp6_.id=p7_.produit_idWHEREp5_.id=p0_.idAND ((p6_.id=681ORp6_.id=681))))) AND (NOT (EXISTS (SELECT1ASsclr_27FROMpromotionp8_INNER JOINpromotion_categorie_excludep10_ONp8_.id=p10_.promotion_idINNER JOINcategoriec9_ONc9_.id=p10_.categorie_idINNER JOINcategorie_produitc11_ON (c11_.categorie_id=c9_.idAND (c11_.produit_id=681ORc11_.produit_id=681)) WHEREp8_.id=p0_.id))) ORDER BYp0_.createdDESC;
SELECTDISTINCTp0_.idASid_0,p0_.visibleASvisible_1,p0_.pageASpage_2,p0_.createdAScreated_3,p0_.updatedASupdated_4,p0_.date_debutASdate_debut_5,p0_.date_finASdate_fin_6,p0_.titreAStitre_7,p0_.slugASslug_8,p0_.contenuAScontenu_9,p0_.image_nameASimage_name_10,p0_.image_updated_atASimage_updated_at_11,p0_.typageAStypage_12,p0_.montantASmontant_13,p0_.montant_minASmontant_min_14,p0_.customer_order_count_minAScustomer_order_count_min_15,p0_.customer_order_count_maxAScustomer_order_count_max_16,p0_.customer_lifetime_spent_minAScustomer_lifetime_spent_min_17,p0_.customer_lifetime_spent_maxAScustomer_lifetime_spent_max_18,p0_.customer_account_age_days_minAScustomer_account_age_days_min_19,p0_.customer_account_age_days_maxAScustomer_account_age_days_max_20,p0_.y_offertASy_offert_21,p0_.meta_titleASmeta_title_22,p0_.meta_keywordASmeta_keyword_23,p0_.meta_descriptionASmeta_description_24,p0_.produit_offert_idASproduit_offert_id_25FROMpromotionp0_LEFT JOINpromotion_produitp2_ONp0_.id=p2_.promotion_idLEFT JOINproduitp1_ONp1_.id=p2_.produit_idLEFT JOINpromotion_categoriep4_ONp0_.id=p4_.promotion_idLEFT JOINcategoriec3_ONc3_.id=p4_.categorie_idWHEREp0_.visible=?AND ((p0_.date_fin>=?ORp0_.date_finISNULL)) AND ((p0_.date_debut<=?ORp0_.date_debutISNULL)) AND ((p0_.date_fin>=?ORp0_.date_finISNULL)) AND ((p0_.date_debut<=?ORp0_.date_debutISNULL)) AND (((p1_.id=?) OR (c3_.idIN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) ANDc3_.idISNOTNULL))) AND ((p0_.montant_minISNULLORp0_.montant_min<=?)) AND (NOT (EXISTS (SELECT1ASsclr_26FROMpromotionp5_INNER JOINpromotion_produit_excludep7_ONp5_.id=p7_.promotion_idINNER JOINproduitp6_ONp6_.id=p7_.produit_idWHEREp5_.id=p0_.idAND ((p6_.id=?ORp6_.id=?))))) AND (NOT (EXISTS (SELECT1ASsclr_27FROMpromotionp8_INNER JOINpromotion_categorie_excludep10_ONp8_.id=p10_.promotion_idINNER JOINcategoriec9_ONc9_.id=p10_.categorie_idINNER JOINcategorie_produitc11_ON (c11_.categorie_id=c9_.idAND (c11_.produit_id=?ORc11_.produit_id=?)) WHEREp8_.id=p0_.id))) ORDER BYp0_.createdDESC
SELECTDISTINCTp0_.idASid_0,p0_.visibleASvisible_1,p0_.pageASpage_2,p0_.createdAScreated_3,p0_.updatedASupdated_4,p0_.date_debutASdate_debut_5,p0_.date_finASdate_fin_6,p0_.titreAStitre_7,p0_.slugASslug_8,p0_.contenuAScontenu_9,p0_.image_nameASimage_name_10,p0_.image_updated_atASimage_updated_at_11,p0_.typageAStypage_12,p0_.montantASmontant_13,p0_.montant_minASmontant_min_14,p0_.customer_order_count_minAScustomer_order_count_min_15,p0_.customer_order_count_maxAScustomer_order_count_max_16,p0_.customer_lifetime_spent_minAScustomer_lifetime_spent_min_17,p0_.customer_lifetime_spent_maxAScustomer_lifetime_spent_max_18,p0_.customer_account_age_days_minAScustomer_account_age_days_min_19,p0_.customer_account_age_days_maxAScustomer_account_age_days_max_20,p0_.y_offertASy_offert_21,p0_.meta_titleASmeta_title_22,p0_.meta_keywordASmeta_keyword_23,p0_.meta_descriptionASmeta_description_24,p0_.produit_offert_idASproduit_offert_id_25FROMpromotionp0_LEFT JOINpromotion_produitp2_ONp0_.id=p2_.promotion_idLEFT JOINproduitp1_ONp1_.id=p2_.produit_idLEFT JOINpromotion_categoriep4_ONp0_.id=p4_.promotion_idLEFT JOINcategoriec3_ONc3_.id=p4_.categorie_idWHEREp0_.visible=?AND (
(
p0_.date_fin>=?ORp0_.date_finISNULL
)
)
AND (
(
p0_.date_debut<=?ORp0_.date_debutISNULL
)
)
AND (
(
p0_.date_fin>=?ORp0_.date_finISNULL
)
)
AND (
(
p0_.date_debut<=?ORp0_.date_debutISNULL
)
)
AND (
(
(p1_.id=?)
OR (
c3_.idIN (
?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?
)
ANDc3_.idISNOTNULL
)
)
)
AND (
(
p0_.montant_minISNULLORp0_.montant_min<=?
)
)
AND (
NOT (
EXISTS (
SELECT1ASsclr_26FROMpromotionp5_INNER JOINpromotion_produit_excludep7_ONp5_.id=p7_.promotion_idINNER JOINproduitp6_ONp6_.id=p7_.produit_idWHEREp5_.id=p0_.idAND (
(
p6_.id=?ORp6_.id=?
)
)
)
)
)
AND (
NOT (
EXISTS (
SELECT1ASsclr_27FROMpromotionp8_INNER JOINpromotion_categorie_excludep10_ONp8_.id=p10_.promotion_idINNER JOINcategoriec9_ONc9_.id=p10_.categorie_idINNER JOINcategorie_produitc11_ON (
c11_.categorie_id=c9_.idAND (
c11_.produit_id=?ORc11_.produit_id=?
)
)
WHEREp8_.id=p0_.id
)
)
)
ORDER BYp0_.createdDESC
SELECTDISTINCTp0_.idASid_0,p0_.visibleASvisible_1,p0_.pageASpage_2,p0_.createdAScreated_3,p0_.updatedASupdated_4,p0_.date_debutASdate_debut_5,p0_.date_finASdate_fin_6,p0_.titreAStitre_7,p0_.slugASslug_8,p0_.contenuAScontenu_9,p0_.image_nameASimage_name_10,p0_.image_updated_atASimage_updated_at_11,p0_.typageAStypage_12,p0_.montantASmontant_13,p0_.montant_minASmontant_min_14,p0_.customer_order_count_minAScustomer_order_count_min_15,p0_.customer_order_count_maxAScustomer_order_count_max_16,p0_.customer_lifetime_spent_minAScustomer_lifetime_spent_min_17,p0_.customer_lifetime_spent_maxAScustomer_lifetime_spent_max_18,p0_.customer_account_age_days_minAScustomer_account_age_days_min_19,p0_.customer_account_age_days_maxAScustomer_account_age_days_max_20,p0_.y_offertASy_offert_21,p0_.meta_titleASmeta_title_22,p0_.meta_keywordASmeta_keyword_23,p0_.meta_descriptionASmeta_description_24,p0_.produit_offert_idASproduit_offert_id_25FROMpromotionp0_LEFT JOINpromotion_produitp2_ONp0_.id=p2_.promotion_idLEFT JOINproduitp1_ONp1_.id=p2_.produit_idLEFT JOINpromotion_categoriep4_ONp0_.id=p4_.promotion_idLEFT JOINcategoriec3_ONc3_.id=p4_.categorie_idWHEREp0_.visible=1AND ((p0_.date_fin>='2026-09-24 16:24:04'ORp0_.date_finISNULL)) AND ((p0_.date_debut<='2026-09-24 16:24:04'ORp0_.date_debutISNULL)) AND ((p0_.date_fin>='2026-09-24 16:24:04'ORp0_.date_finISNULL)) AND ((p0_.date_debut<='2026-09-24 16:24:04'ORp0_.date_debutISNULL)) AND (((p1_.id=682) OR (c3_.idIN (226,229,220,219,218,217,216,215,126,170,116,154,17,128,8,10,134,15,61,163) ANDc3_.idISNOTNULL))) AND ((p0_.montant_minISNULLORp0_.montant_min<=0)) AND (NOT (EXISTS (SELECT1ASsclr_26FROMpromotionp5_INNER JOINpromotion_produit_excludep7_ONp5_.id=p7_.promotion_idINNER JOINproduitp6_ONp6_.id=p7_.produit_idWHEREp5_.id=p0_.idAND ((p6_.id=682ORp6_.id=682))))) AND (NOT (EXISTS (SELECT1ASsclr_27FROMpromotionp8_INNER JOINpromotion_categorie_excludep10_ONp8_.id=p10_.promotion_idINNER JOINcategoriec9_ONc9_.id=p10_.categorie_idINNER JOINcategorie_produitc11_ON (c11_.categorie_id=c9_.idAND (c11_.produit_id=682ORc11_.produit_id=682)) WHEREp8_.id=p0_.id))) ORDER BYp0_.createdDESC;
SELECTDISTINCTp0_.idASid_0,p0_.visibleASvisible_1,p0_.pageASpage_2,p0_.createdAScreated_3,p0_.updatedASupdated_4,p0_.date_debutASdate_debut_5,p0_.date_finASdate_fin_6,p0_.titreAStitre_7,p0_.slugASslug_8,p0_.contenuAScontenu_9,p0_.image_nameASimage_name_10,p0_.image_updated_atASimage_updated_at_11,p0_.typageAStypage_12,p0_.montantASmontant_13,p0_.montant_minASmontant_min_14,p0_.customer_order_count_minAScustomer_order_count_min_15,p0_.customer_order_count_maxAScustomer_order_count_max_16,p0_.customer_lifetime_spent_minAScustomer_lifetime_spent_min_17,p0_.customer_lifetime_spent_maxAScustomer_lifetime_spent_max_18,p0_.customer_account_age_days_minAScustomer_account_age_days_min_19,p0_.customer_account_age_days_maxAScustomer_account_age_days_max_20,p0_.y_offertASy_offert_21,p0_.meta_titleASmeta_title_22,p0_.meta_keywordASmeta_keyword_23,p0_.meta_descriptionASmeta_description_24,p0_.produit_offert_idASproduit_offert_id_25FROMpromotionp0_LEFT JOINpromotion_produitp2_ONp0_.id=p2_.promotion_idLEFT JOINproduitp1_ONp1_.id=p2_.produit_idLEFT JOINpromotion_categoriep4_ONp0_.id=p4_.promotion_idLEFT JOINcategoriec3_ONc3_.id=p4_.categorie_idWHEREp0_.visible=?AND ((p0_.date_fin>=?ORp0_.date_finISNULL)) AND ((p0_.date_debut<=?ORp0_.date_debutISNULL)) AND ((p0_.date_fin>=?ORp0_.date_finISNULL)) AND ((p0_.date_debut<=?ORp0_.date_debutISNULL)) AND (((p1_.id=?) OR (c3_.idIN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) ANDc3_.idISNOTNULL))) AND ((p0_.montant_minISNULLORp0_.montant_min<=?)) AND (NOT (EXISTS (SELECT1ASsclr_26FROMpromotionp5_INNER JOINpromotion_produit_excludep7_ONp5_.id=p7_.promotion_idINNER JOINproduitp6_ONp6_.id=p7_.produit_idWHEREp5_.id=p0_.idAND ((p6_.id=?ORp6_.id=?))))) AND (NOT (EXISTS (SELECT1ASsclr_27FROMpromotionp8_INNER JOINpromotion_categorie_excludep10_ONp8_.id=p10_.promotion_idINNER JOINcategoriec9_ONc9_.id=p10_.categorie_idINNER JOINcategorie_produitc11_ON (c11_.categorie_id=c9_.idAND (c11_.produit_id=?ORc11_.produit_id=?)) WHEREp8_.id=p0_.id))) ORDER BYp0_.createdDESC
SELECTDISTINCTp0_.idASid_0,p0_.visibleASvisible_1,p0_.pageASpage_2,p0_.createdAScreated_3,p0_.updatedASupdated_4,p0_.date_debutASdate_debut_5,p0_.date_finASdate_fin_6,p0_.titreAStitre_7,p0_.slugASslug_8,p0_.contenuAScontenu_9,p0_.image_nameASimage_name_10,p0_.image_updated_atASimage_updated_at_11,p0_.typageAStypage_12,p0_.montantASmontant_13,p0_.montant_minASmontant_min_14,p0_.customer_order_count_minAScustomer_order_count_min_15,p0_.customer_order_count_maxAScustomer_order_count_max_16,p0_.customer_lifetime_spent_minAScustomer_lifetime_spent_min_17,p0_.customer_lifetime_spent_maxAScustomer_lifetime_spent_max_18,p0_.customer_account_age_days_minAScustomer_account_age_days_min_19,p0_.customer_account_age_days_maxAScustomer_account_age_days_max_20,p0_.y_offertASy_offert_21,p0_.meta_titleASmeta_title_22,p0_.meta_keywordASmeta_keyword_23,p0_.meta_descriptionASmeta_description_24,p0_.produit_offert_idASproduit_offert_id_25FROMpromotionp0_LEFT JOINpromotion_produitp2_ONp0_.id=p2_.promotion_idLEFT JOINproduitp1_ONp1_.id=p2_.produit_idLEFT JOINpromotion_categoriep4_ONp0_.id=p4_.promotion_idLEFT JOINcategoriec3_ONc3_.id=p4_.categorie_idWHEREp0_.visible=?AND (
(
p0_.date_fin>=?ORp0_.date_finISNULL
)
)
AND (
(
p0_.date_debut<=?ORp0_.date_debutISNULL
)
)
AND (
(
p0_.date_fin>=?ORp0_.date_finISNULL
)
)
AND (
(
p0_.date_debut<=?ORp0_.date_debutISNULL
)
)
AND (
(
(p1_.id=?)
OR (
c3_.idIN (
?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?
)
ANDc3_.idISNOTNULL
)
)
)
AND (
(
p0_.montant_minISNULLORp0_.montant_min<=?
)
)
AND (
NOT (
EXISTS (
SELECT1ASsclr_26FROMpromotionp5_INNER JOINpromotion_produit_excludep7_ONp5_.id=p7_.promotion_idINNER JOINproduitp6_ONp6_.id=p7_.produit_idWHEREp5_.id=p0_.idAND (
(
p6_.id=?ORp6_.id=?
)
)
)
)
)
AND (
NOT (
EXISTS (
SELECT1ASsclr_27FROMpromotionp8_INNER JOINpromotion_categorie_excludep10_ONp8_.id=p10_.promotion_idINNER JOINcategoriec9_ONc9_.id=p10_.categorie_idINNER JOINcategorie_produitc11_ON (
c11_.categorie_id=c9_.idAND (
c11_.produit_id=?ORc11_.produit_id=?
)
)
WHEREp8_.id=p0_.id
)
)
)
ORDER BYp0_.createdDESC
SELECTDISTINCTp0_.idASid_0,p0_.visibleASvisible_1,p0_.pageASpage_2,p0_.createdAScreated_3,p0_.updatedASupdated_4,p0_.date_debutASdate_debut_5,p0_.date_finASdate_fin_6,p0_.titreAStitre_7,p0_.slugASslug_8,p0_.contenuAScontenu_9,p0_.image_nameASimage_name_10,p0_.image_updated_atASimage_updated_at_11,p0_.typageAStypage_12,p0_.montantASmontant_13,p0_.montant_minASmontant_min_14,p0_.customer_order_count_minAScustomer_order_count_min_15,p0_.customer_order_count_maxAScustomer_order_count_max_16,p0_.customer_lifetime_spent_minAScustomer_lifetime_spent_min_17,p0_.customer_lifetime_spent_maxAScustomer_lifetime_spent_max_18,p0_.customer_account_age_days_minAScustomer_account_age_days_min_19,p0_.customer_account_age_days_maxAScustomer_account_age_days_max_20,p0_.y_offertASy_offert_21,p0_.meta_titleASmeta_title_22,p0_.meta_keywordASmeta_keyword_23,p0_.meta_descriptionASmeta_description_24,p0_.produit_offert_idASproduit_offert_id_25FROMpromotionp0_LEFT JOINpromotion_produitp2_ONp0_.id=p2_.promotion_idLEFT JOINproduitp1_ONp1_.id=p2_.produit_idLEFT JOINpromotion_categoriep4_ONp0_.id=p4_.promotion_idLEFT JOINcategoriec3_ONc3_.id=p4_.categorie_idWHEREp0_.visible=1AND ((p0_.date_fin>='2026-09-24 16:24:04'ORp0_.date_finISNULL)) AND ((p0_.date_debut<='2026-09-24 16:24:04'ORp0_.date_debutISNULL)) AND ((p0_.date_fin>='2026-09-24 16:24:04'ORp0_.date_finISNULL)) AND ((p0_.date_debut<='2026-09-24 16:24:04'ORp0_.date_debutISNULL)) AND (((p1_.id=683) OR (c3_.idIN (227,215,216,217,218,219,220,229,226,126,170,116,171,154,17,128,133,8,10,134,15,61,163) ANDc3_.idISNOTNULL))) AND ((p0_.montant_minISNULLORp0_.montant_min<=0)) AND (NOT (EXISTS (SELECT1ASsclr_26FROMpromotionp5_INNER JOINpromotion_produit_excludep7_ONp5_.id=p7_.promotion_idINNER JOINproduitp6_ONp6_.id=p7_.produit_idWHEREp5_.id=p0_.idAND ((p6_.id=683ORp6_.id=683))))) AND (NOT (EXISTS (SELECT1ASsclr_27FROMpromotionp8_INNER JOINpromotion_categorie_excludep10_ONp8_.id=p10_.promotion_idINNER JOINcategoriec9_ONc9_.id=p10_.categorie_idINNER JOINcategorie_produitc11_ON (c11_.categorie_id=c9_.idAND (c11_.produit_id=683ORc11_.produit_id=683)) WHEREp8_.id=p0_.id))) ORDER BYp0_.createdDESC;
SELECTDISTINCTp0_.idASid_0,p0_.visibleASvisible_1,p0_.pageASpage_2,p0_.createdAScreated_3,p0_.updatedASupdated_4,p0_.date_debutASdate_debut_5,p0_.date_finASdate_fin_6,p0_.titreAStitre_7,p0_.slugASslug_8,p0_.contenuAScontenu_9,p0_.image_nameASimage_name_10,p0_.image_updated_atASimage_updated_at_11,p0_.typageAStypage_12,p0_.montantASmontant_13,p0_.montant_minASmontant_min_14,p0_.customer_order_count_minAScustomer_order_count_min_15,p0_.customer_order_count_maxAScustomer_order_count_max_16,p0_.customer_lifetime_spent_minAScustomer_lifetime_spent_min_17,p0_.customer_lifetime_spent_maxAScustomer_lifetime_spent_max_18,p0_.customer_account_age_days_minAScustomer_account_age_days_min_19,p0_.customer_account_age_days_maxAScustomer_account_age_days_max_20,p0_.y_offertASy_offert_21,p0_.meta_titleASmeta_title_22,p0_.meta_keywordASmeta_keyword_23,p0_.meta_descriptionASmeta_description_24,p0_.produit_offert_idASproduit_offert_id_25FROMpromotionp0_LEFT JOINpromotion_produitp2_ONp0_.id=p2_.promotion_idLEFT JOINproduitp1_ONp1_.id=p2_.produit_idLEFT JOINpromotion_categoriep4_ONp0_.id=p4_.promotion_idLEFT JOINcategoriec3_ONc3_.id=p4_.categorie_idWHEREp0_.visible=?AND ((p0_.date_fin>=?ORp0_.date_finISNULL)) AND ((p0_.date_debut<=?ORp0_.date_debutISNULL)) AND ((p0_.date_fin>=?ORp0_.date_finISNULL)) AND ((p0_.date_debut<=?ORp0_.date_debutISNULL)) AND (((p1_.id=?) OR (c3_.idIN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) ANDc3_.idISNOTNULL))) AND ((p0_.montant_minISNULLORp0_.montant_min<=?)) AND (NOT (EXISTS (SELECT1ASsclr_26FROMpromotionp5_INNER JOINpromotion_produit_excludep7_ONp5_.id=p7_.promotion_idINNER JOINproduitp6_ONp6_.id=p7_.produit_idWHEREp5_.id=p0_.idAND ((p6_.id=?ORp6_.id=?))))) AND (NOT (EXISTS (SELECT1ASsclr_27FROMpromotionp8_INNER JOINpromotion_categorie_excludep10_ONp8_.id=p10_.promotion_idINNER JOINcategoriec9_ONc9_.id=p10_.categorie_idINNER JOINcategorie_produitc11_ON (c11_.categorie_id=c9_.idAND (c11_.produit_id=?ORc11_.produit_id=?)) WHEREp8_.id=p0_.id))) ORDER BYp0_.createdDESC
SELECTDISTINCTp0_.idASid_0,p0_.visibleASvisible_1,p0_.pageASpage_2,p0_.createdAScreated_3,p0_.updatedASupdated_4,p0_.date_debutASdate_debut_5,p0_.date_finASdate_fin_6,p0_.titreAStitre_7,p0_.slugASslug_8,p0_.contenuAScontenu_9,p0_.image_nameASimage_name_10,p0_.image_updated_atASimage_updated_at_11,p0_.typageAStypage_12,p0_.montantASmontant_13,p0_.montant_minASmontant_min_14,p0_.customer_order_count_minAScustomer_order_count_min_15,p0_.customer_order_count_maxAScustomer_order_count_max_16,p0_.customer_lifetime_spent_minAScustomer_lifetime_spent_min_17,p0_.customer_lifetime_spent_maxAScustomer_lifetime_spent_max_18,p0_.customer_account_age_days_minAScustomer_account_age_days_min_19,p0_.customer_account_age_days_maxAScustomer_account_age_days_max_20,p0_.y_offertASy_offert_21,p0_.meta_titleASmeta_title_22,p0_.meta_keywordASmeta_keyword_23,p0_.meta_descriptionASmeta_description_24,p0_.produit_offert_idASproduit_offert_id_25FROMpromotionp0_LEFT JOINpromotion_produitp2_ONp0_.id=p2_.promotion_idLEFT JOINproduitp1_ONp1_.id=p2_.produit_idLEFT JOINpromotion_categoriep4_ONp0_.id=p4_.promotion_idLEFT JOINcategoriec3_ONc3_.id=p4_.categorie_idWHEREp0_.visible=?AND (
(
p0_.date_fin>=?ORp0_.date_finISNULL
)
)
AND (
(
p0_.date_debut<=?ORp0_.date_debutISNULL
)
)
AND (
(
p0_.date_fin>=?ORp0_.date_finISNULL
)
)
AND (
(
p0_.date_debut<=?ORp0_.date_debutISNULL
)
)
AND (
(
(p1_.id=?)
OR (
c3_.idIN (
?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?
)
ANDc3_.idISNOTNULL
)
)
)
AND (
(
p0_.montant_minISNULLORp0_.montant_min<=?
)
)
AND (
NOT (
EXISTS (
SELECT1ASsclr_26FROMpromotionp5_INNER JOINpromotion_produit_excludep7_ONp5_.id=p7_.promotion_idINNER JOINproduitp6_ONp6_.id=p7_.produit_idWHEREp5_.id=p0_.idAND (
(
p6_.id=?ORp6_.id=?
)
)
)
)
)
AND (
NOT (
EXISTS (
SELECT1ASsclr_27FROMpromotionp8_INNER JOINpromotion_categorie_excludep10_ONp8_.id=p10_.promotion_idINNER JOINcategoriec9_ONc9_.id=p10_.categorie_idINNER JOINcategorie_produitc11_ON (
c11_.categorie_id=c9_.idAND (
c11_.produit_id=?ORc11_.produit_id=?
)
)
WHEREp8_.id=p0_.id
)
)
)
ORDER BYp0_.createdDESC
SELECTDISTINCTp0_.idASid_0,p0_.visibleASvisible_1,p0_.pageASpage_2,p0_.createdAScreated_3,p0_.updatedASupdated_4,p0_.date_debutASdate_debut_5,p0_.date_finASdate_fin_6,p0_.titreAStitre_7,p0_.slugASslug_8,p0_.contenuAScontenu_9,p0_.image_nameASimage_name_10,p0_.image_updated_atASimage_updated_at_11,p0_.typageAStypage_12,p0_.montantASmontant_13,p0_.montant_minASmontant_min_14,p0_.customer_order_count_minAScustomer_order_count_min_15,p0_.customer_order_count_maxAScustomer_order_count_max_16,p0_.customer_lifetime_spent_minAScustomer_lifetime_spent_min_17,p0_.customer_lifetime_spent_maxAScustomer_lifetime_spent_max_18,p0_.customer_account_age_days_minAScustomer_account_age_days_min_19,p0_.customer_account_age_days_maxAScustomer_account_age_days_max_20,p0_.y_offertASy_offert_21,p0_.meta_titleASmeta_title_22,p0_.meta_keywordASmeta_keyword_23,p0_.meta_descriptionASmeta_description_24,p0_.produit_offert_idASproduit_offert_id_25FROMpromotionp0_LEFT JOINpromotion_produitp2_ONp0_.id=p2_.promotion_idLEFT JOINproduitp1_ONp1_.id=p2_.produit_idLEFT JOINpromotion_categoriep4_ONp0_.id=p4_.promotion_idLEFT JOINcategoriec3_ONc3_.id=p4_.categorie_idWHEREp0_.visible=1AND ((p0_.date_fin>='2026-09-24 16:24:04'ORp0_.date_finISNULL)) AND ((p0_.date_debut<='2026-09-24 16:24:04'ORp0_.date_debutISNULL)) AND ((p0_.date_fin>='2026-09-24 16:24:04'ORp0_.date_finISNULL)) AND ((p0_.date_debut<='2026-09-24 16:24:04'ORp0_.date_debutISNULL)) AND (((p1_.id=684) OR (c3_.idIN (226,229,220,219,218,217,216,215,171,126,116,170,17,154,128,181,133,8,10,134,15,61,163) ANDc3_.idISNOTNULL))) AND ((p0_.montant_minISNULLORp0_.montant_min<=0)) AND (NOT (EXISTS (SELECT1ASsclr_26FROMpromotionp5_INNER JOINpromotion_produit_excludep7_ONp5_.id=p7_.promotion_idINNER JOINproduitp6_ONp6_.id=p7_.produit_idWHEREp5_.id=p0_.idAND ((p6_.id=684ORp6_.id=684))))) AND (NOT (EXISTS (SELECT1ASsclr_27FROMpromotionp8_INNER JOINpromotion_categorie_excludep10_ONp8_.id=p10_.promotion_idINNER JOINcategoriec9_ONc9_.id=p10_.categorie_idINNER JOINcategorie_produitc11_ON (c11_.categorie_id=c9_.idAND (c11_.produit_id=684ORc11_.produit_id=684)) WHEREp8_.id=p0_.id))) ORDER BYp0_.createdDESC;
SELECTDISTINCTp0_.idASid_0,p0_.visibleASvisible_1,p0_.pageASpage_2,p0_.createdAScreated_3,p0_.updatedASupdated_4,p0_.date_debutASdate_debut_5,p0_.date_finASdate_fin_6,p0_.titreAStitre_7,p0_.slugASslug_8,p0_.contenuAScontenu_9,p0_.image_nameASimage_name_10,p0_.image_updated_atASimage_updated_at_11,p0_.typageAStypage_12,p0_.montantASmontant_13,p0_.montant_minASmontant_min_14,p0_.customer_order_count_minAScustomer_order_count_min_15,p0_.customer_order_count_maxAScustomer_order_count_max_16,p0_.customer_lifetime_spent_minAScustomer_lifetime_spent_min_17,p0_.customer_lifetime_spent_maxAScustomer_lifetime_spent_max_18,p0_.customer_account_age_days_minAScustomer_account_age_days_min_19,p0_.customer_account_age_days_maxAScustomer_account_age_days_max_20,p0_.y_offertASy_offert_21,p0_.meta_titleASmeta_title_22,p0_.meta_keywordASmeta_keyword_23,p0_.meta_descriptionASmeta_description_24,p0_.produit_offert_idASproduit_offert_id_25FROMpromotionp0_LEFT JOINpromotion_produitp2_ONp0_.id=p2_.promotion_idLEFT JOINproduitp1_ONp1_.id=p2_.produit_idLEFT JOINpromotion_categoriep4_ONp0_.id=p4_.promotion_idLEFT JOINcategoriec3_ONc3_.id=p4_.categorie_idWHEREp0_.visible=?AND ((p0_.date_fin>=?ORp0_.date_finISNULL)) AND ((p0_.date_debut<=?ORp0_.date_debutISNULL)) AND ((p0_.date_fin>=?ORp0_.date_finISNULL)) AND ((p0_.date_debut<=?ORp0_.date_debutISNULL)) AND (((p1_.id=?) OR (c3_.idIN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) ANDc3_.idISNOTNULL))) AND ((p0_.montant_minISNULLORp0_.montant_min<=?)) AND (NOT (EXISTS (SELECT1ASsclr_26FROMpromotionp5_INNER JOINpromotion_produit_excludep7_ONp5_.id=p7_.promotion_idINNER JOINproduitp6_ONp6_.id=p7_.produit_idWHEREp5_.id=p0_.idAND ((p6_.id=?ORp6_.id=?))))) AND (NOT (EXISTS (SELECT1ASsclr_27FROMpromotionp8_INNER JOINpromotion_categorie_excludep10_ONp8_.id=p10_.promotion_idINNER JOINcategoriec9_ONc9_.id=p10_.categorie_idINNER JOINcategorie_produitc11_ON (c11_.categorie_id=c9_.idAND (c11_.produit_id=?ORc11_.produit_id=?)) WHEREp8_.id=p0_.id))) ORDER BYp0_.createdDESC
SELECTDISTINCTp0_.idASid_0,p0_.visibleASvisible_1,p0_.pageASpage_2,p0_.createdAScreated_3,p0_.updatedASupdated_4,p0_.date_debutASdate_debut_5,p0_.date_finASdate_fin_6,p0_.titreAStitre_7,p0_.slugASslug_8,p0_.contenuAScontenu_9,p0_.image_nameASimage_name_10,p0_.image_updated_atASimage_updated_at_11,p0_.typageAStypage_12,p0_.montantASmontant_13,p0_.montant_minASmontant_min_14,p0_.customer_order_count_minAScustomer_order_count_min_15,p0_.customer_order_count_maxAScustomer_order_count_max_16,p0_.customer_lifetime_spent_minAScustomer_lifetime_spent_min_17,p0_.customer_lifetime_spent_maxAScustomer_lifetime_spent_max_18,p0_.customer_account_age_days_minAScustomer_account_age_days_min_19,p0_.customer_account_age_days_maxAScustomer_account_age_days_max_20,p0_.y_offertASy_offert_21,p0_.meta_titleASmeta_title_22,p0_.meta_keywordASmeta_keyword_23,p0_.meta_descriptionASmeta_description_24,p0_.produit_offert_idASproduit_offert_id_25FROMpromotionp0_LEFT JOINpromotion_produitp2_ONp0_.id=p2_.promotion_idLEFT JOINproduitp1_ONp1_.id=p2_.produit_idLEFT JOINpromotion_categoriep4_ONp0_.id=p4_.promotion_idLEFT JOINcategoriec3_ONc3_.id=p4_.categorie_idWHEREp0_.visible=?AND (
(
p0_.date_fin>=?ORp0_.date_finISNULL
)
)
AND (
(
p0_.date_debut<=?ORp0_.date_debutISNULL
)
)
AND (
(
p0_.date_fin>=?ORp0_.date_finISNULL
)
)
AND (
(
p0_.date_debut<=?ORp0_.date_debutISNULL
)
)
AND (
(
(p1_.id=?)
OR (
c3_.idIN (
?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?
)
ANDc3_.idISNOTNULL
)
)
)
AND (
(
p0_.montant_minISNULLORp0_.montant_min<=?
)
)
AND (
NOT (
EXISTS (
SELECT1ASsclr_26FROMpromotionp5_INNER JOINpromotion_produit_excludep7_ONp5_.id=p7_.promotion_idINNER JOINproduitp6_ONp6_.id=p7_.produit_idWHEREp5_.id=p0_.idAND (
(
p6_.id=?ORp6_.id=?
)
)
)
)
)
AND (
NOT (
EXISTS (
SELECT1ASsclr_27FROMpromotionp8_INNER JOINpromotion_categorie_excludep10_ONp8_.id=p10_.promotion_idINNER JOINcategoriec9_ONc9_.id=p10_.categorie_idINNER JOINcategorie_produitc11_ON (
c11_.categorie_id=c9_.idAND (
c11_.produit_id=?ORc11_.produit_id=?
)
)
WHEREp8_.id=p0_.id
)
)
)
ORDER BYp0_.createdDESC
SELECTDISTINCTp0_.idASid_0,p0_.visibleASvisible_1,p0_.pageASpage_2,p0_.createdAScreated_3,p0_.updatedASupdated_4,p0_.date_debutASdate_debut_5,p0_.date_finASdate_fin_6,p0_.titreAStitre_7,p0_.slugASslug_8,p0_.contenuAScontenu_9,p0_.image_nameASimage_name_10,p0_.image_updated_atASimage_updated_at_11,p0_.typageAStypage_12,p0_.montantASmontant_13,p0_.montant_minASmontant_min_14,p0_.customer_order_count_minAScustomer_order_count_min_15,p0_.customer_order_count_maxAScustomer_order_count_max_16,p0_.customer_lifetime_spent_minAScustomer_lifetime_spent_min_17,p0_.customer_lifetime_spent_maxAScustomer_lifetime_spent_max_18,p0_.customer_account_age_days_minAScustomer_account_age_days_min_19,p0_.customer_account_age_days_maxAScustomer_account_age_days_max_20,p0_.y_offertASy_offert_21,p0_.meta_titleASmeta_title_22,p0_.meta_keywordASmeta_keyword_23,p0_.meta_descriptionASmeta_description_24,p0_.produit_offert_idASproduit_offert_id_25FROMpromotionp0_LEFT JOINpromotion_produitp2_ONp0_.id=p2_.promotion_idLEFT JOINproduitp1_ONp1_.id=p2_.produit_idLEFT JOINpromotion_categoriep4_ONp0_.id=p4_.promotion_idLEFT JOINcategoriec3_ONc3_.id=p4_.categorie_idWHEREp0_.visible=1AND ((p0_.date_fin>='2026-09-24 16:24:04'ORp0_.date_finISNULL)) AND ((p0_.date_debut<='2026-09-24 16:24:04'ORp0_.date_debutISNULL)) AND ((p0_.date_fin>='2026-09-24 16:24:04'ORp0_.date_finISNULL)) AND ((p0_.date_debut<='2026-09-24 16:24:04'ORp0_.date_debutISNULL)) AND (((p1_.id=678) OR (c3_.idIN (226,216,215,214,218,219,217,220,229,142,126,170,154,128,133,8,10,135,15,163) ANDc3_.idISNOTNULL))) AND ((p0_.montant_minISNULLORp0_.montant_min<=0)) AND (NOT (EXISTS (SELECT1ASsclr_26FROMpromotionp5_INNER JOINpromotion_produit_excludep7_ONp5_.id=p7_.promotion_idINNER JOINproduitp6_ONp6_.id=p7_.produit_idWHEREp5_.id=p0_.idAND ((p6_.id=678ORp6_.id=678))))) AND (NOT (EXISTS (SELECT1ASsclr_27FROMpromotionp8_INNER JOINpromotion_categorie_excludep10_ONp8_.id=p10_.promotion_idINNER JOINcategoriec9_ONc9_.id=p10_.categorie_idINNER JOINcategorie_produitc11_ON (c11_.categorie_id=c9_.idAND (c11_.produit_id=678ORc11_.produit_id=678)) WHEREp8_.id=p0_.id))) ORDER BYp0_.createdDESC;
SELECTDISTINCTp0_.idASid_0,p0_.visibleASvisible_1,p0_.pageASpage_2,p0_.createdAScreated_3,p0_.updatedASupdated_4,p0_.date_debutASdate_debut_5,p0_.date_finASdate_fin_6,p0_.titreAStitre_7,p0_.slugASslug_8,p0_.contenuAScontenu_9,p0_.image_nameASimage_name_10,p0_.image_updated_atASimage_updated_at_11,p0_.typageAStypage_12,p0_.montantASmontant_13,p0_.montant_minASmontant_min_14,p0_.customer_order_count_minAScustomer_order_count_min_15,p0_.customer_order_count_maxAScustomer_order_count_max_16,p0_.customer_lifetime_spent_minAScustomer_lifetime_spent_min_17,p0_.customer_lifetime_spent_maxAScustomer_lifetime_spent_max_18,p0_.customer_account_age_days_minAScustomer_account_age_days_min_19,p0_.customer_account_age_days_maxAScustomer_account_age_days_max_20,p0_.y_offertASy_offert_21,p0_.meta_titleASmeta_title_22,p0_.meta_keywordASmeta_keyword_23,p0_.meta_descriptionASmeta_description_24,p0_.produit_offert_idASproduit_offert_id_25FROMpromotionp0_LEFT JOINpromotion_produitp2_ONp0_.id=p2_.promotion_idLEFT JOINproduitp1_ONp1_.id=p2_.produit_idLEFT JOINpromotion_categoriep4_ONp0_.id=p4_.promotion_idLEFT JOINcategoriec3_ONc3_.id=p4_.categorie_idWHEREp0_.visible=?AND ((p0_.date_fin>=?ORp0_.date_finISNULL)) AND ((p0_.date_debut<=?ORp0_.date_debutISNULL)) AND ((p0_.date_fin>=?ORp0_.date_finISNULL)) AND ((p0_.date_debut<=?ORp0_.date_debutISNULL)) AND (((p1_.id=?) OR (c3_.idIN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) ANDc3_.idISNOTNULL))) AND ((p0_.montant_minISNULLORp0_.montant_min<=?)) AND (NOT (EXISTS (SELECT1ASsclr_26FROMpromotionp5_INNER JOINpromotion_produit_excludep7_ONp5_.id=p7_.promotion_idINNER JOINproduitp6_ONp6_.id=p7_.produit_idWHEREp5_.id=p0_.idAND ((p6_.id=?ORp6_.id=?))))) AND (NOT (EXISTS (SELECT1ASsclr_27FROMpromotionp8_INNER JOINpromotion_categorie_excludep10_ONp8_.id=p10_.promotion_idINNER JOINcategoriec9_ONc9_.id=p10_.categorie_idINNER JOINcategorie_produitc11_ON (c11_.categorie_id=c9_.idAND (c11_.produit_id=?ORc11_.produit_id=?)) WHEREp8_.id=p0_.id))) ORDER BYp0_.createdDESC
SELECTDISTINCTp0_.idASid_0,p0_.visibleASvisible_1,p0_.pageASpage_2,p0_.createdAScreated_3,p0_.updatedASupdated_4,p0_.date_debutASdate_debut_5,p0_.date_finASdate_fin_6,p0_.titreAStitre_7,p0_.slugASslug_8,p0_.contenuAScontenu_9,p0_.image_nameASimage_name_10,p0_.image_updated_atASimage_updated_at_11,p0_.typageAStypage_12,p0_.montantASmontant_13,p0_.montant_minASmontant_min_14,p0_.customer_order_count_minAScustomer_order_count_min_15,p0_.customer_order_count_maxAScustomer_order_count_max_16,p0_.customer_lifetime_spent_minAScustomer_lifetime_spent_min_17,p0_.customer_lifetime_spent_maxAScustomer_lifetime_spent_max_18,p0_.customer_account_age_days_minAScustomer_account_age_days_min_19,p0_.customer_account_age_days_maxAScustomer_account_age_days_max_20,p0_.y_offertASy_offert_21,p0_.meta_titleASmeta_title_22,p0_.meta_keywordASmeta_keyword_23,p0_.meta_descriptionASmeta_description_24,p0_.produit_offert_idASproduit_offert_id_25FROMpromotionp0_LEFT JOINpromotion_produitp2_ONp0_.id=p2_.promotion_idLEFT JOINproduitp1_ONp1_.id=p2_.produit_idLEFT JOINpromotion_categoriep4_ONp0_.id=p4_.promotion_idLEFT JOINcategoriec3_ONc3_.id=p4_.categorie_idWHEREp0_.visible=?AND (
(
p0_.date_fin>=?ORp0_.date_finISNULL
)
)
AND (
(
p0_.date_debut<=?ORp0_.date_debutISNULL
)
)
AND (
(
p0_.date_fin>=?ORp0_.date_finISNULL
)
)
AND (
(
p0_.date_debut<=?ORp0_.date_debutISNULL
)
)
AND (
(
(p1_.id=?)
OR (
c3_.idIN (
?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?
)
ANDc3_.idISNOTNULL
)
)
)
AND (
(
p0_.montant_minISNULLORp0_.montant_min<=?
)
)
AND (
NOT (
EXISTS (
SELECT1ASsclr_26FROMpromotionp5_INNER JOINpromotion_produit_excludep7_ONp5_.id=p7_.promotion_idINNER JOINproduitp6_ONp6_.id=p7_.produit_idWHEREp5_.id=p0_.idAND (
(
p6_.id=?ORp6_.id=?
)
)
)
)
)
AND (
NOT (
EXISTS (
SELECT1ASsclr_27FROMpromotionp8_INNER JOINpromotion_categorie_excludep10_ONp8_.id=p10_.promotion_idINNER JOINcategoriec9_ONc9_.id=p10_.categorie_idINNER JOINcategorie_produitc11_ON (
c11_.categorie_id=c9_.idAND (
c11_.produit_id=?ORc11_.produit_id=?
)
)
WHEREp8_.id=p0_.id
)
)
)
ORDER BYp0_.createdDESC
SELECTDISTINCTp0_.idASid_0,p0_.visibleASvisible_1,p0_.pageASpage_2,p0_.createdAScreated_3,p0_.updatedASupdated_4,p0_.date_debutASdate_debut_5,p0_.date_finASdate_fin_6,p0_.titreAStitre_7,p0_.slugASslug_8,p0_.contenuAScontenu_9,p0_.image_nameASimage_name_10,p0_.image_updated_atASimage_updated_at_11,p0_.typageAStypage_12,p0_.montantASmontant_13,p0_.montant_minASmontant_min_14,p0_.customer_order_count_minAScustomer_order_count_min_15,p0_.customer_order_count_maxAScustomer_order_count_max_16,p0_.customer_lifetime_spent_minAScustomer_lifetime_spent_min_17,p0_.customer_lifetime_spent_maxAScustomer_lifetime_spent_max_18,p0_.customer_account_age_days_minAScustomer_account_age_days_min_19,p0_.customer_account_age_days_maxAScustomer_account_age_days_max_20,p0_.y_offertASy_offert_21,p0_.meta_titleASmeta_title_22,p0_.meta_keywordASmeta_keyword_23,p0_.meta_descriptionASmeta_description_24,p0_.produit_offert_idASproduit_offert_id_25FROMpromotionp0_LEFT JOINpromotion_produitp2_ONp0_.id=p2_.promotion_idLEFT JOINproduitp1_ONp1_.id=p2_.produit_idLEFT JOINpromotion_categoriep4_ONp0_.id=p4_.promotion_idLEFT JOINcategoriec3_ONc3_.id=p4_.categorie_idWHEREp0_.visible=1AND ((p0_.date_fin>='2026-09-24 16:24:04'ORp0_.date_finISNULL)) AND ((p0_.date_debut<='2026-09-24 16:24:04'ORp0_.date_debutISNULL)) AND ((p0_.date_fin>='2026-09-24 16:24:04'ORp0_.date_finISNULL)) AND ((p0_.date_debut<='2026-09-24 16:24:04'ORp0_.date_debutISNULL)) AND (((p1_.id=677) OR (c3_.idIN (226,216,215,214,218,219,220,229,217,170,142,126,128,133,8,10,135,15,163) ANDc3_.idISNOTNULL))) AND ((p0_.montant_minISNULLORp0_.montant_min<=0)) AND (NOT (EXISTS (SELECT1ASsclr_26FROMpromotionp5_INNER JOINpromotion_produit_excludep7_ONp5_.id=p7_.promotion_idINNER JOINproduitp6_ONp6_.id=p7_.produit_idWHEREp5_.id=p0_.idAND ((p6_.id=677ORp6_.id=677))))) AND (NOT (EXISTS (SELECT1ASsclr_27FROMpromotionp8_INNER JOINpromotion_categorie_excludep10_ONp8_.id=p10_.promotion_idINNER JOINcategoriec9_ONc9_.id=p10_.categorie_idINNER JOINcategorie_produitc11_ON (c11_.categorie_id=c9_.idAND (c11_.produit_id=677ORc11_.produit_id=677)) WHEREp8_.id=p0_.id))) ORDER BYp0_.createdDESC;
SELECTDISTINCTp0_.idASid_0,p0_.visibleASvisible_1,p0_.pageASpage_2,p0_.createdAScreated_3,p0_.updatedASupdated_4,p0_.date_debutASdate_debut_5,p0_.date_finASdate_fin_6,p0_.titreAStitre_7,p0_.slugASslug_8,p0_.contenuAScontenu_9,p0_.image_nameASimage_name_10,p0_.image_updated_atASimage_updated_at_11,p0_.typageAStypage_12,p0_.montantASmontant_13,p0_.montant_minASmontant_min_14,p0_.customer_order_count_minAScustomer_order_count_min_15,p0_.customer_order_count_maxAScustomer_order_count_max_16,p0_.customer_lifetime_spent_minAScustomer_lifetime_spent_min_17,p0_.customer_lifetime_spent_maxAScustomer_lifetime_spent_max_18,p0_.customer_account_age_days_minAScustomer_account_age_days_min_19,p0_.customer_account_age_days_maxAScustomer_account_age_days_max_20,p0_.y_offertASy_offert_21,p0_.meta_titleASmeta_title_22,p0_.meta_keywordASmeta_keyword_23,p0_.meta_descriptionASmeta_description_24,p0_.produit_offert_idASproduit_offert_id_25FROMpromotionp0_LEFT JOINpromotion_produitp2_ONp0_.id=p2_.promotion_idLEFT JOINproduitp1_ONp1_.id=p2_.produit_idLEFT JOINpromotion_categoriep4_ONp0_.id=p4_.promotion_idLEFT JOINcategoriec3_ONc3_.id=p4_.categorie_idWHEREp0_.visible=?AND ((p0_.date_fin>=?ORp0_.date_finISNULL)) AND ((p0_.date_debut<=?ORp0_.date_debutISNULL)) AND ((p0_.date_fin>=?ORp0_.date_finISNULL)) AND ((p0_.date_debut<=?ORp0_.date_debutISNULL)) AND (((p1_.id=?) OR (c3_.idIN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) ANDc3_.idISNOTNULL))) AND ((p0_.montant_minISNULLORp0_.montant_min<=?)) AND (NOT (EXISTS (SELECT1ASsclr_26FROMpromotionp5_INNER JOINpromotion_produit_excludep7_ONp5_.id=p7_.promotion_idINNER JOINproduitp6_ONp6_.id=p7_.produit_idWHEREp5_.id=p0_.idAND ((p6_.id=?ORp6_.id=?))))) AND (NOT (EXISTS (SELECT1ASsclr_27FROMpromotionp8_INNER JOINpromotion_categorie_excludep10_ONp8_.id=p10_.promotion_idINNER JOINcategoriec9_ONc9_.id=p10_.categorie_idINNER JOINcategorie_produitc11_ON (c11_.categorie_id=c9_.idAND (c11_.produit_id=?ORc11_.produit_id=?)) WHEREp8_.id=p0_.id))) ORDER BYp0_.createdDESC
SELECTDISTINCTp0_.idASid_0,p0_.visibleASvisible_1,p0_.pageASpage_2,p0_.createdAScreated_3,p0_.updatedASupdated_4,p0_.date_debutASdate_debut_5,p0_.date_finASdate_fin_6,p0_.titreAStitre_7,p0_.slugASslug_8,p0_.contenuAScontenu_9,p0_.image_nameASimage_name_10,p0_.image_updated_atASimage_updated_at_11,p0_.typageAStypage_12,p0_.montantASmontant_13,p0_.montant_minASmontant_min_14,p0_.customer_order_count_minAScustomer_order_count_min_15,p0_.customer_order_count_maxAScustomer_order_count_max_16,p0_.customer_lifetime_spent_minAScustomer_lifetime_spent_min_17,p0_.customer_lifetime_spent_maxAScustomer_lifetime_spent_max_18,p0_.customer_account_age_days_minAScustomer_account_age_days_min_19,p0_.customer_account_age_days_maxAScustomer_account_age_days_max_20,p0_.y_offertASy_offert_21,p0_.meta_titleASmeta_title_22,p0_.meta_keywordASmeta_keyword_23,p0_.meta_descriptionASmeta_description_24,p0_.produit_offert_idASproduit_offert_id_25FROMpromotionp0_LEFT JOINpromotion_produitp2_ONp0_.id=p2_.promotion_idLEFT JOINproduitp1_ONp1_.id=p2_.produit_idLEFT JOINpromotion_categoriep4_ONp0_.id=p4_.promotion_idLEFT JOINcategoriec3_ONc3_.id=p4_.categorie_idWHEREp0_.visible=?AND (
(
p0_.date_fin>=?ORp0_.date_finISNULL
)
)
AND (
(
p0_.date_debut<=?ORp0_.date_debutISNULL
)
)
AND (
(
p0_.date_fin>=?ORp0_.date_finISNULL
)
)
AND (
(
p0_.date_debut<=?ORp0_.date_debutISNULL
)
)
AND (
(
(p1_.id=?)
OR (
c3_.idIN (
?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?
)
ANDc3_.idISNOTNULL
)
)
)
AND (
(
p0_.montant_minISNULLORp0_.montant_min<=?
)
)
AND (
NOT (
EXISTS (
SELECT1ASsclr_26FROMpromotionp5_INNER JOINpromotion_produit_excludep7_ONp5_.id=p7_.promotion_idINNER JOINproduitp6_ONp6_.id=p7_.produit_idWHEREp5_.id=p0_.idAND (
(
p6_.id=?ORp6_.id=?
)
)
)
)
)
AND (
NOT (
EXISTS (
SELECT1ASsclr_27FROMpromotionp8_INNER JOINpromotion_categorie_excludep10_ONp8_.id=p10_.promotion_idINNER JOINcategoriec9_ONc9_.id=p10_.categorie_idINNER JOINcategorie_produitc11_ON (
c11_.categorie_id=c9_.idAND (
c11_.produit_id=?ORc11_.produit_id=?
)
)
WHEREp8_.id=p0_.id
)
)
)
ORDER BYp0_.createdDESC
SELECTDISTINCTp0_.idASid_0,p0_.visibleASvisible_1,p0_.pageASpage_2,p0_.createdAScreated_3,p0_.updatedASupdated_4,p0_.date_debutASdate_debut_5,p0_.date_finASdate_fin_6,p0_.titreAStitre_7,p0_.slugASslug_8,p0_.contenuAScontenu_9,p0_.image_nameASimage_name_10,p0_.image_updated_atASimage_updated_at_11,p0_.typageAStypage_12,p0_.montantASmontant_13,p0_.montant_minASmontant_min_14,p0_.customer_order_count_minAScustomer_order_count_min_15,p0_.customer_order_count_maxAScustomer_order_count_max_16,p0_.customer_lifetime_spent_minAScustomer_lifetime_spent_min_17,p0_.customer_lifetime_spent_maxAScustomer_lifetime_spent_max_18,p0_.customer_account_age_days_minAScustomer_account_age_days_min_19,p0_.customer_account_age_days_maxAScustomer_account_age_days_max_20,p0_.y_offertASy_offert_21,p0_.meta_titleASmeta_title_22,p0_.meta_keywordASmeta_keyword_23,p0_.meta_descriptionASmeta_description_24,p0_.produit_offert_idASproduit_offert_id_25FROMpromotionp0_LEFT JOINpromotion_produitp2_ONp0_.id=p2_.promotion_idLEFT JOINproduitp1_ONp1_.id=p2_.produit_idLEFT JOINpromotion_categoriep4_ONp0_.id=p4_.promotion_idLEFT JOINcategoriec3_ONc3_.id=p4_.categorie_idWHEREp0_.visible=1AND ((p0_.date_fin>='2026-09-24 16:24:04'ORp0_.date_finISNULL)) AND ((p0_.date_debut<='2026-09-24 16:24:04'ORp0_.date_debutISNULL)) AND ((p0_.date_fin>='2026-09-24 16:24:04'ORp0_.date_finISNULL)) AND ((p0_.date_debut<='2026-09-24 16:24:04'ORp0_.date_debutISNULL)) AND (((p1_.id=675) OR (c3_.idIN (226,216,217,218,215,219,220,229,116,126,17,143,128,133,8,135,10,15,61,163) ANDc3_.idISNOTNULL))) AND ((p0_.montant_minISNULLORp0_.montant_min<=0)) AND (NOT (EXISTS (SELECT1ASsclr_26FROMpromotionp5_INNER JOINpromotion_produit_excludep7_ONp5_.id=p7_.promotion_idINNER JOINproduitp6_ONp6_.id=p7_.produit_idWHEREp5_.id=p0_.idAND ((p6_.id=675ORp6_.id=675))))) AND (NOT (EXISTS (SELECT1ASsclr_27FROMpromotionp8_INNER JOINpromotion_categorie_excludep10_ONp8_.id=p10_.promotion_idINNER JOINcategoriec9_ONc9_.id=p10_.categorie_idINNER JOINcategorie_produitc11_ON (c11_.categorie_id=c9_.idAND (c11_.produit_id=675ORc11_.produit_id=675)) WHEREp8_.id=p0_.id))) ORDER BYp0_.createdDESC;
SELECTDISTINCTp0_.idASid_0,p0_.visibleASvisible_1,p0_.pageASpage_2,p0_.createdAScreated_3,p0_.updatedASupdated_4,p0_.date_debutASdate_debut_5,p0_.date_finASdate_fin_6,p0_.titreAStitre_7,p0_.slugASslug_8,p0_.contenuAScontenu_9,p0_.image_nameASimage_name_10,p0_.image_updated_atASimage_updated_at_11,p0_.typageAStypage_12,p0_.montantASmontant_13,p0_.montant_minASmontant_min_14,p0_.customer_order_count_minAScustomer_order_count_min_15,p0_.customer_order_count_maxAScustomer_order_count_max_16,p0_.customer_lifetime_spent_minAScustomer_lifetime_spent_min_17,p0_.customer_lifetime_spent_maxAScustomer_lifetime_spent_max_18,p0_.customer_account_age_days_minAScustomer_account_age_days_min_19,p0_.customer_account_age_days_maxAScustomer_account_age_days_max_20,p0_.y_offertASy_offert_21,p0_.meta_titleASmeta_title_22,p0_.meta_keywordASmeta_keyword_23,p0_.meta_descriptionASmeta_description_24,p0_.produit_offert_idASproduit_offert_id_25FROMpromotionp0_LEFT JOINpromotion_produitp2_ONp0_.id=p2_.promotion_idLEFT JOINproduitp1_ONp1_.id=p2_.produit_idLEFT JOINpromotion_categoriep4_ONp0_.id=p4_.promotion_idLEFT JOINcategoriec3_ONc3_.id=p4_.categorie_idWHEREp0_.visible=?AND ((p0_.date_fin>=?ORp0_.date_finISNULL)) AND ((p0_.date_debut<=?ORp0_.date_debutISNULL)) AND ((p0_.date_fin>=?ORp0_.date_finISNULL)) AND ((p0_.date_debut<=?ORp0_.date_debutISNULL)) AND (((p1_.id=?) OR (c3_.idIN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) ANDc3_.idISNOTNULL))) AND ((p0_.montant_minISNULLORp0_.montant_min<=?)) AND (NOT (EXISTS (SELECT1ASsclr_26FROMpromotionp5_INNER JOINpromotion_produit_excludep7_ONp5_.id=p7_.promotion_idINNER JOINproduitp6_ONp6_.id=p7_.produit_idWHEREp5_.id=p0_.idAND ((p6_.id=?ORp6_.id=?))))) AND (NOT (EXISTS (SELECT1ASsclr_27FROMpromotionp8_INNER JOINpromotion_categorie_excludep10_ONp8_.id=p10_.promotion_idINNER JOINcategoriec9_ONc9_.id=p10_.categorie_idINNER JOINcategorie_produitc11_ON (c11_.categorie_id=c9_.idAND (c11_.produit_id=?ORc11_.produit_id=?)) WHEREp8_.id=p0_.id))) ORDER BYp0_.createdDESC
SELECTDISTINCTp0_.idASid_0,p0_.visibleASvisible_1,p0_.pageASpage_2,p0_.createdAScreated_3,p0_.updatedASupdated_4,p0_.date_debutASdate_debut_5,p0_.date_finASdate_fin_6,p0_.titreAStitre_7,p0_.slugASslug_8,p0_.contenuAScontenu_9,p0_.image_nameASimage_name_10,p0_.image_updated_atASimage_updated_at_11,p0_.typageAStypage_12,p0_.montantASmontant_13,p0_.montant_minASmontant_min_14,p0_.customer_order_count_minAScustomer_order_count_min_15,p0_.customer_order_count_maxAScustomer_order_count_max_16,p0_.customer_lifetime_spent_minAScustomer_lifetime_spent_min_17,p0_.customer_lifetime_spent_maxAScustomer_lifetime_spent_max_18,p0_.customer_account_age_days_minAScustomer_account_age_days_min_19,p0_.customer_account_age_days_maxAScustomer_account_age_days_max_20,p0_.y_offertASy_offert_21,p0_.meta_titleASmeta_title_22,p0_.meta_keywordASmeta_keyword_23,p0_.meta_descriptionASmeta_description_24,p0_.produit_offert_idASproduit_offert_id_25FROMpromotionp0_LEFT JOINpromotion_produitp2_ONp0_.id=p2_.promotion_idLEFT JOINproduitp1_ONp1_.id=p2_.produit_idLEFT JOINpromotion_categoriep4_ONp0_.id=p4_.promotion_idLEFT JOINcategoriec3_ONc3_.id=p4_.categorie_idWHEREp0_.visible=?AND (
(
p0_.date_fin>=?ORp0_.date_finISNULL
)
)
AND (
(
p0_.date_debut<=?ORp0_.date_debutISNULL
)
)
AND (
(
p0_.date_fin>=?ORp0_.date_finISNULL
)
)
AND (
(
p0_.date_debut<=?ORp0_.date_debutISNULL
)
)
AND (
(
(p1_.id=?)
OR (
c3_.idIN (
?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?
)
ANDc3_.idISNOTNULL
)
)
)
AND (
(
p0_.montant_minISNULLORp0_.montant_min<=?
)
)
AND (
NOT (
EXISTS (
SELECT1ASsclr_26FROMpromotionp5_INNER JOINpromotion_produit_excludep7_ONp5_.id=p7_.promotion_idINNER JOINproduitp6_ONp6_.id=p7_.produit_idWHEREp5_.id=p0_.idAND (
(
p6_.id=?ORp6_.id=?
)
)
)
)
)
AND (
NOT (
EXISTS (
SELECT1ASsclr_27FROMpromotionp8_INNER JOINpromotion_categorie_excludep10_ONp8_.id=p10_.promotion_idINNER JOINcategoriec9_ONc9_.id=p10_.categorie_idINNER JOINcategorie_produitc11_ON (
c11_.categorie_id=c9_.idAND (
c11_.produit_id=?ORc11_.produit_id=?
)
)
WHEREp8_.id=p0_.id
)
)
)
ORDER BYp0_.createdDESC
SELECTDISTINCTp0_.idASid_0,p0_.visibleASvisible_1,p0_.pageASpage_2,p0_.createdAScreated_3,p0_.updatedASupdated_4,p0_.date_debutASdate_debut_5,p0_.date_finASdate_fin_6,p0_.titreAStitre_7,p0_.slugASslug_8,p0_.contenuAScontenu_9,p0_.image_nameASimage_name_10,p0_.image_updated_atASimage_updated_at_11,p0_.typageAStypage_12,p0_.montantASmontant_13,p0_.montant_minASmontant_min_14,p0_.customer_order_count_minAScustomer_order_count_min_15,p0_.customer_order_count_maxAScustomer_order_count_max_16,p0_.customer_lifetime_spent_minAScustomer_lifetime_spent_min_17,p0_.customer_lifetime_spent_maxAScustomer_lifetime_spent_max_18,p0_.customer_account_age_days_minAScustomer_account_age_days_min_19,p0_.customer_account_age_days_maxAScustomer_account_age_days_max_20,p0_.y_offertASy_offert_21,p0_.meta_titleASmeta_title_22,p0_.meta_keywordASmeta_keyword_23,p0_.meta_descriptionASmeta_description_24,p0_.produit_offert_idASproduit_offert_id_25FROMpromotionp0_LEFT JOINpromotion_produitp2_ONp0_.id=p2_.promotion_idLEFT JOINproduitp1_ONp1_.id=p2_.produit_idLEFT JOINpromotion_categoriep4_ONp0_.id=p4_.promotion_idLEFT JOINcategoriec3_ONc3_.id=p4_.categorie_idWHEREp0_.visible=1AND ((p0_.date_fin>='2026-09-24 16:24:04'ORp0_.date_finISNULL)) AND ((p0_.date_debut<='2026-09-24 16:24:04'ORp0_.date_debutISNULL)) AND ((p0_.date_fin>='2026-09-24 16:24:04'ORp0_.date_finISNULL)) AND ((p0_.date_debut<='2026-09-24 16:24:04'ORp0_.date_debutISNULL)) AND (((p1_.id=672) OR (c3_.idIN (226,229,220,219,218,217,216,116,126,154,17,133,128,8,10,15,61,163) ANDc3_.idISNOTNULL))) AND ((p0_.montant_minISNULLORp0_.montant_min<=0)) AND (NOT (EXISTS (SELECT1ASsclr_26FROMpromotionp5_INNER JOINpromotion_produit_excludep7_ONp5_.id=p7_.promotion_idINNER JOINproduitp6_ONp6_.id=p7_.produit_idWHEREp5_.id=p0_.idAND ((p6_.id=672ORp6_.id=672))))) AND (NOT (EXISTS (SELECT1ASsclr_27FROMpromotionp8_INNER JOINpromotion_categorie_excludep10_ONp8_.id=p10_.promotion_idINNER JOINcategoriec9_ONc9_.id=p10_.categorie_idINNER JOINcategorie_produitc11_ON (c11_.categorie_id=c9_.idAND (c11_.produit_id=672ORc11_.produit_id=672)) WHEREp8_.id=p0_.id))) ORDER BYp0_.createdDESC;