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:59:27'ORp0_.date_finISNULL)) AND ((p0_.date_debut<='2026-09-24 16:59:27'ORp0_.date_debutISNULL)) ORDER BYp0_.date_debutDESCLIMIT1;
SELECTc0_.idASid_0,c0_.ordreASordre_1,c0_.produit_idASproduit_id_2,c0_.categorie_idAScategorie_id_3FROMcategorie_produitc0_INNER JOINproduitp1_ONc0_.produit_id=p1_.idWHEREp1_.visible=?ANDc0_.categorie_id=?ANDc0_.produit_idNOTIN (69) ORDER BYc0_.ordreASC
SELECTc0_.idASid_0,c0_.ordreASordre_1,c0_.produit_idASproduit_id_2,c0_.categorie_idAScategorie_id_3FROMcategorie_produitc0_INNER JOINproduitp1_ONc0_.produit_id=p1_.idWHEREp1_.visible=?ANDc0_.categorie_id=?ANDc0_.produit_idNOTIN (69)
ORDER BYc0_.ordreASC
SELECTc0_.idASid_0,c0_.ordreASordre_1,c0_.produit_idASproduit_id_2,c0_.categorie_idAScategorie_id_3FROMcategorie_produitc0_INNER JOINproduitp1_ONc0_.produit_id=p1_.idWHEREp1_.visible=1ANDc0_.categorie_id=76ANDc0_.produit_idNOTIN (69) ORDER BYc0_.ordreASC;
SELECTp0_.idASid_0,p0_.visibleASvisible_1,p0_.createdAScreated_2,p0_.updatedASupdated_3,p0_.date_debutASdate_debut_4,p0_.date_finASdate_fin_5,p0_.remiseASremise_6FROMpackp0_LEFT JOINpack_produitp2_ONp0_.id=p2_.pack_idLEFT JOINproduitp1_ONp1_.id=p2_.produit_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)) ANDp1_.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:59:27'ORp0_.date_finISNULL)) AND ((p0_.date_debut<='2026-09-24 16:59:27'ORp0_.date_debutISNULL)) AND ((p0_.date_fin>='2026-09-24 16:59:27'ORp0_.date_finISNULL)) AND ((p0_.date_debut<='2026-09-24 16:59:27'ORp0_.date_debutISNULL)) AND (((p1_.id=69) OR (c3_.idIN (76,226,229,220,219,216,218,217,45,58,80,82,196,166,21,162,11,83,2,163,19,5,9,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=69ORp6_.id=69))))) 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=69ORc11_.produit_id=69)) 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:59:27'ORp0_.date_finISNULL)) AND ((p0_.date_debut<='2026-09-24 16:59:27'ORp0_.date_debutISNULL)) AND ((p0_.date_fin>='2026-09-24 16:59:27'ORp0_.date_finISNULL)) AND ((p0_.date_debut<='2026-09-24 16:59:27'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:59:27'ORp0_.date_finISNULL)) AND ((p0_.date_debut<='2026-09-24 16:59:27'ORp0_.date_debutISNULL)) AND ((p0_.date_fin>='2026-09-24 16:59:27'ORp0_.date_finISNULL)) AND ((p0_.date_debut<='2026-09-24 16:59:27'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:59:27'ORp0_.date_finISNULL)) AND ((p0_.date_debut<='2026-09-24 16:59:27'ORp0_.date_debutISNULL)) AND ((p0_.date_fin>='2026-09-24 16:59:27'ORp0_.date_finISNULL)) AND ((p0_.date_debut<='2026-09-24 16:59:27'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:59:27'ORp0_.date_finISNULL)) AND ((p0_.date_debut<='2026-09-24 16:59:27'ORp0_.date_debutISNULL)) AND ((p0_.date_fin>='2026-09-24 16:59:27'ORp0_.date_finISNULL)) AND ((p0_.date_debut<='2026-09-24 16:59:27'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=?) 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:59:27'ORp0_.date_finISNULL)) AND ((p0_.date_debut<='2026-09-24 16:59:27'ORp0_.date_debutISNULL)) AND ((p0_.date_fin>='2026-09-24 16:59:27'ORp0_.date_finISNULL)) AND ((p0_.date_debut<='2026-09-24 16:59:27'ORp0_.date_debutISNULL)) AND (((p1_.id=156) OR (c3_.idIN (76,226,223,229,220,219,218,217,45,166,162,2,11,83,9,163,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=156ORp6_.id=156))))) 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=156ORc11_.produit_id=156)) 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:59:27'ORp0_.date_finISNULL)) AND ((p0_.date_debut<='2026-09-24 16:59:27'ORp0_.date_debutISNULL)) AND ((p0_.date_fin>='2026-09-24 16:59:27'ORp0_.date_finISNULL)) AND ((p0_.date_debut<='2026-09-24 16:59:27'ORp0_.date_debutISNULL)) AND (((p1_.id=155) OR (c3_.idIN (76,226,216,217,218,219,220,229,45,14,30,92,166,162,20,83,9,163,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=155ORp6_.id=155))))) 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=155ORc11_.produit_id=155)) 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:59:27'ORp0_.date_finISNULL)) AND ((p0_.date_debut<='2026-09-24 16:59:27'ORp0_.date_debutISNULL)) AND ((p0_.date_fin>='2026-09-24 16:59:27'ORp0_.date_finISNULL)) AND ((p0_.date_debut<='2026-09-24 16:59:27'ORp0_.date_debutISNULL)) AND (((p1_.id=154) OR (c3_.idIN (76,226,217,218,219,220,229,223,45,171,18,166,162,2,83,163,10,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=154ORp6_.id=154))))) 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=154ORc11_.produit_id=154)) 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:59:27'ORp0_.date_finISNULL)) AND ((p0_.date_debut<='2026-09-24 16:59:27'ORp0_.date_debutISNULL)) AND ((p0_.date_fin>='2026-09-24 16:59:27'ORp0_.date_finISNULL)) AND ((p0_.date_debut<='2026-09-24 16:59:27'ORp0_.date_debutISNULL)) AND (((p1_.id=153) OR (c3_.idIN (76,217,218,226,219,220,229,223,45,118,92,166,162,2,83,11,9,163,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=153ORp6_.id=153))))) 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=153ORc11_.produit_id=153)) 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:59:27'ORp0_.date_finISNULL)) AND ((p0_.date_debut<='2026-09-24 16:59:27'ORp0_.date_debutISNULL)) AND ((p0_.date_fin>='2026-09-24 16:59:27'ORp0_.date_finISNULL)) AND ((p0_.date_debut<='2026-09-24 16:59:27'ORp0_.date_debutISNULL)) AND (((p1_.id=320) OR (c3_.idIN (226,229,220,219,218,217,216,52,204,11,2,9,3,59,60) 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=320ORp6_.id=320))))) 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=320ORc11_.produit_id=320)) 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:59:27'ORp0_.date_finISNULL)) AND ((p0_.date_debut<='2026-09-24 16:59:27'ORp0_.date_debutISNULL)) AND ((p0_.date_fin>='2026-09-24 16:59:27'ORp0_.date_finISNULL)) AND ((p0_.date_debut<='2026-09-24 16:59:27'ORp0_.date_debutISNULL)) AND (((p1_.id=584ORp1_.id=583) OR (c3_.idIN (226,216,217,218,215,229,220,219,117,114,11,82,23,193,83,19,87,4,5,9,2,3,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=584ORp6_.id=583))))) 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=584ORc11_.produit_id=583)) 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:59:27'ORp0_.date_finISNULL)) AND ((p0_.date_debut<='2026-09-24 16:59:27'ORp0_.date_debutISNULL)) AND ((p0_.date_fin>='2026-09-24 16:59:27'ORp0_.date_finISNULL)) AND ((p0_.date_debut<='2026-09-24 16:59:27'ORp0_.date_debutISNULL)) AND (((p1_.id=57) OR (c3_.idIN (63,226,216,217,218,219,220,229,141,140,143,80,43,29,114,58,21,204,135,20,167,11,5,163,4,2,19,9,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=57ORp6_.id=57))))) 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=57ORc11_.produit_id=57)) 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:59:27'ORp0_.date_finISNULL)) AND ((p0_.date_debut<='2026-09-24 16:59:27'ORp0_.date_debutISNULL)) AND ((p0_.date_fin>='2026-09-24 16:59:27'ORp0_.date_finISNULL)) AND ((p0_.date_debut<='2026-09-24 16:59:27'ORp0_.date_debutISNULL)) AND (((p1_.id=158) OR (c3_.idIN (63,226,224,229,220,219,90,43,37,144,135,2,19,10,15,5,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=158ORp6_.id=158))))) 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=158ORc11_.produit_id=158)) 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:59:27'ORp0_.date_finISNULL)) AND ((p0_.date_debut<='2026-09-24 16:59:27'ORp0_.date_debutISNULL)) AND ((p0_.date_fin>='2026-09-24 16:59:27'ORp0_.date_finISNULL)) AND ((p0_.date_debut<='2026-09-24 16:59:27'ORp0_.date_debutISNULL)) AND (((p1_.id=58) OR (c3_.idIN (226,216,217,218,219,220,229,141,140,29,58,80,114,62,21,162,204,20,167,11,163,4,2,19,9,59,3,5) 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=58ORp6_.id=58))))) 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=58ORc11_.produit_id=58)) WHEREp8_.id=p0_.id))) ORDER BYp0_.createdDESC;