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) and dt>='2010-03-10' limit 8 10.03.2010