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