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-27' and '2024-05-01'
and t.termin_id in (167346838,167365282,167373175,167368302,167350298,167372114,167347163,167351267,167378054,167373868,167354648,167363169,167365532,167368192,167339403,167350297,167364234,167340765,167349166,167365281,167343036,167340767,167373429,167379637,167359398,167364160,167367553,167363246,167378990,167366445,167378457,167376673,167352247,167366089,167371098,167363168,167357534,167363821,167335155,167361724,167375015,167370460,167364673,167378991,167372081,167373423,167349175,167365093,167358600,167373681,167366095,167372613,167371571,167339110,167339109,167349167,167375012,167365657,167373430,167357541,167339111,167349734,167370004,167350594,167370459,167288150,167365218,167364675,167356981,167347919,167373683,167358601,167378634,167373179,167380949,167380952,167373180,167364233,167365655,167372305,167347164,167366098,167347697,167372080,167355298,167344677,167344674,167367551,167362288,167366097,167379640,167373171,167367120,167378053,167379639,167343037,167370118,167360572,167371574,167377389,167356979,167370458,167367548,167366092,167362778,167379641,167367549,167378056,167380631,167380950,167362991,167370117,167379636,167366096,167375630,167349177,167373172,167378319,167365654,167350448,167379530,167350296,167335154,167343035,167349728,167352941,167375686,167350591,167205466,167340763,167373162,167377568,167372082,167375687,167378988,167349179,167381038,167375445,167372614,167356977,167359397,167370457,167372611,167360230,167205464,167343034,167364674,167357538,167365656,167370116,167358285,167365530,167367547,167364157,167357539,167350592,167371573,167378989,167380951,167364677,167378632,167366090,167375683,167376040,167364156,167363247,167378635,167349180,167373181,167367546,167377390,167355299,167372307,167201585,167360573,167339404,167375444,167378633,167362291,167375324,167351270,167357535,167371101,167342215,167373164,167351271,167375627,167366454,167362292,167351949,167379531,167343057,167365531,167351366,167344675,167369154,167370461,167347165,167363641,167349729,167377391,167347698,167340769,167350593,167201586,167346792,167376902,167364676,167339107,167367550,167361726,167357540,167380231,167372084,167349730,167349174,167376143,167358602,167377659,167349733,167349732,167356980,167351948,167380948,167373173,167378282,167378439,167379642,167366444,167373176,167363789,167349178,167364159,167361725,167376901,167375325,167362290,167377624,167365283,167378284,167290291,167350586,167343058,167366091,167354649,167370005,167373432,167349731,167351269,167373686,167375685,167371570,167378529,167375013,167371572,167373685,167378283,167373177,167347921,167373178,167363642,167370896,167372308,167375548,167350786,167344676,167364158,167361722,167372083,167350325,167373431,167375629,167371100,167360231,167379532,167373174,167340761,167350585,167351340,167351268,167205465,167350324,167347920,167375684,167356978,167351417,167379647,167376672,167370003,167372612,167362289,167375628,167339108,167379638,167357537,167353214,167351365,167367119,167361723,167376142,167379644,167367552,167373426,167378440,167376144,167346791,167349176,167380230,167357536,167373684,167365091,167373163,167375014,167379643,167378879,167372304) 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'