Someone

$sql = 	" SELECT * FROM views, filme, categories " . 
		" WHERE views.FilmFkey = filme.FilmPkey AND filme.CategoryFkey = categories.CategoryPkey " .
		" AND views.DateViewed > DATE_SUB( CURDATE( ) , INTERVAL 1 DAY) " .
		" GROUP BY views.FilmFkey DESC";



SELECTfilme.* 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