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

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