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) 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'