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 (167374823,167357836,167345829,167365950,167352638,167355136,167344869,167356057,167365874,167371976,167356439,167355509,167354816,167354527,167354528,167367415,167359967,167346248,167365949,167359970,167357835,167354210,167358159,167351572,167348524,167360765,167344619,167369996,167359966,167379022,167367424,167353906,167344621,167346535,167375867,167358493,167348509,167345289,167366931,167354198,167359964,167346931,167366925,167368502,167344607,167368162,167359965,167345262,167356908,167344620,167346540,167369754,167366636,167377172,167354197,167354525,167361895,167358172,167377170,167355832,167359216,167360770,167346534,167362509,167350183,167357374,167357833,167357358,167376549,167376465,167344321,167344858,167369314,167345564,167379017,167367416,167355489,167346242,167355135,167374520,167355151,167345568,167366889,167368675,167355506,167350826,167354516,167359971,167344322,167356895,167369998,167369249,167375865,167371462,167378008,167357834,167354538,167344606,167361614,167346926,167360767,167354209,167345279,167380557,167374835,167350167,167364954,167376472,167364941,167375951,167364538,167362500,167358171,167346538,167358158,167360517,167362099,167361618,167380558,167346249,167348202,167365948,167367420,167362511,167362101,167357367,167347604,167371456,167367951,167344346,167364546,167358502,167375862,167371459,167374824,167347591,167352159,167364942,167364540,167355490,167377169,167362512,167368515,167359805,167359191,167376234,167358170,167346920,167352998,167358157,167354813,167345839,167362735,167378013,167344870,167376238,167371974,167374332,167364963,167379002,167364940,167347603,167360202,167363601,167350836,167343304,167380550,167350181,167366929,167366403,167370033,167374821,167356916,167359193,167371041,167371980,167344338,167367425,167353908,167372467,167360768,167357844,167349473,167374836,167371884,167356708,167375870,167360201,167359213,167371038,167356058,167345277,167374519,167345570,167372418,167354800,167353907,167376550,167366930,167360764,167347905,167374219,167379012,167367399,167358156,167346940,167355831,167359969,167346231,167378003,167365951,167350169,167364956,167357359,167345847,167369896,167348510,167366927,167361903,167344884,167358173,167355830,167351558,167345828,167371455,167374839,167359811,167366404,167376237,167371471,167377174,167344859,167374509,167345582,167368233,167350195,167371470,167353076,167380549,167375863,167375413,167364965,167361044,167348526,167357360,167371975,167344873,167371042,167374226,167367410,167348511,167361904,167347589,167346935,167376311,167347594,167376309,167371146,167347606,167354199,167359194,167371144,167345280,167354802,167374335,167378015,167345815,167369315,167343424,167352639,167352999,167374220,167377171,167359551,167346932,167377173,167375412,167351559,167376467,167347593,167354817,167344608,167350185,167348231,167367397,167348525,167356059,167344320,167371981,167353160,167354529,167371675,167354801,167371463,167357357,167347592,167364533,167347889,167369533,167345257,167359215,167379016,167360769,167353161,167345842,167378998,167355508,167367409,167365844,167358494,167347605,167360776,167371676,167374510,167356709,167361043,167355507,167356442,167374225,167350184,167354815,167345269,167347906,167364537,167354515,167362510,167375411,167364534,167349474,167356894,167369997,167344883,167343715,167361617,167374822,167347897,167345268,167379001,167346930,167361337,167357845,167361615,167359806,167378014,167355148,167346230,167343303,167360200,167366928,167364536,167353342,167365843,167345263,167359968,167360516,167348523,167347892,167354526,167355829,167356441,167351571,167361042,167378009,167369250,167362100,167374838,167361894,167348522,167379015,167348230,167346232,167374837,167356056,167361616,167367421,167371454,167354514,167346927,167364961,167362508,167356438,167375947,167361338,167355150,167367408,167356055,167347590,167350168,167364955,167356440,167369532,167379014,167376466,167346235,167362495,167356437,167356054,167350825,167366926,167361624,167360766,167361041,167368862,167361619,167354211,167355828,167359212,167360515,167346548,167363600,167344881,167354814,167356053,167343423,167356707,167359192,167355134,167351557,167367414,167376473,167371674,167368514,167355504,167368232,167369072,167346551,167345561,167343714,167354208,167353341,167368941,167371979,167347904,167359550,167355505,167353075,167366924,167356706,167363599,167355149,167375082,167369753,167362507,167362742,167369524,167346941,167376242,167375861,167371878,167371883,167350194,167371469,167359217,167354530,167367403,167350182,167364539,167357375,167348533,167355827,167359214,167345814,167376310,167358501,167369995,167349475,167375083,167369531,167357366,167364535,167361620,167345571,167379013,167361625,167374592,167370201,167360097,167357679,167368596,167344303,167359649,167361170,167345313,167370908,167348324,167355935,167361770,167361172,167371169,167361432,167376917,167348325,167365114,167357956,167351438,167362715,167357677,167349929,167361169,167354330,167360865,167357954,167366395,167346557,167367142,167351439,167353367,167361768,167356555,167352455,167367134,167359647,167355934,167358988,167345552,167360366,167360866,167344987,167358349,167362304,167380328,167375697,167371704,167357083,167354331,167360363,167369165,167380413,167356232,167344304,167380330,167365113,167344644,167360096,167345312,167346276,167360364,167364290,167361769,167360589,167377884,167371168,167374590,167379219,167371172,167360867,167354058,167380412,167365112,167368595,167358989,167358986,167360365,167352199,167375702,167354943,167357082,167354057,167376157,167351440,167349587,167354056,167379221,167361431,167358985,167344645,167368594,167364292,167371706,167367140,167357957,167377885,167344646,167356554,167374593,167375436,167361433,167367135,167380329,167362716,167354329,167358350,167345316,167346277,167371705,167345543,167369910,167352200,167362303,167369976,167346565,167376329,167361171,167357081,167354672,167355363,167364291,167347943,167344988,167347414,167356233,167353813,167359876,167349586,167349928,167345793,167371173,167363879,167379220,167374591,167376918,167369909,167357080,167357678,167355362,167354671,167371162,167371165,167371157,167349585,167353812,167359875,167361960,167345792,167354942,167362302,167345551,167348323,167356553,167349927,167360095,167370526,167346996,167376326,167371699,167343758,167363878,167369908,167357079,167367133,167376158,167354944,167346275,167371161,167367141,167377878,167345794,167347413,167346562,167357955,167376919,167346999,167358987,167344302,167366862,167359648,167377883) 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'