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-06-15' and '2024-06-19'
and t.termin_id in (167704596,167704695,167697218,167712522,167714660,167698547,167715368,167715381,167694548,167693304,167695127,167718409,167695373,167714845,167705397,167714836,167700540,167710877,167708843,167707038,167709512,167711332,167694460,167714347,167695113,167699780,167707828,167704226,167704701,167687942,167698526,167714838,167714150,167716338,167631502,167698545,167717592,167706778,167714255,167713843,167719584,167714149,167705491,167718031,167717597,167718156,167717961,167718034,167712523,167715370,167707563,167714089,167714456,167711548,167717598,167712966,167703779,167701403,167718256,167705399,167710627,167718904,167710878,167717048,167700539,167709524,167699779,167691384,167710290,167703555,167716342,167711552,167687940,167719303,167713407,167711337,167700538,167718161,167700988,167710624,167719585,167693787,167631505,167694457,167700987,167694550,167711551,167693785,167698525,167714645,167710879,167717107,167694552,167714457,167707558,167699775,167707812,167710876,167717596,167707789,167704591,167714371,167693788,167707898,167710874,167718413,167704592,167697819,167687093,167687091,167698549,167709511,167714254,167697821,167717112,167708363,167717591,167708364,167691386,167710875,167714707,167719595,167713403,167710625,167708161,167716337,167695372,167705490,167715383,167707042,167705400,167695375,167700990,167709522,167695874,167712559,167717111,167712420,167698542,167707897,167702592,167713840,167687943,167707727,167709515,167708162,167712967,167717110,167706775,167687095,167694456,167698523,167687092,167716239,167695112,167710626,167714370,167714454,167707813,167707560,167718032,167717898,167714832,167699782,167695122,167716237,167706774,167702403,167710289,167712419,167715375,167701238,167696440,167712529,167706776,167705183,167714464,167714345,167707040,167714835,167715691,167717109,167716341,167698544,167703778,167704594,167719363,167701240,167700535,167701239,167714374,167712968,167718159,167687941,167697818,167697215,167701241,167714111,167716336,167707557,167697820,167714643,167713410,167710873,167695126,167715371,167718157,167696438,167693307,167707814,167691395,167707933,167708163,167693306,167707559,167695374,167709523,167709514,167687950,167714085,167714343,167714846,167717244,167714151,167718412,167631506,167698543,167699774,167702959,167714256,167710292,167704698,167699783,167712964,167691396,167701401,167705396,167714148,167697221,167712527,167701400,167718907,167719300,167718906,167712418,167687096,167713832,167704225,167711338,167711334,167718257,167714458,167695121,167703777,167707935,167714840,167709519,167709521,167716335,167710880,167695114,167718903,167710622,167717342,167713406,167698541,167717601,167716235,167717254,167694549,167713834,167698540,167687332,167716236,167696439,167707041,167717594,167718160,167714465,167714109,167698553,167714644,167695125,167701242,167701405,167711336,167714346,167631503,167703236,167714087,167714834,167718035,167719586,167714466,167713402,167718162,167716242,167710623,167717106,167700536,167694458,167708362,167698551,167702404,167694459,167707934,167715495,167714463,167714257,167716238,167714839,167699777,167707724,167697220,167707708,167707726,167714373,167716334,167714455,167698552,167713835,167698548,167710644,167715372,167718033,167713409,167703238,167707725,167708844,167715692,167702956,167701404,167713414,167708365,167687338,167716332,167702958,167631504,167717593,167714110,167709520,167695872,167715373,167703780,167715377,167699776,167702405,167718411,167717252,167711549,167712417,167695870,167704227,167717897,167716241,167719302,167714108,167710293,167715690,167713839,167703554,167704595,167714833,167714259,167707948,167717113,167713836,167708840,167715382,167714112,167714260,167711554,167714086,167715694,167696444,167687334,167714467,167698527,167700991,167717963,167713833,167705187,167714152,167713841,167705492,167697822,167691385,167711553,167715693,167713408,167714837,167715374,167700989,167714848,167703237,167698550,167718038,167703556,167713842,167699781,167716240,167693786,167704697,167695869,167717253,167705186,167714088,167708164,167695873,167694551,167706777,167695124,167698546,167687084,167714258,167711333,167712528,167696443,167714847,167687333,167709513,167708839,167693305,167708838,167710291,167718036,167714372,167705495,167701402,167699778,167703557,167718905,167717083,167708846,167687094,167718158,167702957,167707039,167687337,167711335,167703235,167698524,167713405,167704696,167697219,167715369,167713404,167700986,167719301,167705184,167695123,167717595,167708845,167696447,167714344,167717962,167695871,167704593,167711550,167717590,167716333,167705489,167712965,167705398,167712526,167714849,167717108,167707810,167718410,167708165,167707827,167705185,167709518,167700537,167700548,167701660,167700891,167701103,167712436,167692872,167693324,167704615,167686244,167691213,167718108,167712183,167714485,167712437,167692319,167710303,167690556,167712433,167694738,167713066,167693805,167686245,167693522,167716857,167688681,167712632,167710304,167702981,167695223,167714270,167718928,167716858,167718106,167710302,167717924,167692317,167716883,167704612,167717927,167700547,167688312,167704613,167718404,167696138,167689838,167687102,167690559,167701934,167706796,167718403,167712432,167702983,167705868,167707866,167693523,167691210,167693005,167704617,167700551,167696136,167704746,167699944,167714486,167686247,167705027,167695222,167704614,167695221,167705026,167691723,167702122,167707864,167690537,167693004,167692873,167693804,167701269,167713255,167694739,167694737,167717926,167695224,167714488,167686249,167691214,167692874,167692875,167717928,167713256,167690557,167686248,167710306,167713254,167711765,167693003,167694736,167714484,167718406,167701935,167699943,167695540,167714269,167705867,167702121,167707865,167712439,167692316,167690558,167692318,167701104,167707867,167714265,167714267,167714266,167686246,167702984,167719216,167713253,167697840,167718107,167687103,167694735,167704013,167704616,167700549,167695025,167700890,167697242,167704745,167691211,167696135,167712434,167718105,167700546,167719215,167713252,167702123,167688991,167702980,167712440,167702126,167692876,167692320,167701661,167718109,167702125,167705028,167710305,167700550,167702124,167718405,167691212,167702982,167712438,167697841,167717925,167689839,167714268,167712435,167691038,167714487,167714271,167696137,167717534,167695139,167716482,167687122,167698562,167714512,167704752,167687121,167713848,167714901,167715435,167717886,167701265,167702992,167679516,167707942,167687183,167719529,167712010,167700359,167714515,167714667,167687538,167716911,167679517,167714700,167719564,167711395,167708853,167687433,167693327,167718754,167631962,167714131,167712029,167714353,167686732,167713905,167715437,167706806,167704750,167717051,167711394,167690550,167712987,167687117,167714910,167694476,167719561,167690549,167719565,167679521,167631964,167711575,167718028,167707265,167712014,167705575,167694475,167691056,167707060,167694469,167711393,167715432,167716795,167719530,167708376,167707587,167715977,167714907,167687536,167716807,167707974,167714134,167707590,167716910,167713884,167708851,167711392,167631963,167696460,167694477,167691378,167687439,167711560,167718101,167707975,167695408,167695140,167708850,167716506,167717531,167708004,167714352,167698461,167716794,167715429,167707720,167719562,167716792,167691058,167693328,167700358,167698565,167695407,167631961,167694470,167696468,167701938,167679524,167718102,167686731,167717239,167679515,167719575,167707499,167714511,167687440,167691059,167687182,167714908,167690551,167718059,167707057,167714902,167690547,167716484,167698346,167714911,167707973,167691379,167714356,167708249,167713382,167695130,167708370,167717257,167716909,167716485,167716003,167698462,167718196,167714355,167708019,167715431,167716509,167708849,167717341,167687436,167712971,167717883,167706804,167708248,167718195,167718396,167695406,167716481,167697251,167716507,167716267,167714666,167718400,167716263,167695136,167687434,167718103,167719527,167716264,167690548,167707656,167687438,167707963,167710898,167706075,167707502,167679519,167717885,167687537,167713885,167715433,167702993,167716508,167714900,167698561,167718755,167686733,167698563,167713849,167717529,167698344,167714354,167711256,167718753,167698564,167687441,167718182,167696465,167706078,167706805,167714130,167707586,167718921,167691057,167711396,167718925,167704753,167714898,167697252,167714701,167707589,167679518,167707939,167715976,167704751,167716265,167702995,167707655,167719528,167691076,167691075,167691055,167713850,167705579,167717530,167687539,167710893,167715438,167698347,167679523,167713440,167707721,167687120,167707266,167718398,167718197,167711257,167718923,167707940,167679522,167691377,167712011,167687535,167691380,167687432,167687189,167716793,167707719,167714899,167710897,167718057,167714514,167713853,167695138,167718705,167716266,167711561,167707976,167717240,167631965,167714668,167687123,167714133,167687437,167708020,167715436,167707965,167718060,167714132,167707588,167707964,167713439,167704757,167679525,167718924,167707941,167702994,167713437,167698345,167687114,167687435,167715434,167698342,167679520,167714909,167719563,167714513,167686765,167706077,167716483,167707922,167717884,167708018,167716512,167718058,167707058,167713438,167718397,167687181,167707498,167708017,167706076,167708247,167687186,167718922,167698343,167712972,167719514,167718027,167707061,167695131,167715430,167695137,167711559,167712026,167704787,167631700,167717512,167717513,167694515,167714202,167717289,167687856,167714205,167718245,167694519,167719599,167444044,167687858,167711306,167714206,167711536,167710823,167716544,167687445,167687447,167715361,167715539,167695187,167695186,167715535,167694516,167704783,167687232,167714204,167719329,167714338,167707150,167687855,167631099,167687446,167710444,167716548,167716948,167715537,167695605,167694569,167714807,167687448,167694530,167687443,167687857,167713827,167707506,167707886,167715538,167694566,167715360,167694568,167715536,167704784,167707507,167694570,167444045,167707838,167704786,167711305,167716547,167694518,167718246,167679834,167716546,167704785,167694517,167719330,167716545,167714203,167631701,167694567,167687444,167697734,167694913,167691881,167695214,167700620,167704977,167714818,167697108,167687514,167694914,167700619,167707870,167705756,167687511,167687515,167714819,167691880,167702862,167687513,167688898,167483130,167695781,167712664,167690480,167687512,167691235,167697105,167697732,167691236,167689918,167697106,167694604,167694360,167686197,167719234,167687516,167697733,167693713,167686198,167714822,167714821,167690479,167701750,167714820,167697107,167700618,167692517,167692516,167711298,167715321,167687131,167711297,167707581,167718303,167711302,167684214,167717508,167687137,167711301,167714232,167714233,167718650,167714234,167716747,167714236,167718272,167719335,167707580,167714422,167714235,167710806,167716058,167710807,167587767,167695158,167695161,167718041,167694598,167718040,167692594,167707008,167716899,167686712,167679682,167694613,167717505,167704737,167718266,167717503,167679680,167714919,167714918,167717504,167686711,167714915,167706191,167715441,167706192,167679683,167714917,167679681,167714916,167483124,167716902,167545835,167679930,167545831,167545826,167680360,167680361,167636568,167586745,167714621,167679117,167679118,167679119,167636567,167586414,167586413,167714001,167679121,167714000,167679120,167714712,167694586,167694585,167694588,167718495,167718496,167718494,167694587,167718501,167718518,167686040,167591976,167677943,167714722,167544689,167709413,167698149,167709144,167697750,167697126,167709695,167684302,167684301,167696492,167696493,167692604,167707024,167707023,167692603,167687081,167687080,167686037,167542134,167710701,167686043,167705513,167707097,167702763) 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'