SELECT * from ps_cart_rule join ps_cart_rule_lang crl on crl.id_cart_rule = ps_cart_rule.id_cart_rule where date_to < DATE(NOW() - INTERVAL 3 DAY) and crl.name like '%relance Panier%'ok