Kan de onderstaande query niet uitvoeren.
  select boxoffice.*, filename,film_titel from boxoffice, film_titels left join film_posters on film_posters.film_id=boxoffice.film_id and poster_type='0' where boxoffice.film_id=film_titels.film_id and box_type='0' order by start_date desc, place limit 10
MySQL Error: Unknown column 'boxoffice.film_id' in 'on clause'