SELECT * FROM t_promos WHERE promo_statut = 1 AND ( promo_date_fin IS NULL OR promo_date_fin = '' OR promo_date_fin = '0000-00-00' OR (promo_date_fin IS NOT NULL AND promo_date_fin >= CURDATE()) )

Incorrect DATE value: ''