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-05-09' and '2025-05-14'
and t.termin_id in (170066927,170080001,170060705,170068204,170071010,170073027,170074512,170069240,170076822,170070058,170056636,170053782,170073962,170060703,170058333,170068082,170069804,170076146,170049343,170074517,170082787,170056635,170069469,170049342,170067436,170066173,170071519,170061045,170061477,170081273,170069807,170081636,170074906,170047671,170086641,170083350,170056630,170074514,170056631,170059815,170067165,170067435,170057692,170083344,170082789,170076816,170072786,170073409,170079356,170071512,170072787,170053779,170077083,170060335,170068083,170078179,170061044,170073964,170053778,170081637,170071515,170052544,170086640,170057017,170083351,170050106,170062804,170048697,170072027,170059816,170079358,170059218,170085146,170056049,170080728,170074513,170052237,170058329,170069467,170067164,170076819,170074515,170075093,170055234,170065516,170073028,170060334,170073963,170082791,170058328,170083343,170068342,170055490,170077871,170081638,170067162,170070346,170074907,170073029,170082044,170064445,170058332,170075517,170064610,170073969,170076815,170067161,170051717,170061474,170064449,170053783,170077084,170082790,170071516,170076814,170061481,170071514,170067433,170056633,170057016,170076821,170064450,170073031,170070809,170058385,170080949,170080952,170062803,170067160,170063361,170065517,170082565,170082788,170053780,170061471,170069163,170053781,170080950,170079355,170083346,170074516,170057190,170074519,170068343,170078178,170053461,170061476,170058330,170055235,170076820,170061887,170065513,170076497,170061472,170073968,170056637,170049341,170066383,170082564,170056785,170050134,170051472,170056638,170079362,170082792,170080953,170075816,170064451,170071520,170060702,170064454,170051471,170062802,170082043,170066170,170060701,170076818,170059217,170071513,170067159,170058327,170075516,170067439,170078180,170074518,170061480,170079361,170067437,170060704,170061479,170064453,170067434,170069805,170076817,170058589,170070808,170077082,170067163,170079360,170073967,170080729,170080951,170058331,170071518,170083345,170064452,170069806,170056634,170054861,170079357,170067438,170066174,170065518,170079359,170060336,170073966,170051473,170073410,170062805,170060700,170061475,170059219,170064611,170066172,170061473,170055189,170076147,170069165,170069164,170071517,170080002,170056735,170051716,170075320,170067440,170048698,170073030,170073965,170052238,170077872,170055491,170062138,170069468,170065515,170075319,170059935,170054860,170055190,170061478,170063570,170066171,170065514,170070928,170052545) 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'