rendered paste body$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