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-04-20' and '2025-04-23'
and t.termin_id in (169924319,169887134,169931782,169887135,169739047,169739046,169933023,169901283,169902963,169837202,169929997,169915366,169929789,169923074,169915801,169894855,169902960,169837204,169903642,169919161,169837205,169933024,169915800,169903643,169902962,169923422,169919159,169930433,169929995,169930004,169929996,169930899,169930897,169894854,169930001,169930431,169837203,169903646,169915365,169932360,169919891,169929994,169893991,169893012,169919160,169894853,169929790,169927739,169915802,169923075,169930003,169930002,169930432,169919162,169933025,169931478,169893990,169925705,169930000,169911625,169928329,169930898,169893011,169929999,169903645,169929788,169902961,169923421,169901285,169919890,169930430,169929998,169915799,169929993,169929787,169926614,169909394) 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'