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 (167346838,167368302,167350298,167372114,167365532,167364234,167340765,167343036,167340767,167364160,167367553,167378990,167366445,167376673,167371098,167335155,167361724,167375015,167370460,167378991,167373681,167366095,167372613,167339110,167339109,167349167,167365657,167357541,167339111,167349734,167370004,167350594,167288150,167365218,167364675,167356981,167378634,167373179,167380952,167373180,167364233,167372305,167366098,167344677,167379640,167367120,167379639,167343037,167370118,167371574,167356979,167367548,167366092,167379641,167367549,167378056,167380631,167380950,167366096,167375630,167343035,167352941,167375686,167205466,167373162,167372082,167375687,167349179,167381038,167375445,167372614,167357538,167365656,167357539,167371573,167380951,167364677,167376040,167378635,167349180,167373181,167377390,167355299,167360573,167339404,167375444,167362291,167351270,167342215,167373164,167351271,167366454,167362292,167351949,167365531,167351366,167369154,167370461,167347165,167377391,167347698,167340769,167350593,167376902,167364676,167367550,167361726,167357540,167380231,167372084,167349730,167376143,167358602,167377659,167349733,167349732,167356980,167351948,167379642,167363789,167349178,167364159,167361725,167375325,167362290,167377624,167365283,167378284,167290291,167350586,167343058,167366091,167354649,167370005,167373432,167349731,167351269,167373686,167375685,167378529,167371572,167373685,167378283,167373177,167347921,167373178,167363642,167370896,167372308,167375548,167350786,167344676,167364158,167372083,167350325,167373431,167375629,167371100,167360231,167379532,167351340,167379644,167373426,167378440,167365091,167373163,167375014,167379643,167378879) 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'