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 '2026-06-18' and '2026-06-24'
and t.termin_id in (172724540,172730550,172710508,172711695,172706009,172730544,172710320,172712888,172729097,172706007,172714521,172699323,172712260,172649239,172729092,172730545,172711729,172712583,172735930,172712263,172737217,172725705,172721400,172734829,172725183,172704568,172712392,172723528,172711033,172732048,172730548,172734831,172722218,172724281,172706010,172724278,172722040,172728204,172719978,172705395,172706690,172717478,172733549,172733630,172714197,172649444,172724283,172705048,172722221,172725707,172722631,172720947,172733632,172722211,172735929,172717243,172712259,172714918,172732188,172717479,172723993,172724282,172708382,172706688,172713572,172720183,172704574,172724285,172734731,172724279,172725708,172703380,172720179,172728560,172712890,172702971,172734732,172713726,172724538,172729095,172726716,172726554,172712467,172649445,172724536,172728203,172715578,172722226,172727105,172706008,172733136,172725184,172735928,172734832,172729094,172711326,172722225,172726253,172698776,172720871,172710849,172730221,172519869,172732848,172712466,172730222,172719252,172732189,172720532,172710514,172727064,172711693,172710516,172720180,172734734,172711733,172704573,172719253,172720182,172722210,172735355,172711730,172712894,172730224,172721527,172720872,172737220,172726717,172722227,172733135,172713360,172714520,172715159,172734733,172730546,172711732,172731261,172719644,172727746,172733137,172713730,172730223,172719975,172715576,172717211,172730547,172711731,172713724,172729100,172724280,172704570,172713727,172710846,172722212,172729336,172713731,172728706,172712582,172724535,172720178,172705047,172718338,172649447,172720531,172715577,172723529,172726715,172709222,172723065,172735931,172732047,172732844,172711323,172714196,172734297,172718339,172725776,172721341,172705394,172712261,172709223,172726910,172737218,172734830,172723066,172710515,172734833,172713358,172711694,172710513,172737221,172731146,172649448,172735783,172713359,172737219,172729093,172711691,172712891,172726219,172730549,172718337,172726525,172709444,172712886,172731085,172733631,172723531,172710321,172719979,172710850,172710847,172730225,172725706,172722222,172736236,172703048,172711696,172706689,172722217,172713362,172731551,172726913,172737222,172704569,172729096,172734346,172724284,172728202,172713361,172724539,172707746,172710845,172712258,172722219,172731147,172712262,172704572,172734730,172726909,172712391,172720181,172710512,172712889,172710848,172713725,172736824,172720873,172649446,172703379,172710507,172712895,172724537,172718602,172722220,172723530,172704571,172722215,172710511,172712887,172727232,172713573,172708381,172728707,172732845,172713574,172721528,172711692,172730220,172722216,172732404,172711032,172728201,172717275,172728217,172712271,172731454,172723070,172705712,172716353,172706698,172706032,172731469,172717928,172712272,172714533,172728218,172727757,172714210,172725882,172727756,172723945,172723069,172727399,172731450,172709244,172731449,172709836,172731471,172728567,172708395,172731472,172706325,172710870,172734084,172707283,172719959,172731473,172737000,172731470,172712270,172731475,172711491,172723946,172720286,172719962,172731474,172724332,172731451,172707783,172712273,172731453,172712957,172731452,172713375,172713949) 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'