select*from(select DATE_FORMAT(now(),'%m.%d') setime from dual
unionallselect DATE_FORMAT(DATE_SUB(CURDATE(),INTERVAL1DAY),'%m.%d') setime from dual
unionallselect DATE_FORMAT(DATE_SUB(CURDATE(),INTERVAL2DAY),'%m.%d') setime from dual
unionallselect DATE_FORMAT(DATE_SUB(CURDATE(),INTERVAL3DAY),'%m.%d') setime from dual
unionallselect DATE_FORMAT(DATE_SUB(CURDATE(),INTERVAL4DAY),'%m.%d') setime from dual
unionallselect DATE_FORMAT(DATE_SUB(CURDATE(),INTERVAL5DAY),'%m.%d') setime from dual
unionallselect DATE_FORMAT(DATE_SUB(CURDATE(),INTERVAL6DAY),'%m.%d') setime from dual
) t leftjoin...