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 '2024-11-11' and '2024-11-13'
and t.termin_id in (168684447,168703277,168706106,168695175,168559955,168706597,168666155,168706102,168675457,168684491,168710496,168698010,168704220,168706302,168687144,168693288,168706299,168711680,168706303,168691996,168704221,168703885,168703893,168703894,168704787,168686964,168680049,168706596,168706301,168703711,168703883,168705251,168703710,168705253,168706105,168705956,168691995,168706300,168680051,168706103,168703884,168666156,168711875,168703712,168705957,168666154,168691997,168677180,168706104,168675456,168684490,168705252,168680050,168677179,168710266,168705955,168698151,168706595,168684489,168704219,168703892,168713799,168680486,168693289,168706101,168675455,168702933,168697530,168709291,168695129,168709543,168702894,168709278,168712392,168697531,168663940,168684497,168560155,168712391,168687000,168702726,168699269,168709542,168711310,168689375,168706587,168683793,168705050,168691378,168712557,168705948,168666010,168703647,168683799,168709283,168708307,168706088,168705945,168705222,168698690,168706087,168705621,168673429,168707640,168713292,168710738,168666017,168666005,168695074,168706084,168709282,168690481,168675426,168705567,168682505,168694793,168705405,168697829,168703642,168711311,168697941,168706081,168708306,168666025,168696874,168674778,168711610,168690482,168679885,168705619,168694794,168701640,168705407,168707144,168697883,168705648,168707652,168686271,168690480,168698107,168705804,168674850,168666016,168675176,168705946,168666003,168711822,168708363,168705220,168697940,168673422,168705651,168674868,168702699,168683791,168696363,168705802,168693184,168680501,168711816,168711317,168693177,168680425,168699889,168705647,168702701,168706286,168711931,168705565,168712574,168699895,168705051,168674852,168706588,168698036,168709173,168666011,168701633,168691377,168705623,168673421,168706288,168705649,168712558,168713294,168674867,168666024,168689376,168698662,168674779,168701630,168666015,168686274,168697525,168699894,168674851,168673423,168701634,168706080,168705943,168690997,168703640,168706082,168680423,168706584,168680508,168683800,168710610,168686272,168682930,168707143,168674780,168683798,168666004,168713766,168708362,168675178,168713762,168696364,168713290,168673746,168705624,168706287,168711817,168713293,168689379,168695085,168675364,168698689,168705403,168705404,168708308,168713291,168707142,168682929,168705620,168711814,168706285,168708130,168686275,168705944,168706284,168694797,168706086,168698661,168697399,168693185,168697526,168711611,168674777,168703648,168708132,168675428,168666026,168680424,168711932,168682506,168680502,168697884,168709918,168674782,168706272,168698691,168673430,168712575,168698663,168708133,168673750,168696875,168709174,168689380,168676989,168710250,168675427,168679887,168691379,168695077,168708361,168674781,168705406,168683792,168693179,168705947,168705803,168710505,168711563,168695076,168686276,168706085,168705622,168680500,168706586,168673747,168675425,168705566,168696907,168710504,168689378,168705799,168686273,168675177,168674853,168676988,168710609,168707526,168710503,168679886,168702700,168703641,168680499,168693178,168706083,168705801,168706585,168694792,168689377,168695075,168713767,168710249,168711935,168704192,168682494,168708131,168706271,168709917,168704519,168690996,168705800,168710608,168698035,168675363,168711815,168673428,168666009,168707525,168680507,168706583,168705049,168705402,168713289,168695084,168686270,168676987,168706270,168711562,168705650,168704515,168690998,168704516,168697942,168710248,168705221,168707639,168706283,168707527) 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,828,159032779,3138320,685,3308890,27722768,159032776,690,5177115,167341712,86558852,68181750,158652367,660,797,90722560,674,114793025,576,523,159032782,155235885,167893195,29833136,28701456,730,575,137006144,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'