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-15' and '2026-03-18'
and t.termin_id in (172102105,172086321,172091209,172096232,172098131,172110624,171945170,172090138,172111010,172086777,172095653,172082331,172112550,172111945,172092227,172103823,172110245,172109357,172082327,172105247,172114375,172100301,172112884,172080745,172109349,172081727,172096574,172113234,172110728,172111383,172102104,172105356,172089354,172117233,172087792,171945171,172105358,172111538,172083384,172095352,172092224,172102756,172113990,172111384,172114319,172109275,172080630,172102106,172086324,172095869,172094551,172116778,172093829,172093622,172083257,172115350,172095865,172083382,172091397,172102758,172115348,172089101,172094133,172082917,172100155,172085071,172081648,172110626,172081387,172097419,172088426,172108867,172102757,172109355,172092914,172116770,172084500,172086323,172083720,172112547,172080456,172080631,172109518,172101189,172109277,172087488,172111012,172106383,172095349,172081388,172095868,172092918,172109907,172049427,172111943,172085751,172116773,172109800,172081216,172114315,172081544,172104717,172115817,172082918,172112595,172100157,172092917,172082328,172103010,172098376,172092608,172100158,172103225,171945169,172116775,172116776,172110622,172108470,172114272,172102755,172082222,172083703,172115333,172114377,172104138,172081541,172092911,172049425,172102662,172088982,172091898,172116253,172049426,172087958,172109801,172089356,172116771,172088855,172084495,172092909,172088857,172099514,172111539,172095651,172112881,172081543,172089355,172080746,172092915,172083769,172110619,172082214,172085072,172101934,172115349,172114316,172105117,172105329,172115332,172108016,172108471,172093642,172113365,171993529,172099515,172100211,172116616,172111537,172115347,172083768,172080633,172111942,172083767,172093830,172112883,172113369,172109908,172112304,172091708,172102107,172081192,172102805,172113747,172112593,172081218,172110620,172113749,172098527,172106919,172114376,172083704,172103135,172091395,172109356,172085073,172095867,172082325,172108869,172100720,172080747,172105246,172088981,172116096,172092607,172093912,172097418,172109351,172081542,172108868,172113989,172092913,172101188,172105311,172109350,172087486,172095866,172092916,172083261,172103824,172114314,172082224,172113368,172113364,172109514,172100300,172083770,172102693,172098990,172104815,172113366,172112882,172113750,172080632,172090456,172109353,172113992,172080748,172088427,172088985,172082225,172095652,172110244,172110625,172107197,172113805,172037728,172113371,172087955,172104137,172112305,172100487,172113802,172101190,172088862,172107195,172098627,172110844,172099239,172113370,172082330,172096575,172108472,172109278,172090457,172083772,172092226,172081806,172088861,172098626,172111944,172114623,172081390,172105672,172091605,172116254,172116045,172110243,172095650,172087795,172088860,172109515,172109359,172112549,172084498,172113991,172088988,172082223,172098992,172111011,172096887,172097116,172112408,172086320,172100156,172102804,172105245,172106918,172093586,172084499,172109517,172095351,172083771,172091706,172103793,172098991,172111382,172083383,172109354,172081389,172105671,172083260,172107196,172110623,172116615,172083721,172087487,172087794,172112594,172088984,172108469,172103226,172113803,172088858,172087793,172113367,172112548,172110240,172110242,172109516,172116777,172080457,172099513,172113748,172105357,172090137,172087956,172110727,172081217,172082326,172110241,172116450,172085750,172083256,172111015,172095350,172106917,172098625,172100603,172092225,172100719,172109799,172098528,172111381,172091604,172109352,172102694,172112002,172105670,172086322,172110621,172088983,172109276,172116774,172116772,172116769,172115288,172108866,172111380,172088856,172115698,172092910,172100406,172081475,172104160,172116449,172110843,172105328,172114313,172102661,172088428,171945168,172088986,172082919,172109358,172102754,172112303,172108015,172098184,172088425,172109513,172082324,172081191,172098624,172091396,172103792,172111536,172091707,172105669,172087485,172113804,172081805,172098989,172091394,172083702,172112530,172095864,172100718,172087957,172092912,172088859,172082329,172082215,172115334,172108014,172111379,172088987) 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'