kpb

Strona chwilowo niedostępna. Przepraszamy i zapraszamy później

repertuar

Access denied for user 'admin81_69'@'94.152.8.11' (using password: YES)
SELECT repertuar.* , IF (doc_title IS NOT NULL , doc_title, tytul) doc_title, IF (doc_header IS NOT NULL , doc_header, opis) doc_header, IF ((data_premiery < CURDATE() - INTERVAL 7 DAY) ,'N','Y') premiera, preview, documents.adnotation, (SELECT MIN(DATA ) FROM baza81_61.repertuar AS rep WHERE 1 =1 AND rep.ID_film =films.film_id AND ID_kino = '3') AS first, -- (SELECT MIN(data) -- FROM baza81_61.repertuar -- WHERE 1=1 -- AND baza81_61.repertuar.ID_film=baza81_61.film.ID_film -- AND ID_kino='3') AS first, films.doc_id, films.film_id, films.film_show FROM (SELECT DISTINCT tytul, film.id_film, IF (f.film_premiere_date IS NOT NULL AND f.film_premiere_date != '0000-00-00', film_premiere_date, data_premiery) data_premiery, opis, id_kino, nazwa_pliku_zdj_80, nazwa_pliku_zdj_150 FROM baza81_61.repertuar LEFT JOIN baza81_61.film ON(repertuar.id_film = film.id_film) LEFT JOIN baza81_61.link_zdj ON(link_zdj.id_film = film.id_film) LEFT JOIN baza81_69.films AS f ON(f.film_id=repertuar.id_film) WHERE 1=1 AND repertuar.Data >= CURDATE() AND id_kino='3' ) repertuar LEFT JOIN baza81_69.films ON(films.film_id=repertuar.id_film) LEFT JOIN baza81_69.documents ON(films.doc_id=documents.doc_id) WHERE 1=1 AND repertuar.id_kino='3' AND id_kino = 'id_kino' ORDER BY tytul