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-01-18' and '2026-01-21'
and t.termin_id in (171724400,171744899,171728519,171748930,171731152,171729756,171746250,171747842,171746640,171733451,171746994,171734220,171751861,171746993,171746642,171734520,171729754,171734218,171754181,171734219,171728522,171677108,171733455,171746249,171750162,171748931,171753571,171733085,171734522,171751859,171743437,171733453,171729961,171751662,171753191,171746995,171628975,171731862,171743440,171743439,171733452,171677109,171628976,171745858,171648518,171753574,171753190,171753137,171751665,171750947,171731864,171729963,171724353,171745857,171752439,171750165,171750160,171622688,171724399,171751664,171745859,171752440,171734562,171614312,171746641,171753573,171747843,171754182,171752441,171729757,171614311,171744898,171733454,171731155,171751862,171729962,171728521,171753572,171724398,171729960,171751860,171648517,171733450,171622686,171677107,171746643,171614310,171622687,171733084,171743438,171734521,171729755,171614309,171748929,171750161,171731861,171733449,171746248,171731156,171754180,171677106,171733083,171751663,171622689,171734217,171628973,171753136,171731863,171732090,171628974,171731154,171744897,171733086,171744896) 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'