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 (172031831,172080519,172092412,172105662,172080518,172080517,172105663,172116344,172092493,172109170,172109173,172111859,172117218,172109598,172110540,172110090,172114334,172109602,172110761,172088828,172109176,172100794,172106764,172105066,172105280,172109171,172109606,172114332,171990590,172117220,172112252,172082306,172106013,172116562,172104915,171945194,172106763,172113398,172092474,172113397,172112030,172116391,172037008,172112067,172110091,172112250,172109607,172092494,172088827,172100758,172106015,172101209,171990589,172088826,172088822,172088829,172116345,172109597,172109611,172117219,172111860,172105071,172105134,171993524,172113399,172109610,172089742,172114333,172112251,172082309,172116827,171990591,172109177,172114331,172106016,171945178,172109175,172092585,172109172,172103164,172113274,172114335,172080422,172089049,172109601,171945177,172116830,172092473,172109609,172102799,172106014,171945175,172109600,172105072,171993523,172080569,172109608,172111312,171945176,172110541,172109174,172088821,172109599,172116829,172101210,172093567,172112249,172114336,172116828,172092578,172102105,172086321,172091209,172115287,172088980,172096232,172112302,172109512,172098131,172110624,172088851,171945170,172082218,172090138,172111010,172086777,172101187,172100154,172111535,172081728,172095653,172082331,172112550,172083380,172082320,172114318,172111945,172092227,172087483,172088978,172109798,172116768,172112880,172090455,172113987,172103823,172110245,172109357,172082327,172105247,172088853,172082323,172088979,172114375,172100301,172102660,172112884,172091705,172080745,172109349,172081727,172096574,172113234,172098623,172110728,172111383,172102104,172114311,172105356,172110842,172116095,172109343,172100210,172097604,172114374,172088854,172108013,172109347,172113800,172093602,172089354,172117233,172087792,172082916,171945171,172105358,172111538,172104716,172083384,172095352,172092224,172092905,171993528,172113362,172088977,172081215,172108865,172110238,172102756,172113990,172111384,172100253,172114319,172093796,172084494,172083765,172109275,172080630,172102106,172088424,172112546,172081650,172086324,172112545,172095869,172094551,172116778,172093829,172093622,172109511,172083257,172115350,172105668,172095865,172098526,172083382,172091397,172102758,172095648,172113801,172115348,172111377,172103224,172089101,172109509,172094550,172091390,172104136,172105116,172094133,172082917,172111014,172100155,172085071,172081648,172110626,172081387,172097419,172088426,172100717,172108867,172102757,172109355,172080743,172090136,172092914,172110617,172116770,172111376,172084500,172086323,172083720,172112547,172087953,172080456,172083381,172091391,172086319,172080631,172109518,172101189,172109277,172087488,172111012,172080629,172106383,172095349,172081388,172087484,172095868,172092918,172109907,172049427,172113361,172083255,172115697,172111943,172085751,172116773,172109800,172081216,172114315,172081544,172104717,172115817,172109274,172096747,172082918,172112595,172100157,172092917,172097807,172104159,172091704,172092907,172095347,172097417,172108468,172037727,172082328,172103010,172098376,172092608,172100158,172098730,172110239,172103225,171945169,172116775,172116776,172110622,172092223,172091392,172108470,172114272,172102755,172102102,172092908,172082222,172083703,172115333,172114377,172103009,172102751,172094549,172097603,172104138,172081541,172092911,172049425,172095937,172100299,172102662,172088982,172091898,172091208,172116253,172049426,172108467,172087958,172110237,172109801,172089356,172116771,172088855,172084495,172092909,172088857,172112301,172099514,172111539,172095651,172112881,172082219,172081543,172100486,172089355,172080746,172092915,172083769,172049424,172110619,172049423,172110615,172082214,172088852,172111941,172099512,172087954,172095649,172097415,172113360,172085072,172101934,172115349,172114316,172105117,172102753,172105329,172115332,172102009,172108016,172114312,172108471,172093642,172081385,172109345,172113365,171993529,172099515,172100211,172116616,172111537,172115347,172105326,172083768,172080633,172083259,172111942,172083767,172093830,172112883,172101186,171945167,172083764,172113369,172109908,172092906,172112304,172082321,172091708,172102107,172081192,172115816,172102805,172113747,172112593,172081729,172081218,172095348,172110620,172083766,172109797,172113749,172098527,172115286,172106919,172114376,172083704,172103135,172091395,172109356,172083763,172085073,172095867,172082325,172081190,172109510,172105390,172108869,172082322,172100720,172080747,172110616,172105246,172088981,172115696,172102103,172113746,172116096,172113799,172116252,172092607,172111013,172106161,172093912,172116448,172097418,172109351,172080628,172081542,172108868,172113989,172106916,172115345,172116447,172092913,172102659,172101188,172100716,172104814,172105325,172102802,172105311,172109344,172086318,172109350,172087486,172095866,172100153,172092916,172083261,172106915,172088423,172103824,172084497,172116614,172113359,172114314,172082224,172113368,172096231,172113364,172109514,172100300,172105115,172083770,172102693,172105667,172081647,172081808,172102692,172098990,172104815,172113366,172092222,172112882,172109273,172113750,172080632,172090456,172109353,172113992,172107194,172080748,172113745,172088427,172088985,172082225,172095652,172110244,171993527,172110625,172107197,172085069,172100298,172099511,172111375,172113805,172037728,172080455,172113371,172087955,172104137,172112305,172100487,172113802,172080744,172101190,172088862,172107195,172102691,172098627,172110844,172099239,172113370,172082330,172096575,172108472,172109278,172090457,172083772,172092226,172093828,172081806,172088861,172098626,172111944,172114623,172081390,172105672,172091605,172116254,172116045,172110243,172095650,172087795,172088860,172109515,172109359,172112549,172091603,172084498,172113991,172088988,172082223,172098992,172081540,172111011,172096887,172097116,172112408,172086320,172100156,172102804,172105245,172106918,172093586,172081809,172084499,172109517,172095351,172083771,172091706,172110726,172103793,172098991,172111382,172083383,172109354,172081389,172105671,172083260,172107196,172110623,172116615,172083721,172087487,172111534,172085070,172087794,172112594,172088984,172108469,172037726,172103226,172113803,172088858,172087793,172113367,172112548,172110240,172110242,172109516,172115346,172113988,172116777,172080457,172089353,172099513,172113748,172105357,172102752,172090137,172087956,172082221,172110727,172081217,172082326,172110241,172116450,172085750,172083256,172111015,172092606,172116097,172095350,172106917,172098625,172100603,172092225,172100719,172109799,172098528,172111381,172091604,172109352,172102694,172081539,172112002,172105670,172086322,172110621,172088983,172109276,172112591,172116774,172116772,172116769,172092904,172115288,172108866,172111380,172088856,172097115,172115698,172092910,172100406,172081475,172104160,172116449,172110843,172105328,172114313,172102661,172088428,171945168,172088986,172082919,172109358,172102754,172112303,172108015,172098184,172088425,172108864,172109513,172082324,172081191,172098624,172091396,172103792,172111536,172097416,172081386,172091707,172105669,172087485,172113804,172081805,172098989,172091394,172083702,172112530,172113363,172095864,172100718,172112592,172114317,172087957,172091393,172105327,172105244,172109348,172110618,172103822,172111378,172092912,172117232,172088859,172082329,172091897,172099238,172110841,172082215,172115334,172105355,172108014,172111379,172082220,172109346,172104158,172094132,172088987,172098622,172111940,172102803,172083227,172117059,172093427,172087984,172096132,172106085,172087472,172107882,172114531,172087470,172114527,172085050,172096491,172107444,172082064,172083408,172113306,172106079,172116669,172109240,172086798,172089539,172086799,172105616,172094001,172095820,172097327,172108796,172107893,172100788,172099100,172106072,172108800,172102947,172106075,172099875,172094128,172096394,172107891,172094494,172092564,172090567,172106336,172112160,172100649,172092567,172116196,172106717,172098312,172108794,172084898,172108044,172109237,172095087,172096129,172109773,172107883,172080582,172087475,172104621,172109772,172084284,172116671,172082342,172106089,172097329,172117052,172107146,172112161,172112163,172089540,172097326,172095819,172088449,172114529,172091019,172106338,172108421,172090043,172082138,172087249,172085224,172083221,172100651,172094577,172108420,172113615,172106074,172086613,172105618,172086298,172085225,172082060,172106073,172084897,172087820,172105615,172114530,172108795,172093426,172107439,172106602,172095817,172104353,172088452,172099974,172093432,172087474,172085047,172087473,172106090,172091017,172113310,172085049,172116194,172092562,172116197,172090042,172094127,172105619,172081041,172094493,172116670,172084282,172105614,172112159,172085949,172083225,172080563,172097803,172091020,172093763,172110528,172107889,172083407,172097087,172097328,172085048,172083406,172116689,172107881,172104620,172100650,172080946,172081375,172096909,172114528,172113305,172091018,172117062,172116690,172106601,172106341,172097324,172085220,172106606,172109771,172109775,172082735,172095656,172107147,172115447,172117061,172112162,172117063,172087471,172084283,172080583,172091857,172106081,172093433,172083409,172107888,172093764,172096137,172117060,172095084,172113209,172085822,172117065,172102468,172109774,172105620,172096128,172107443,172088843,172095085,172099331,172107149,172091858,172095818,172093430,172114144,172091859,172082062,172115449,172101316,172087819,172117064,172082061,172093761,172092566,172082063,172098157,172110266,172082929,172093434,172107884,172083228,172086612,172083410,172098817,172101901,172081376,172105621,172085948,172080565,172110764,172107894,172094490,172099975,172114145,172107890,172088841,172085821,172098156,172095088,172106340,172093762,172107144,172107441,172113210,172094000,172091021,172099876,172109236,172106080,172093431,172106605,172094495,172108799,172110268,172107442,172098155,172109770,172094126,172106078,172105044,172096127,172109235,172082170,172096490,172094578,172092565,172109238,172102469,172091855,172080945,172106604,172095821,172106716,172093429,172100648,172088842,172114143,172105043,172108043,172095086,172106076,172107143,172115448,172096486,172106339,172093428,172083226,172090044,172097086,172108798,172082171,172101314,172106603,172110267,172098816,172084531,172087558,172106088,172099879,172106715,172109239,172087559,172106087,172088839,172082065,172086614,172097325,172091856,172114142,172085051,172082930,172105617,172082343,172106077,172113616,172108797,172086297,172087985,172098160,172092563,172104354,172113792,172096487,172083220,172116195,172107440,172106337,172106714,172101317,172088840,172085221,172095657,172091854,172080564,172107892,172106086,172107145,172115527) 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'
Fehler: Unknown column 'f.ist_engl' in 'where clause'