Meilleures offres

select distinct(cr.id_cart_rule), cr.*, crpr.type, crprv.id_item from aw_cart_rule cr left join aw_cart_rule_product_rule_group crprg on(crprg.id_cart_rule=cr.id_cart_rule) left join aw_cart_rule_product_rule crpr on(crpr.id_product_rule_group=crprg.id_product_rule_group) left join aw_cart_rule_product_rule_value crprv on(crpr.id_product_rule=crprv.id_product_rule) where cr.active=1 and ( (crpr.type="categories" and crprv.id_item=511) ) and ( cr.description!="" or cr.id_cart_rule=9836) and cr.date_from < "2022-05-18 14:24:35" and cr.date_to > "2022-05-18 14:24:35" order by cr.afficher_compteur desc, crpr.type desc 1