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-03-13' and '2026-03-18'
and t.termin_id in (172100482,172111690,172103499,172114657,172114579,172116781,172096761,172113883,172102016,172113882,172092570,172114656,172096915,172096762,172114658,172111970,172115773,172110976,172111600,172110975,172106392,172115705,172109310,172112585,172092011,172092366,172082531,172092003,172088963,172099896,172112538,172106936,172116603,172082526,172112141,172087294,172111320,172109073,172099901,172101818,172104928,172109079,172087915,172101807,172097734,172099897,172092012,172109071,172113079,172106927,172101816,172112146,172091871,172098900,172102134,172111884,172092365,172087296,172106926,172082530,172080654,172082525,172084451,172110597,172088961,172092362,172110596,172092361,172113191,172102136,172115639,172101817,172109780,172088950,172106931,172087922,172113073,172113184,172098896,172087299,172087916,172100824,172088953,172105017,172092002,172092006,172098899,172112144,172091877,172113087,172091881,172092557,172111326,172100829,172105016,172081992,172111885,172084440,172113189,172110608,172112541,172109783,172109789,172116621,172089673,172099906,172104929,172108149,172088955,172089690,172081988,172084453,172091872,172115642,172104927,172089691,172109790,172112194,172109078,172092014,172094007,172092553,172094008,172109791,172091878,172088962,172113829,172112534,172099900,172098898,172094006,172080642,172099898,172092013,172113076,172098897,172113832,172091879,172087921,172116606,172111319,172094010,172087917,172092556,172112583,172092525,172112191,172108150,172091870,172100766,172115644,172112537,172082528,172081990,172082534,172102150,172099902,172109792,172110610,172108151,172113183,172108154,172081991,172102154,172102151,172088952,172092004,172109077,172113080,172110605,172087913,172097735,172108147,172084443,172113838,172109076,172080637,172087300,172113075,172110609,172084452,172112192,172089687,172101813,172113831,172101809,172101808,172087918,172113833,172113190,172109793,172113830,172082533,172106940,172099895,172113834,172112580,172094009,172115643,172088956,172112579,172092363,172089672,172082532,172088951,172112581,172113082,172080641,172116620,172113077,172084438,172091880,172082523,172087923,172088957,172113187,172092364,172113185,172112813,172113828,172094005,172105019,172102152,172105015,172112582,172092005,172088958,172110607,172111890,172098901,172109081,172116610,172082529,172089671,172084445,172101811,172094011,172098895,172113081,172109080,172099905,172116602,172110601,172110606,172101814,172116609,172101810,172112195,172099899,172092554,172111889,172099904,172084447,172081996,172110598,172084448,172084442,172109784,172113186,172112145,172106930,172112193,172110600,172088954,172100825,172111888,172102153,172087295,172080640,172112142,172082524,172113839,172084446,172110599,172089688,172092558,172084441,172087298,172113078,172116608,172091873,172080639,172109782,172080655,172092007,172116607,172091876,172111887,172100765,172087297,172092555,172098904,172102135,172099903,172113086,172106937,172112536,172104930,172101815,172106928,172082527,172112196,172112584,172105018,172109075,172112143,172111322,172081987,172109074,172111886,172108148,172106929,172112535,172109072,172109781,172113074,172106935,172091874,172087914,172111321,172106939,172115640,172111325,172116605,172113188,172091882,172116604,172081993,172111324,172111323,172091875,172080638,172101806,172106938,172100826,172115641,172111883,172108146,172109788,172109779) 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'