mon compte
SELECT `product_promo`.*FROM (`product_promo`)WHERE `product_promo`.`status` = "active" AND product_promo.type = "global" AND ( date_start IS NULL || date_start <= "2012-05-19" ) AND ( date_end IS NULL || date_end >= "2012-05-19" ) AND ( code = "" || ( code = "" ) )LIMIT 1