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 '2025-05-24' and '2025-05-28'
and t.termin_id in (170163206,170159389,170144782,170157445,170160925,170164103,170148384,170163021,170146120,170147282,170160668,170152343,170149507,170166997,170157859,170156727,170174257,170162624,170156945,170161202,170162629,170173914,170144766,170174611,170156241,170145363,170157238,170150515,170174606,170146908,170151651,170157443,170160151,170146362,170153355,170156939,170164386,170151649,170146919,170149506,170163211,170145072,170155951,170143798,170154884,170148955,170160920,170156237,170164400,170163207,170147279,170158390,170174720,170153348,170166998,170143438,170164394,170161204,170153350,170157855,170150913,170167940,170174255,170159009,170156240,170176504,170163019,170159614,170150517,170151267,170163354,170166518,170162618,170170993,170163205,170157696,170163877,170171676,170158737,170145370,170170985,170168005,170143441,170155397,170155952,170145597,170157233,170146361,170154720,170161498,170157861,170159019,170155949,170163353,170151976,170166526,170158402,170171675,170163208,170156730,170158106,170151027,170146922,170170762,170143094,170147700,170148001,170169496,170145595,170166525,170168762,170151975,170149512,170142401,170155955,170174262,170145367,170171513,170170764,170148949,170156728,170147683,170166530,170164366,170164099,170151978,170145062,170160142,170153349,170172381,170147278,170147295,170172378,170170992,170146724,170159871,170152346,170160146,170167001,170142170,170159015,170151266,170147296,170143802,170160666,170159384,170159020,170160927,170144562,170162620,170152348,170143800,170161195,170145362,170164371,170150038,170160916,170167801,170162092,170154718,170145063,170171125,170163350,170156514,170153354,170155950,170163209,170162094,170145064,170170983,170145070,170157440,170158729,170176488,170174603,170165070,170144288,170158108,170157437,170144277,170159385,170142168,170144566,170159622,170159613,170156735,170139421,170151981,170155754,170158109,170160465,170153091,170144780,170157234,170157700,170145360,170149500,170147283,170156726,170157441,170164377,170158727,170144291,170148012,170165068,170142398,170156933,170153096,170155117,170162102,170158391,170169491,170144560,170146109,170164381,170146357,170155399,170170840,170169638,170149501,170163210,170150375,170170355,170150518,170163018,170144763,170145368,170155387,170143092,170148951,170149509,170167811,170154885,170155953,170147711,170166529,170170987,170160923,170170986,170148002,170175676,170165400,170155120,170168975,170146719,170146112,170155753,170159381,170164108,170170763,170161188,170159018,170155751,170159615,170162096,170151652,170156238,170157439,170143803,170144779,170162615,170176489,170164110,170169500,170160145,170157442,170158731,170176490,170153097,170165069,170159379,170156234,170157694,170150410,170149518,170146913,170147704,170156239,170158403,170147992,170164399,170155413,170150041,170155393,170147695,170151781,170171864,170143097,170150028,170162086,170142405,170144274,170159383,170167808,170147690,170159376,170176494,170144567,170164393,170147280,170171677,170168764,170144778,170161493,170147290,170160140,170167814,170145601,170163016,170146358,170143440,170142403,170162623,170171124,170164107,170161198,170161192,170146110,170160147,170155408,170159012,170159378,170144551,170144765,170174724,170172377,170170352,170156521,170144276,170146125,170170995,170149519,170151778,170156935,170151984,170146111,170174260,170166528,170147691,170157229,170153101,170156936,170168766,170145594,170157853,170164391,170160672,170157856,170160667,170144270,170161483,170164369,170147710,170151777,170171123,170150411,170162616,170151026,170151265,170162087,170153346,170168763,170152349,170171128,170144773,170162091,170169495,170164383,170156519,170146920,170163356,170168221,170142397,170160918,170162101,170159016,170148010,170167151,170164390,170161490,170158733,170147697,170161492,170144561,170153094,170145366,170144285,170157695,170160144,170174263,170155400,170161484,170176487,170163020,170153099,170174212,170142396,170158399,170144281,170164117,170160143,170167045,170151577,170148387,170144555,170153337,170143799,170147300,170157863,170159021,170173915,170143443,170148006,170176485,170166520,170173911,170150912,170155411,170150048,170151779,170158734,170146911,170159874,170157854,170159011,170158098,170156235,170158392,170155118,170155750,170164374,170165072,170160138,170156518,170161481,170166521,170146364,170169493,170148385,170168977,170164378,170174614,170149516,170143815,170145364,170154716,170146132,170149511,170147699,170157699,170173916,170161494,170139423,170160467,170159875,170174213,170174719,170145378,170148960,170162626,170156729,170160673,170142169,170145371,170145073,170150047,170166522,170163875,170142167,170153352,170162622,170165401,170150911,170146118,170159380,170159624,170158100,170147281,170147684,170163017,170139418,170159876,170164375,170164387,170170354,170151982,170164372,170152350,170155389,170151980,170160922,170156732,170171678,170159623,170172382,170146113,170164396,170149502,170157231,170160148,170160464,170148009,170150332,170159014,170170984,170153353,170170839,170169497,170157692,170161197,170145071,170144556,170163879,170155386,170174258,170151988,170174607,170158101,170155121,170164365,170168006,170146912,170148007,170156243,170143090,170148956,170164114,170145377,170145608,170158105,170144563,170164388,170155412,170152353,170157697,170151979,170161486,170173913,170167802,170143096,170150025,170156517,170161191,170147706,170160670,170174211,170158401,170172380,170143089,170153356,170150521,170150412,170150045,170147685,170155123,170158398,170155390,170143804,170147712,170146723,170148958,170159013,170159377,170155388,170155402,170158097,170149806,170147713,170151780,170145607,170146914,170158107,170174261,170158099,170148386,170155392,170139422,170174604,170156734,170145381,170174725,170151576,170171861,170149503,170143088,170146119,170143812,170150026,170167046,170151573,170148388,170148950,170159386,170164397,170142166,170155398,170147291,170167810,170146725,170164109,170154882,170158736,170166527,170146363,170172379,170149891,170159017,170158104,170170767,170150519,170164398,170160919,170168004,170146923,170170837,170168861,170164389,170155946,170160139,170167809,170159010,170158394,170159620,170145361,170147294,170150516,170156523,170142400,170145076,170143091,170168979,170171511,170150333,170156244,170144290,170174727,170167002,170171510,170160470,170158110,170143816,170174610,170150520,170175684,170150030,170158735,170157446,170148959,170147284,170155127,170162625,170145065,170170652,170157857,170167812,170150029,170160469,170151268,170151028,170165403,170162097,170168865,170146726,170148011,170171863,170156948,170174264,170143810,170145605,170160926,170157860,170146365,170144552,170156940,170171509,170157693,170156947,170150040,170156731,170155401,170168765,170151983,170142404,170162095,170163355,170167805,170174726,170170766,170157438,170161187,170147698,170156522,170153100,170157862,170145598,170152352,170164395,170155126,170160917,170174721,170147701,170150021,170161196,170161482,170155394,170160921,170160924,170149515,170164392,170173912,170156527,170156516,170169499,170144287,170175682,170169498,170175683,170148957,170159621,170162630,170176492,170157444,170145380,170150046,170142402,170160468,170143447,170165071,170156733,170153351,170155954,170149930,170168864,170157698,170159382,170145604,170168220,170174609,170167000,170156529,170156938,170161491,170168978,170152351,170143095,170162088,170158728,170153093,170159872,170161189,170147702,170145045,170155124,170144549,170144273,170156520,170155409,170174608,170162093,170164102,170152347,170167804,170144564,170170765,170161194,170156236,170158393,170164370,170164364,170151987,170176491,170153098,170148008,170142395,170153092,170160674,170150027,170169492,170175681,170174723,170166519,170162621,170150043,170161480,170156528,170173919,170168862,170153095,170171862,170164385,170164384,170147705,170144286,170155410,170146917,170160671,170164382,170159619,170169639,170143813,170145379,170149508,170150044,170143442,170170838,170144280,170161489,170145603,170156937,170161193,170170353,170143093,170168863,170163878,170157232,170155395,170158103,170144272,170160141,170142399,170164368,170164101,170167803,170174722,170174259,170164380,170148004,170161190,170160669,170146721,170154717,170158732,170158397,170155122,170156515,170164379,170145596,170161487,170149803,170167939,170168761,170170836,170164373,170146359,170159873,170166999,170144550,170158102,170158396,170164376,170169494,170150024,170159617,170155396,170168760,170162090,170162619,170151650,170154883,170144768,170168003,170150042,170164115,170148005,170144279,170146722,170144764,170156946,170149804,170145602,170168219,170170991,170174210,170168976,170151575,170150039,170170842,170161485,170143809,170144271,170148952,170174605,170162089,170164100,170139420,170176493,170155948,170151977,170158730,170139419,170167255,170155391,170148954,170146918,170163352,170155119,170161488,170152354,170151574,170167047,170158395,170148953,170161203,170167048,170150331,170162617,170148003,170149857,170153083,170150023,170147991,170149744,170157230,170145075,170152345,170163876,170171860,170144284,170163351,170146116,170164106,170153347,170145061,170154719,170151572,170170351,170165399,170146720,170164116,170168218,170164367,170170990,170174256,170156934,170152344,170167941,170164118,170174214,170158400,170171512,170144769,170144781,170159877,170159618,170157858,170155947,170146131,170150910,170158726,170176486,170169640,170165402,170156242,170155125,170159616,170155752,170143087,170160466,170146360,170146117,170150022,170150514) 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'