|
|
MYSQL ERROR: Unknown column 'terms.film' in 'on clause' Q: SELECT film.id as filmid, film.name_cz as filmname, film.name_original, film.director, film_categories.name_cz as category, `terms`.`id` AS `tid`, `terms`.*, `cinemas`.`nazev` AS `cname`, `halls`.`nazev_cz` AS `hname`, block.id AS blockid, block.name_cz AS blockname FROM `terms`, `cinemas`, `halls` LEFT JOIN film ON (film.id_volume=14 AND terms.film = film.id) LEFT JOIN film_categories ON film.id_category = film_categories.id LEFT JOIN block ON terms.block = block.id WHERE `cinemas`.`id` = `terms`.`kino` AND `halls`.`id` = `terms`.`hala` AND (block.id IS NOT NULL OR film.id IS NOT NULL) AND `terms`.`mesic` = 3 AND `terms`.`den` = 23 ORDER BY `mesic`, `den`,`cname`,halls.id,`zacatek_hodina`, `zacatek_minuta` soubor:/home/httpd/html/gng-web/febiofest/14_archive/admin_new/inc/functions.inc.phpradek: 35 | |