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 '2026-06-18' and '2026-06-24'
and t.termin_id in (172726801,172470631,172733881,172715065,172647264,172715280,172703943,172705076,172730438,172730437,172730439,172715282,172715281,172729739,172730436,172724540,172730550,172710508,172711695,172706009,172730544,172710320,172712888,172729097,172706007,172714521,172699323,172712260,172649239,172729092,172730545,172711729,172712583,172735930,172712263,172737217,172725705,172721400,172734829,172725183,172704568,172712392,172723528,172711033,172732048,172730548,172734831,172722218,172724281,172706010,172724278,172722040,172728204,172719978,172705395,172706690,172717478,172733549,172733630,172714197,172649444,172724283,172705048,172722221,172725707,172722631,172720947,172733632,172722211,172735929,172717243,172712259,172714918,172732188,172717479,172723993,172724282,172708382,172706688,172713572,172720183,172704574,172724285,172734731,172724279,172725708,172703380,172720179,172728560,172712890,172702971,172734732,172713726,172724538,172729095,172726716,172726554,172712467,172649445,172724536,172728203,172715578,172722226,172727105,172706008,172733136,172725184,172735928,172734832,172729094,172711326,172722225,172726253,172698776,172720871,172710849,172730221,172519869,172732848,172712466,172730222,172719252,172732189,172720532,172710514,172727064,172711693,172710516,172720180,172734734,172711733,172704573,172719253,172720182,172722210,172735355,172711730,172712894,172730224,172721527,172720872,172737220,172726717,172722227,172733135,172713360,172714520,172715159,172734733,172730546,172711732,172731261,172719644,172727746,172733137,172713730,172730223,172719975,172715576,172717211,172730547,172711731,172713724,172729100,172724280,172704570,172713727,172710846,172722212,172729336,172713731,172728706,172712582,172724535,172720178,172705047,172718338,172649447,172720531,172715577,172723529,172726715,172709222,172723065,172735931,172732047,172732844,172711323,172714196,172734297,172718339,172725776,172721341,172705394,172712261,172709223,172726910,172737218,172734830,172723066,172710515,172734833,172713358,172711694,172710513,172737221,172731146,172649448,172735783,172713359,172737219,172729093,172711691,172712891,172726219,172730549,172718337,172726525,172709444,172712886,172731085,172733631,172723531,172710321,172719979,172710850,172710847,172730225,172725706,172722222,172736236,172703048,172711696,172706689,172722217,172713362,172731551,172726913,172737222,172704569,172729096,172734346,172724284,172728202,172713361,172724539,172707746,172710845,172712258,172722219,172731147,172712262,172704572,172734730,172726909,172712391,172720181,172710512,172712889,172710848,172713725,172736824,172720873,172649446,172703379,172710507,172712895,172724537,172718602,172722220,172723530,172704571,172722215,172710511,172712887,172727232,172713573,172708381,172728707,172732845,172713574,172721528,172711692,172730220,172722216,172732404,172711032,172728201,172717275,172728662,172703628,172723443,172733574,172718276,172703775,172709370,172694186,172731504,172703671,172728663,172703776,172715089,172563540,172703672,172704046,172718279,172735247,172734553,172703774,172731503,172704004,172726649,172703773,172718278,172732914,172703777,172703673,172704045,172703627,172703674,172694185,172718277,172694184,172715084,172736685,172718275,172561716,172703626,172715085,172703670,172715088,172715087,172703778,172703630,172735248,172726694,172718273,172714751,172703625,172724114,172734437,172703669,172715086,172733573,172710590,172703668,172703631,172718274,172735249,172704002,172736684,172715083,172704003,172563541,172703772,172704001,172694187,172723444,172703629,172714752,172704000,172734554) 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,107373420,828,159032779,3138320,685,3308890,27722768,159032776,690,5177115,167341712,86558852,68181750,158652367,660,797,90722560,674,114793025,576,523,159032782,19373191,155235885,167893195,29833136,28701456,730,575,137006144,806,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'