SELECT FilmID count FilmID films Name FROM hits WHERE DateHit 2009-02-

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