SELECT search, page, SUM(views) as hits FROM wvgazette
where types like '%content' and page != 200711210014 and page not like '%page 2%'
and time >= '2008-12-03 21:31:38' and time <= '2008-12-04 21:31:38'
group by page order by hits DESC
LIMIT 7 page