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-21' and '2024-05-29'
and t.termin_id in (167522607,167506454,167495953,167518940,167525030,167495768,167525862,167512445,167516472,167490774,167488520,167510414,167521359,167522606,167499352,167489987,167489900,167526231,167507680,167522951,167514223,167494454,167522952,167504389,167526233,167504386,167518781,167509621,167515880,167524943,167505786,167519618,167510742,167525855,167523196,167516373,167503775,167493218,167494333,167521998,167493219,167503239,167508323,167489986,167514128,167505796,167510741,167519185,167508324,167506252,167507370,167503774,167526454,167524944,167504387,167497245,167518782,167522291,167500938,167535704,167519471,167525029,167507369,167517428,167524597,167525867,167505132,167506253,167515885,167499667,167518780,167503238,167504256,167492852,167498380,167525949,167507679,167502144,167513096,167497129,167508847,167501391,167505795,167502151,167491259,167505784,167490159,167519186,167525945,167490895,167522290,167509239,167522181,167526453,167497738,167500937,167526759,167499666,167494042,167514352,167515884,167505785,167508052,167513715,167510413,167517943,167499945,167505787,167513786,167490773,167507677,167525430,167510066,167496381,167520628,167523411,167514222,167504384,167497246,167504257,167488519,167506455,167526705,167522605,167494464,167522228,167521999,167496382,167490894,167523417,167497125,167515694,167508848,167495351,167512941,167504385,167521358,167503705,167526706,167525950,167494334,167526760,167526234,167525868,167500379,167495343,167490779,167501590,167494041,167522608,167519617,167512235,167490158,167522182,167512774,167504851,167526232,167525946,167511593,167511594,167518783,167499946,167503706,167515675,167443295,167506679,167499952,167495350,167495344,167517942,167514085,167497739,167518176,167504388,167513426,167523409,167495954,167517384,167502089,167507678,167523418,167513716) 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'