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 (170065481,170071307,170065479,170049886,170048573,170075298,170065761,170050311,170056026,170060348,170061288,170052128,170065765,170057000,170050832,170074421,170056999,170064404,170049889,170066137,170080672,170071304,170079219,170052127,170075460,170071991,170065477,170064403,170059820,170060346,170060347,170075299,170057530,170066132,170059821,170066138,170071310,170056018,170070558,170074423,170052129,170063062,170075705,170074424,170065762,170048569,170067651,170052524,170071309,170067488,170081533,170056641,170076416,170073349,170050308,170051467,170061292,170071305,170050309,170059087,170061844,170066135,170073079,170062721,170074825,170074425,170066989,170050310,170048568,170057531,170049223,170066136,170055570,170076417,170065764,170066993,170051704,170067487,170080671,170050836,170059918,170074824,170072727,170073347,170060668,170049883,170050827,170064396,170050307,170049222,170065480,170075132,170066141,170073078,170051466,170082623,170061289,170073077,170046770,170051465,170054118,170061058,170064398,170050312,170082622,170052520,170052529,170049885,170082624,170055569,170048567,170066990,170046771,170049882,170065767,170079220,170079823,170075300,170082626,170049890,170049887,170065763,170082621,170073076,170073348,170062636,170048572,170050835,170049884,170055568,170048571,170068548,170073080,170076697,170069472,170066140,170048570,170072728,170070559,170073904,170065760,170067652,170064858,170052523,170074419,170073082,170048574,170066142,170057533,170050837,170086631,170056023,170071303,170065476,170075459,170086633,170052522,170065766,170066992,170082625,170056025,170064399,170069112,170066139,170066991,170069473,170057532,170078561,170052521,170074420,170073081,170064401,170050833,170071308,170049888,170050834,170061291,170056024,170052518,170066134,170052525,170086634,170061059,170054899,170074422,170056019,170061290,170052530,170065478,170075462,170064402,170056642,170054119,170075461,170057172,170051705,170068549,170066133,170064859,170050828,170062722,170059088,170079824,170063063,170081270,170071306,170060669,170073905,170064397,170063281,170062061,170086632,170066988,170068547) 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'