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 (170018600,169993717,170018694,170001408,170035673,170001656,170035922,170039517,170006599,170030274,170035790,170026839,170020735,170018526,170022659,170003592,170024838,170030275,170035793,170016049,170012355,170024839,170024498,170007029,170035794,170000389,170023356,170023996,170000387,170012357,170010652,170023999,170000386,170024841,170032086,170016307,170007755,170027318,170025875,170037212,170028216,170030046,170010653,170003243,170018698,170030276,170012354,170012352,170021785,170035791,170001519,170012758,170025520,170025874,170013912,170030767,170032085,170028217,170001516,170003586,170023784,170020733,170003235,170003241,170024501,170005207,170003242,170006086,170028220,170024840,170020131,170021786,170023998,170037208,170026840,170012348,170006087,170028221,170031464,170012358,170008783,170022661,170037695,170008780,170032084,170025876,170035795,170029119,170036775,170031365,170008784,170028219,170002965,170026843,170001518,170012347,170024842,170010651,170008785,170003244,170024837,170030048,170020732,170020736,170026838,170003240,170008787,170012356,170008786,170037211,170016311,170010348,170026842,170020731,170022074,170015237,170025872,170038391,170023358,170031846,170005206,170016310,170002964,170003588,170013911,170037210,170031364,170012353,170026841,170018524,170001521,170023357,170018525,170005205,170028218,170037209,170035792,170015235,170000388,170012351,170016309,170003589,170030768,170011239,170027904,170037696,170016052,170029120,170015236,170025873,170012350,170030047,170031363,170016308,170012349,170023997,170008782,170020730,170037207,170031465,170027903,170010347,170012757,170008781,170018523,170027317,170033991,170007754,170017060,170003239,170003591,170032083,170031845,170000390,170013910,170022660,170001520,170001517,170007025,170011238) 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'