select adid, sum(views) as lista, sum(clicks) as szczegoly from dbo.Day where klientid=250247 and date > '2013-01-18' group by adid order by 2 desc