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-03' and '2025-05-07'
and t.termin_id in (170004592,169988576,170020379,170011776,170026689,170000608,170031359,169998674,169998676,170035667,170014812,170025087,170013226,170020155,170032265,170008873,170036977,170013814,170014250,170001402,170020381,170013224,170035029,170026687,170012689,169993353,170035027,170039447,170014811,170021003,170007782,170031257,170011778,170034063,170028905,170002120,170030809,170011780,170025056,170035310,170031523,170039121,169998673,170030415,170035708,170026688,170001439,170031360,170021839,170036771,170020158,170020159,170029216,170000097,170018672,170020380,170035304,170014808,170029217,170031259,170021841,170014667,170014251,170011393,170007779,170025086,170028893,170021518,170035030,170039122,170030810,170011775,170008684,170037447,170031524,170035306,170013225,170001438,170028892,170008094,170012690,170035706,170035707,170036302,170029215,170035022,170014807,170008092,170035307,169949549,170008093,170013345,170018010,170028890,170000607,170007778,170035305,170007136,170037448,170001949,170025057,170004590,170031258,170030430,170021840,170029214,170014668,170029172,170037449,170035028,170039120,170037398,169949555,169998672,170011774,170036976,170029213,170029632,170020153,170014810,170036305,170039119,170026686,170008091,170025085,170035303,170007207,170011779,169998675,170011777,170034062,170025058,170028891,170001437,170020154) 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'