SELECT * , DATE_FORMAT( FROM_UNIXTIME( startdate ) , '%m %Y' ) AS qrymy FROM `my_table` WHERE qrymy = '05 2007' AND active =1 ORDER BY startdate DESC LIMIT 0 , 30