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 '2025-07-13' and '2025-07-16'
and t.termin_id in (170489971,170492986,170488124,170424257,170476630,170504302,170503347,170502228,170498967,170503639,170502231,170503351,170486429,170509903,170476728,170503830,170498971,170481979,170509901,170489655,170503834,170503829,170503624,170477085,170486430,170500446,170489653,170498968,170503349,170476730,170504317,170478855,170489652,170486428,170476729,170476604,170489789,170498994,170476602,170424260,170510077,170503622,170482818,170503345,170498993,170476600,170503355,170503637,170511513,170476603,170506351,170494672,170478856,170474955,170503352,170510817,170503835,170476731,170504303,170510079,170503833,170504318,170424259,170498992,170504304,170497083,170504321,170481980,170500441,170503636,170511483,170503634,170482820,170476599,170504322,170476601,170482819,170509904,170503356,170504314,170503625,170497084,170477093,170474958,170503354,170507647,170503831,170494696,170510815,170503635,170503346,170509902,170509103,170504305,170507648,170497091,170504319,170481982,170494673,170489654,170500440,170477090,170503353,170500439,170509104,170510078,170474957,170504320,170509258,170503350,170494827,170474956,170497090,170503832,170498991,170484393,170509102,170424258,170503623,170510816,170503348,170477089,170482817,170501838,170506347,170497089,170504316,170504315,170481983,170503638,170474965,170474973,170489958,170489362,170506271,170484970,170484971,170474964,170509446,170489959,170499166,170503211,170510474,170484969,170489698,170489632,170489957,170478224,170474963,170478225,170510979,170484968,170503506,170510447,170499156) 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'