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-03-13' and '2026-03-18'
and t.termin_id in (172080616,172092480,171989731,172112027,172092542,172116521,172080615,172092479,172116520,172115870,172082141,172109590,172110537,172088945,172116320,172036968,172101565,172111734,172111693,171940793,172116220,172103093,172092712,172092658,172113178,172033160,172113176,172105292,172114388,172111997,172109860,172109669,172109977,172114547,172103090,172116539,171995161,172114387,172105301,172092409,172111751,172103094,172101724,172113390,172092672,172103092,172113388,172105300,172080608,172092711,172033158,172091719,172109861,172037757,172092709,172092708,172109975,172109974,171995158,172031834,172092729,172116543,172033156,172093607,172091721,172111686,172101569,172031828,172109976,172109859,172080606,172109866,172037742,172037741,171995159,172109864,172101568,172109670,172113177,172092657,172081583,172109665,171995160,172109863,172080605,172112009,172109668,172093608,172092671,172091718,172113313,172037758,172033161,172111792,172111747,172092728,172109978,172104096,172109865,172114548,172113391,172081584,172080607,172091720,172116542,172109667,172103095,172092519,172033159,172111791,172113389,172105302,172092710,172087739,172116200,172037743,172111790,172037759,172109862,172033157,172110011,172101725,172103091,172109666,172111687,172091537,172081837,172101416,172091538,172092250,172031825,172092251,172114649,172082117,172092511,172092763,172093547,172082178,172111654,172116296,172037002,172101418,172092249,172103278) 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'