Kan de onderstaande query niet uitvoeren.
  select filename, film_titel, film_titels.film_id, view_date, cijfer, review, filmlog.user_id,filmlog.filmlog_id from filmlog, film_titels left join film_posters on film_posters.film_id=film_titels.film_id and poster_type='0' left join sneakpoints on sneakpoints.user_id='1864' and sneakpoints.film_id=filmlog.film_id left join filmlog_review on filmlog_review.filmlog_id=filmlog.filmlog_id where filmlog.user_id='1864' and filmlog.film_id=film_titels.film_id order by view_date desc, film_titel limit 5
MySQL Error: Unknown column 'filmlog.film_id' in 'on clause'