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-04-29' and '2024-05-01'
and t.termin_id in (167365747,167365746,167357484,167346320,167365405,167376518,167371936,167365406,167364277,167364273,167366337,167378082,167371937,167356752,167371554,167367512,167361116,167380019,167364274,167367513,167350809,167376517,167352334,167351044,167356958,167372654,167343113,167364279,167364278,167357899,167372652,167371084,167360561,167366338,167346835,167351891,167360822,167351778,167353483,167352299,167375332,167343114,167346602,167372653,167375046,167361696,167375912,167368440,167380022,167361389,167371555,167366564,167380292,167374109,167363312,167378079,167375335,167352617,167361936,167352805,167346832,167351779,167375911,167363313,167365743,167344118,167365065,167346598,167365069,167365772,167345608,167343269,167363472,167375045,167377286,167375331,167352335) 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,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'