Anonymous
public text v1 · immutableSELECT * , 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 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