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-17' and '2025-05-21'
and t.termin_id in (170118011,170125180,170101566,170117876,169990089,170124836,170105274,170124443,170108646,170118320,170108648,170125743,170123322,170117879,170124831,170130416,170122320,170111100,170118316,170096606,170124702,170103274,170101564,170107715,170105162,170118317,170124839,170095565,170131461,170127280,170101568,170125037,169990092,170124284,170124563,170126468,170101956,170097996,170120969,170107103,170124286,170105270,170130075,170126413,170122315,170126407,170103273,170124823,170124453,170125741,170097998,170097423,170120975,170111103,170101961,170123285,170120001,170096615,170132013,170124291,170118105,170095561,170097932,170110874,170124562,170110873,170095564,170120972,170126911,170129438,170124340,170132010,170127071,170124820,170107096,170122314,170130337,170124832,170124452,170095007,170124282,170129215,170125179,170125195,170124281,170118104,170124280,170104191,170121185,170116619,170131100,170129563,170123290,170116621,170095010,170132016,170131460,170097934,170107671,170097422,170131101,170124833,170124822,170129719,169990093,170121337,170130338,170123288,170126470,170124701,170124837,170125046,170089222,170124838,170101952,170097936,170108647,170116622,170111102,170111099,170105160,170132011,170125038,170103518,170104190,170130076,170103516,170098004,170120391,170125034,170122047,170131095,170105277,170122048,170117877,170124343,170107753,170110876,170131471,170126469,170124570,170118319,170131462,170125032,170131838,170089221,170110875,170096607,170121181,170124706,170095563,170124703,170129722,170119360,170132012,170101960,170101560,170111105,170107674,170120976,170126467,170105161,170123289,170124700,170124567,170124835,170126408,170111107,170104193,170129586,170119358,170097935,170120002,170124285,170118049,170124444,170131099,170131096,170122049,170096611,170120387,170107095,170100463,170129336,170125044,170095011,170097420,170126909,170131459,170119356,170124294,170122319,170124559,170125045,170111101,170103270,170126409,170110609,170130078,170127289,170124451,170124440,170125040,170125740,169990090,170124566,170105660,170124289,170107109,170120034,170108227,170111108,170124344,170124705,170127288,170129333,170126915,170120973,170129440,170129335,170129218,170131841,170125193,170117880,170105269,170097995,170101557,170125194,170095566,170107669,170122045,170119359,170116618,170124834,170108943,170132015,170126908,170125183,170118036,170105662,170129331,170095009,170127073,170107672,170124290,170124346,170120392,170124707,170124711,170127074,170129219,170129332,170107108,170130077,170120390,170124840,170121340,170131842,170129334,170089224,170127075,170124708,170107785,170103519,170108228,170103517,170100465,170130417,170130079,170120946,170126914,170126906,170105163,170124293,170126410,170126472,170124292,170125043,170100464,170124824,170120389,170103271,170118110,170096616,170129921,170120004,170107107,170129439,170126913,170107673,170121339,170126471,170089223,170124345,170107755,170124568,170129587,170111104,170121183,170130339,170104192,170126912,170121184,170108942,170107094,170110608,170101569,170125192,170125042,170122316,170124569,170126466,170125742,170097421,170111106,170107106,170129562,170126476,170125041,170129651,170125182,170132017,170131463,170129920,170110612,170126910,169990091,170120974,170097997,170097444,170117878,170116620,170131840,170125191,170132014,170105273,170101957,170118318,170124288,170107754,170108226,170129217,170103272,170129723,170108974,170125039,170124565,170124442,170125190,170124704,170120340,170131843,170095562,170108941,170101567,170124450,170129437,170105167,170127287,170124564,170129718,170126475,170125189,170108645,170121338,170108225,170100466,170129216,170121182,170125036,170124441,170119357,170122046,170097933,170118050,170107105,170124821,170125035,170124283,170124342,170125181,170129918,170120971,170131839,170105661,170107752,170095560,170129561,170120970,170101565,170107104,170118103,170124449,170096612,170126907,170124561,170107670,170127286,170101955,170129330,170089220,170108644,170095559,170120003,170108224,170125188,170104189,170110872,170125033,170129717,170124560,170120339,170121336,170124341,170095005,170096610,170095008,170124287,170129919,170127072,170131097,170095006,170120388,170095004) 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'