SELECT filme.* views.*, categories.*, count(*) from filme, views, categories 
WHERE views.FilmFkey = filme.FilmPkey AND filme.CategoryFkey = categories.CategoryPkey 
AND views.DateViewed > DATE_SUB( CURDATE( ) , INTERVAL 1 DAY) 
GROUP BY FilmFkey ORDER BY count(*) DESC