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-02' and '2025-05-07'
and t.termin_id in (170027010,170003521,170013209,170036286,170030795,169998211,170001168,170033275,170001169,169988555,169998270,169998271,170019332,170013210,170013208,169988553,170015559,170021119,170030105,170001887,170006103,170018953,170021246,169988554,170001905,170034520,170015560,169887789,170013211,170015558,170032218,170006124,169988589,170006104,170015557,170009129,169887788,170008085,170011449,170000655,170013810,170036704,170004745,170008940,170013866,170031303,170014138,170003598,170014937,170031204,170031206,170031494,170020311,169993359,170003606,170031214,170001174,170019672,170037497,170019669,170030034,170000656,170027016,170031291,170000657,170014140,170010816,170031492,170013867,170031207,170020305,170037515,170032279,170004843,170030036,170031205,170011452,170010817,170008088,170011450,170035139,170001173,170013864,170029176,170014028,170031489,170003601,170003604,170036705,170005638,170030038,170021210,170011453,170031488,170018746,170008086,170029175,170013865,170020310,170014934,170031203,170008087,170005639,170000663,170035142,170031213,170017667,170013344,170003603,170014255,170014029,170014030,170014256,170001172,170031493,170036703,170037498,170003600,170014254,170020309,170030037,170008084,170011451) 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'