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 '2024-07-17' and '2024-07-24'
and t.termin_id in (167929811,167917843,167905620,167909391,167906590,167905625,167939202,167920914,167926280,167935404,167918782,167939206,167925907,167921469,167925618,167917839,167861366,167874218,167886399,167880210,167875309,167877622,167907085,167934902,167936725,167919123,167920921,167921275,167936722,167908268,167923057,167909941,167928306,167928646,167917518,167925908,167926267,167932499,167917589,167917521,167925622,167917516,167925914,167918786,167913132,167905348,167932487,167910789,167914019,167908632,167923062,167925373,167906418,167928932,167920478,167868011,167884826,167872640,167877201,167935972,167913131,167918286,167924358,167910026,167921978,167910329,167936721,167905622,167907086,167926579,167920920,167936726,167923066,167907764,167910332,167924592,167929914,167906423,167922487,167925911,167910334,167910771,167914404,167925616,167904064,167906940,167924360,167929912,167910780,167920151,167918774,167911129,167906092,167927821,167906630,167929802,167920156,167907346,167915736,167922100,167935419,167908278,167909876,167920482,167882549,167936716,167925619,167932850,167929557,167936723,167929225,167929321,167932849,167932495,167926569,167928207,167906934,167924354,167929431,167928017,167926289,167863247,167907097,167927439,167914407,167925391,167936719,167920157,167902235,167934892,167913533,167904060,167929807,167914403,167917607,167920483,167920906,167917312,167934676,167906424,167925383,167906135,167923049,167932510,167910779,167913719,167922490,167907536,167916815,167909749,167915306,167928937,167870182,167927826,167921261,167929432,167928019,167919385,167923054,167928648,167908631,167915735,167920143,167926903,167929324,167925388,167929800,167917050,167909746,167913541,167909740,167926287,167913125,167921274,167923705,167928826,167935408,167905624,167904569,167915231,167935397,167925392,167910772,167934673,167909744,167908636,167916804,167925381,167920475,167932851,167921980,167916073,167879860,167935170,167906133,167874899,167935391,167915226,167916353,167914888,167924593,167919389,167921975,167933358,167926281,167919661,167913114,167933345,167934674,167914886,167925606,167919390,167905626,167911130,167928209,167926923,167919848,167917608,167918287,167921473,167928018,167910773,167907985,167871411,167926931,167937610,167926928,167925610,167919673,167906631,167935420,167914887,167935394,167911637,167922101,167870160,167932493,167910323,167923703,167932853,167939214,167935982,167927168,167863757,167906587,167913536,167925899,167913118,167918777,167910990,167920146,167911124,167933348,167907342,167935166,167923402,167872276,167857356,167869257,167923058,167935406,167882115,167861808,167865142,167860631,167881160,167910788,167926272,167908811,167929982,167879299,167870614,167906419,167936709,167875817,167925376,167869466,167880592,167885388,167868777,167869725,167873211,167929804,167868660,167861020,167883827,167868012,167867604,167866090,167874118,167858483,167934900,167906935,167935415,167861939,167859858,167876130,167877959,167905344,167886715,167926908,167910022,167932486,167890075,167866285,167913971,167865303,167881359,167879909,167886908,167878034,167865618,167861600,167868477,167857474,167871992,167862461,167871790,167859453,167880829,167874443,167868874,167865859,167890085,167888218,167871603,167926273,167904561,167927325,167916809,167934670,167866005,167869080,167871173,167858726,167912305,167902275,167921471,167916794,167875531,167920474,167858490,167872641,167862287,167917834,167862914,167879861,167863550,167887317,167917052,167929798,167857841,167880591,167917303,167886714,167869724,167909393,167935393,167858479,167877958,167879298,167883672,167874891,167881358,167882562,167919665,167933349,167913120,167922713,167923406,167907347,167924996,167909989,167861360,167920471,167926268,167934899,167910776,167924363,167921262,167909742,167936714,167883367,167876292,167917048,167932497,167908624,167904057,167913537,167926910,167924883,167910792,167934904,167857350,167921472,167881159,167906626,167928022,167934672,167919845,167871602,167890074,167909739,167874217,167861932,167866089,167872274,167918778,167916811,167929984,167913718,167861013,167861593,167880265,167859852,167886907,167918284,167915076,167908807,167920910,167878033,167875816,167880828,167874442,167865858,167857473,167868873,167862286,167886398,167873408,167917835,167902231,167905616,167921465,167888217,167862904,167861804,167933581,167865296,167876951,167875308,167863549,167888854,167871991,167876129,167926573,167929322,167913969,167908274,167912306,167923554,167926275,167884243,167873767,167878851,167873204,167937606,167925378,167932509,167914885,167882784,167871410,167907096,167926927,167857776,167860647,167860152,167883673,167873768,167876534,167874892,167872275,167873205,167872910,167869079,167860151,167906936,167928934,167919844,167915235,167921466,167907539,167912302,167902272,167922097,167929323,167918283,167924590,167927328,167917304,167908433,167861586,167906588,167906420,167925379,167921263,167924356,167908273,167911625,167910991,167887316,167912594,167917596,167922493,167871789,167877210,167865617,167858725,167932498,167922709,167925902,167910327,167929911,167929552,167920148,167916795,167907343,167935167,167923403,167923055,167917515,167881158,167920911,167927823,167904568,167931915,167924880,167866004,167929221,167915733,167918779,167913121,167926911,167909743,167928020,167890092,167879370,167868476,167928822,167919387,167912849,167936712,167886374,167939213,167928302,167906085,167913538,167909398,167934901,167881357,167875815,167910766,167923045,167912293,167915739,167933362,167861353,167873766,167874116,167876128,167876950,167923553,167937605,167923699,167935416,167935407,167876291,167874890,167859099,167870181,167908812,167868475,167935975,167929805,167919666,167871171,167865857,167884825,167877620,167872909,167873203,167866088,167865289,167871990,167890076,167861925,167874441,167878032,167859845,167861006,167864764,167882133,167860640,167882543,167871409,167879859,167863548,167863755,167886397,167908806,167926271,167905350,167917590,167922707,167906090,167925897,167921974,167910328,167923046,167917847,167907095,167914889,167908272,167926912,167908810,167929320,167926571,167933580,167906080,167921256,167919676,167922098,167926277,167925380,167934898,167921255,167910774,167934905,167925609,167911624,167925375,167923052,167920913,167925614,167932508,167910786,167917606,167925912,167933346,167922491,167932847,167932492,167910322,167928820,167931922,167925913,167910995,167939208,167907540,167936724,167927440,167923882,167920476,167917842,167919388,167910782,167925613,167926932,167928643,167917836,167926572,167924355,167907980,167913122,167916798,167926278,167915229,167926914,167928023,167906086,167923063,167932852,167912855,167915737,167909402,167910336,167928213,167906939,167929437,167913544,167933585,167920924,167926288,167936717,167923059,167924364,167913123,167935983,167928645,167905617,167929985,167905621,167924361,167908626,167931916,167937607,167923701,167926905,167904563,167926279,167912295,167913974,167919117,167929222,167906087,167924591,167923881,167915077,167913124,167909745,167920915,167910992,167935401,167926576,167902273,167924359,167920150,167935411,167907344,167929554,167919122,167914406,167921468,167925894,167908434,167936715,167933351,167924881,167939205,167925905,167905345,167935410,167932858,167919842,167915233,167912303,167906138,167921981,167925624,167907092,167925615,167919668,167911633,167921271,167935417,167910790,167906589,167926915,167908815,167925608,167932502,167915236,167912848,167928301,167929219,167917831,167921258,167916790,167935169,167923401,167910777,167919118,167928936,167926904,167935402,167929796,167928642,167921982,167906422,167927323,167904560,167907541,167904065,167904059,167911629,167912301,167864947,167922486,167935418,167923053,167910324,167874440,167910770,167904566,167916358,167929549,167864968,167925901,167913968,167921257,167913128,167916802,167914015,167924990,167919113,167868659,167857472,167920481,167924366,167935979,167919663,167933347,167883256,167917298,167908629,167912853,167925910,167937609,167884036,167906081,167908271,167926926,167904571,167934903,167905347,167929556,167929224,167913543,167917605,167910994,167907088,167922496,167929325,167909878,167929913,167929983,167917833,167902230,167905615,167921463,167928825,167916357,167924884,167909395,167907761,167939207,167922712,167909871,167912847,167908625,167925898,167939212,167918776,167920907,167928212,167919667,167933350,167926575,167907763,167921467,167912591,167917517,167920912,167932491,167905342,167935405,167931921,167932507,167920919,167913970,167908436,167920470,167923879,167915075,167931912,167933359,167912593,167914018,167929797,167921476,167919391,167917047,167913535,167917592,167921260,167928208,167908270,167906091,167909401,167909748,167919662,167929803,167925607,167904061,167923050,167905618,167925377,167912297,167925372,167920905,167927333,167920152,167935165,167922488,167917604,167913130,167921977,167932855,167911627,167923048,167857839,167923064,167925387,167932494,167904562,167916071,167936720,167923552,167912852,167920480,167929434,167929223,167920145,167913673,167935398,167907089,167926920,167905619,167928210,167926570,167907979,167906625,167878387,167934895,167932503,167924589,167907087,167928304,167928644,167916792,167913129,167928305,167925621,167925374,167916800,167926270,167906937,167939215,167904295,167923061,167908814,167904299,167906627,167918784,167917599,167915227,167926916,167935395,167920144,167932856,167913116,167907537,167882551,167926918,167910021,167929555,167925896,167911628,167915079,167926577,167928300,167871172,167933582,167920147,167902233,167921973,167915232,167911632,167912296,167935403,167909873,167917600,167927825,167907094,167927331,167932500,167908805,167917830,167907091,167929909,167916074,167929806,167933354,167926266,167934671,167913542,167864752,167919384,167937604,167907535,167935970,167933588,167910989,167882770,167917300,167915731,167924878,167939211,167875530,167926283,167927324,167910787,167932848,167928647,167929436,167917841,167910775,167906083,167919111,167916789,167925371,167926285,167919847,167929319,167908431,167908630,167911623,167912588,167916075,167935396,167908435,167916810,167909400,167919112,167909394,167917588,167917512,167872642,167916801,167910785,167923698,167936707,167925605,167921259,167910070,167865597,167878386,167917602,167876293,167917049,167913539,167935392,167909875,167912846,167890632,167873409,167936710,167936711,167924992,167909872,167917832,167909877,167920153,167909741,167936713,167916354,167928016,167910330,167939216,167904063,167905614,167925385,167926269,167906082,167917837,167918282,167904567,167913115,167927822,167910321,167921461,167913117,167925895,167926906,167917593,167910325,167902271,167909392,167910778,167924362,167932490,167908277,167908276,167919119,167904297,167905343,167933583,167907345,167910781,167922495,167906134,167913113,167935414,167907093,167917591,167924365,167916803,167917308,167885387,167914401,167909869,167921470,167920486,167913540,167911636,167912592,167925386,167907984,167922492,167884827,167868776,167916355,167907762,167929433,167907084,167916796,167904058,167921265,167918781,167928935,167914884,167927330,167913967,167919109,167910024,167925384,167914014,167907341,167904298,167933352,167914883,167926902,167915078,167926578,167922708,167918783,167933353,167918285,167910020,167936718,167927332,167917299,167910025,167910333,167920472,167935971,167932506,167931920,167904565,167904294,167915074,167912854,167906938,167927334,167926933,167916806,167921273,167916077,167919392,167931923,167922102,167925390,167926922,167916359,167922489,167933355,167910335,167916805,167925623,167920155,167913674,167925389,167923704,167923556,167921983,167904572,167919672,167917313,167883368,167927824,167917838,167935974,167934894,167923056,167917311,167931917,167906132,167929435,167864961,167927169,167925612,167928933,167917307,167922494,167933589,167902234,167912514,167874216,167912850,167935400,167929987,167929986,167920917,167935168,167934897,167931914,167884449,167931913,167920477,167928823,167939203,167919671,167877621,167923880,167917595,167864758,167927188,167910768,167935409,167924882,167932857,167926919,167908628,167921976,167923404,167906084,167922096,167912590,167912851,167920473,167917519,167919670,167918775,167904564,167935399,167868010,167872639,167870613,167862897,167863246,167859108,167862460,167876952,167864954,167864745,167857777,167879308,167917514,167916072,167921464,167909397,167919110,167931911,167919114,167865140,167910791,167923060,167936708,167917297,167912300,167936706,167922095,167918281,167910023,167912589,167910993,167904296,167921979,167914405,167902232,167917310,167907982,167929910,167859446,167916356,167925382,167926909,167927329,167925611,167928821,167924993,167934896,167919846,167932505,167917840,167926917,167924991,167908635,167906628,167915305,167908808,167935973,167919664,167914402,167904062,167911635,167920909,167923051,167925903,167917598,167935977,167909399,167917302,167910769,167923047,167926574,167929220,167910767,167915738,167929551,167917309,167935976,167926274,167913119,167859110,167919115,167908809,167908279,167910326,167932496,167921269,167905349,167908269,167905623,167874117,167917597,167924879,167926276,167918780,167906088,167908813,167929810,167909870,167913717,167916812,167929890,167908432,167909747,167915228,167920916,167934675,167906089,167923555,167913126,167925620,167921264,167920154,167919116,167915732,167917846,167923700,167912587,167920918,167926913,167931918,167902274,167909874,167928303,167907983,167906629,167908627,167925900,167926286,167908267,167939204,167926282,167913534,167912294,167923878,167912292,167910783,167911634,167907090,167922710,167908275,167916799,167924994,167912304,167921267,167917603,167911125,167872911,167917305,167929801,167906421,167924995,167921272,167920908,167923405,167922711,167916793,167922099,167910784,167937608,167917594,167916797,167917520,167924357,167911128,167925904,167916791,167919843,167915234,167914016,167927326,167861945,167883955,167879371,167877202,167928021,167927327,167863756,167911126,167931910,167917513,167917306,167920149,167932501,167911626,167921462,167909396,167915734,167907981,167925906,167907760,167934893,167916813,167918785,167915230,167919669,167917601,167929218,167915237,167914017,167929799,167917046,167932504,167904570,167920479,167907538,167917301,167913127,167926284,167921270,167921268,167919120,167923065,167917051,167932846,167933584,167927170,167916814,167926907,167926265,167926921,167882127,167911127,167916076,167910331,167919121,167921266,167928824,167929550,167878852,167919386,167929553,167927189,167923702,167925617,167932854,167913975,167928211,167931919,167905346,167925909,167916788,167935978) 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,828,159032779,3138320,685,3308890,27722768,159032776,690,5177115,167341712,86558852,68181750,158652367,660,797,90722560,674,114793025,576,523,159032782,155235885,29833136,28701456,730,575,137006144,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'