SELECT

t.kino_name,
t.kino_name_sort,
t.kino_bezirk,
t.kino_id,
t.termin_id,
t.basis_id,
t.film_id,
t.leinwand_name,
t.kinoheld_url


FROM kalender_termine t
where
t.datum_anzeige between '2024-05-30' and '2024-06-05'
and t.termin_id in (167625603,167624405,167624855,167624406,167611167,167599399,167619259,167627363,167600634,167624404,167600632,167612420,167627806,167624399,167604898,167611168,167624851,167624410,167624407,167604871,167624857,167627807,167600633,167627362,167624411,167624852,167627804,167599400,167615936,167627306,167600635,167612456,167611169,167627530,167624408,167627805,167624856,167612455,167627305,167624850,167612363,167624853,167624403,167624402,167624409,167611197,167612419,167624398,167624400,167624401,167624854,167612227,167397818,167612648,167595365,167627285,167624256,167612328,167595361,167611189,167593915,167624257,167591800,167627283,167612327,167624254,167625681,167629053,167626025,167627282,167595360,167624263,167593910,167609492,167593916,167615962,167624261,167612326,167627774,167611190,167612586,167624260,167624259,167624258,167624262,167593911,167612443,167593913,167626288,167595364,167627281,167612329,167595363,167593912,167593914,167612324,167624762,167624255,167612325,167595362,167627284) and (
t.fassung in('OmeU','Omdt+englU','EnglF','Omfrz+englU','FranzmenglU','EnglmdtU','Omdt+englU','Omengl+spanU','OV/OmeU')
or
( t.fassung in('OmU','OV') and f.ist_engl = 1 )
)
and t.kino_id in(677,531,640,4418517,518,158756075,158652363,120495740,43655193,120903995,138298993,120898947,120904850,573,561,616,4059065,65755259,831,610,613,617,26245648,703,794,594,506,600,817,595,507,139115800,563,614,727,930379,588,828,159032779,3138320,685,3308890,27722768,159032776,690,5177115,167341712,86558852,68181750,158652367,660,797,90722560,674,114793025,576,523,159032782,155235885,29833136,28701456,730,575,137006144,662,555,557,612,166346226,119545449,144091321,25708450,841,93269125,564,89682602,578,86408737,128344994,143899714,597,158652382,103863367,7389583,153365274,3049896,26843043,746,1799766,579,684,664,545,46394920,143898876,166780406,120902788,13390458,27383768,568,160169337,628,560,731,69826983,136560904,29686640,135037060,598,569,5652079,37791196,709)
and t.status='aktiv'

Fehler: Unknown column 'f.ist_engl' in 'where clause'