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-03' limit 8 03.09.2010