SELECTCURDATE()-INTERVAL(a.a +(10* b.a)+(100* c.a))DAYAS date
FROM(SELECT0AS a UNIONALLSELECT1UNIONALLSELECT2UNIONALLSELECT3UNIONALLSELECT4UNIONALLSELECT5UNIONALLSELECT6UNIONALLSELECT7UNIONALLSELECT8UNIONALLSELECT9)AS a
CROSSJOIN(SELECT0AS a UNIONALLSELECT1UNIONALLSELECT2UNIONALLSELECT3UNIONALLSELECT4UNIONALLSELECT5UNIONALLSELECT6UNIONALLSELECT7UNIONALLSELECT8UNIONALLSELECT9)AS b
CROSSJOIN(SELECT0AS a UNIONALLSELECT1UNIONALLSELECT2UNIONALLSELECT3UNIONALLSELECT4UNIONALLSELECT5UNIONALLSELECT6UNIONALLSELECT7UNIONALLSELECT8UNIONALLSELECT9)AS c
HAVING date >=DATE_SUB(CURDATE(),INTERVAL30DAY)AND date <=CURDATE()ORDERBY date DESC