SELECT * FROM promos WHERE ( (record_date_start<='2010-02-09' AND record_date_end>='2010-02-09') ) AND record_status>=5 AND record_location='0' ORDER BY rand()