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 (172089577,172108812,172086623,172087005,172088638,172086625,172096410,172106612,172084224,172085018,172101954,172082938,172099444,172097311,172081071,172089582,172085455,172085024,172094023,172114149,172094759,172099888,172102913,172107899,172106103,172081560,172085446,172108807,172085023,172087001,172106094,172084231,172086258,172099447,172082934,172097314,172098351,172117239,172097309,172088121,172090574,172087366,172117243,172095080,172093447,172107156,172107154,172088125,172108813,172089576,172117241,172085450,172104626,172114152,172106614,172086617,172099055,172112449,172106616,172087660,172080949,172106617,172104625,172094535,172091286,172081557,172084805,172088647,172107901,172108806,172100669,172098352,172087000,172093439,172086620,172087003,172085953,172095376,172082941,172107157,172106611,172085718,172093451,172097316,172093452,172096221,172115560,172105628,172086261,172095925,172098124,172085713,172105626,172093442,172086264,172087659,172096223,172083198,172100148,172087661,172087395,172104357,172099890,172085955,172091288,172095922,172093440,172081379,172099889,172091285,172094761,172090054,172083591,172117238,172107900,172107450,172087004,172082939,172081556,172106345,172114154,172096844,172086999,172104358,172082467,172097312,172113644,172096690,172110345,172089581,172085019,172101956,172096929,172111018,172095921,172095312,172102524,172098350,172097090,172084806,172082943,172093450,172082940,172110346,172093453,172085456,172095924,172106096,172097093,172097593,172082937,172083195,172099054,172096222,172107153,172088645,172087394,172099882,172080951,172081381,172090049,172107449,172081070,172095375,172086619,172087245,172095313,172113643,172117236,172094018,172088646,172095920,172098122,172108425,172096220,172085021,172093639,172086257,172097594,172105625,172086998,172110343,172108429,172097092,172107453,172108808,172106613,172116203,172110347,172086263,172088119,172085715,172087658,172107454,172106097,172082945,172090575,172093445,172085454,172107903,172085714,172108428,172108814,172110348,172110350,172088120,172117242,172108805,172097595,172085716,172097310,172110342,172106610,172093449,172085445,172084228,172090975,172106346,172095926,172095377,172085722,172085448,172099056,172107908,172085022,172113650,172091289,172085459,172098315,172086262,172101958,172083197,172114153,172086624,172095315,172083593,172099448,172084807,172096930,172106615,172106099,172105629,172108816,172094765,172095314,172113646,172087663,172094022,172088122,172082942,172112452,172110349,172106351,172088126,172094020,172102525,172087397,172087002,172082468,172107452,172106095,172085449,172117237,172097315,172085720,172102528,172084802,172106098,172094764,172087662,172084808,172093446,172093638,172085458,172093441,172084229,172082935,172107906,172106350,172104627,172090052,172108427,172093448,172084230,172107905,172095923,172080950,172081380,172090571,172113645,172111017,172086622,172081558,172102527,172094021,172113649,172083589,172086260,172085719,172114150,172113648,172103383,172108811,172106349,172107904,172108426,172102914,172083588,172093444,172085447,172093443,172096691,172091287,172082946,172107155,172089580,172090051,172089128,172097313,172084804,172105627,172088644,172102526,172094762,172086618,172086259,172108810,172114151,172102529,172088123,172090974,172099445,172108809,172116204,172107907,172088124,172107902,172085956,172106348,172081559,172085712,172090053,172094763,172102249,172094758,172100149,172117240,172082701,172086626,172106104,172106347,172084809,172088643,172103384,172098123,172107451,172085957,172099887,172096845,172101955,172090971,172090050,172094760,172101957,172087246,172084803,172094019,172085721,172108815,172085020,172085723,172083590,172113647,172110344,172102248,172099886,172087365,172085457,172099446,172083592,172083196,172097091,172089578,172087396,172096689,172088642,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'