SELECT distinct DATE_FORMAT(dt,'%d.%m') as dt,DAYNAME(dt) as dname FROM tt_dhead_1 WHERE siteid IN (1801, 1802, 1803, 1804, 1805, 1806, 1807) and dt>='2010-09-09' limit 8 09.09.2010
