1 2 3 4
SELECT FilmID,count(FilmID),films.Name FROM `hits` WHERE DateHit > "2009-02-27 17:06:34" INNER JOIN mc.films ON hits.FilmID = films.ID GROUP BY FilmID