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-05-30' and '2026-06-03'
and t.termin_id in (172570980,172568715,172585095,172589728,172573986,172594720,172575136,172583108,172583100,172592188,172599832,172589261,172597198,172596700,172570238,172570648,172587267,172592700,172599654,172580479,172576701,172591407,172594540,172593721,172567943,172569042,172597178,172575108,172599645,172579733,172582808,172594311,172570649,172587934,172570967,172596685,172563846,172581466,172585235,172575123,172592694,172587780,172572588,172581126,172595887,172570930,172590256,172600622,172567948,172569046,172599635,172596343,172578605,172578878,172596336,172577113,172597797,172563849,172586116,172583340,172566383,172582815,172593957,172570626,172582807,172585950,172589978,172590679,172569039,172578606,172568845,172593723,172592436,172581866,172589969,172577115,172584229,172599647,172568838,172569031,172582093,172570662,172568712,172569041,172597796,172563850,172589968,172594310,172598444,172591742,172566141,172596688,172589749,172567637,172587270,172594718,172574369,172569275,172579719,172569581,172570628,172592964,172574268,172591744,172596699,172596683,172568839,172591285,172591854,172589727,172572614,172589977,172575117,172571000,172578211,172582341,172572603,172587176,172596678,172586461,172591096,172582342,172593966,172592673,172590867,172581093,172567496,172579318,172599833,172592207,172570945,172599845,172570223,172594727,172581125,172595886,172598699,172593719,172579720,172583113,172583355,172575474,172595896,172592702,172567941,172582180,172585240,172579726,172577307,172589267,172574766,172570966,172566565,172600617,172597805,172594317,172569032,172587268,172586444,172569571,172589278,172600623,172579973,172585228,172575472,172599219,172595888,172596310,172578855,172566909,172590694,172585236,172591733,172595528,172597200,172583361,172596693,172568403,172588792,172600947,172584858,172574371,172587189,172595534,172576441,172575100,172598701,172587774,172567635,172570252,172577291,172580255,172592691,172600621,172599652,172589282,172590173,172587192,172594744,172586465,172594314,172567945,172585949,172590429,172577304,172580258,172572593,172600632,172593959,172577286,172570974,172579313,172587927,172597206,172566910,172569570,172600980,172597808,172581091,172570997,172574373,172567937,172568714,172597177,172566339,172593969,172591103,172589737,172588382,172585952,172575133,172582179,172586124,172569045,172584235,172586445,172570990,172591731,172573983,172569565,172576425,172591099,172590168,172592674,172600620,172577513,172583339,172577890,172589976,172585089,172569044,172587926,172592965,172573993,172586447,172586463,172587547,172592213,172600627,172584228,172594722,172583111,172579320,172588480,172589981,172586451,172582344,172596308,172575132,172580214,172570656,172574761,172591977,172581131,172575471,172569033,172596689,172576429,172575473,172592954,172596337,172592199,172576420,172595531,172591738,172581128,172578209,172562909,172587172,172570627,172595065,172570951,172590689,172570244,172600626,172563845,172591403,172600949,172573998,172594318,172579725,172596329,172582181,172599844,172594733,172566444,172587190,172595249,172600616,172581088,172594306,172600619,172579311,172584411,172597203,172586452,172591851,172594545,172593975,172569036,172583760,172573999,172594315,172580233,172576442,172583101,172566568,172591309,172585096,172519754,172568407,172596333,172589982,172581867,172576703,172582343,172591283,172587188,172589293,172577915,172570624,172586120,172583104,172573982,172578602,172575118,172575105,172576422,172589275,172596309,172595247,172580253,172586450,172594713,172592683,172583342,172599842,172570993,172575101,172584866,172589277,172586460,172589294,172593983,172572587,172577898,172581089,172593698,172591975,172590687,172589733,172584862,172601139,172582805,172599841,172577908,172581130,172574757,172570655,172592963,172583102,172576426,172596687,172591100,172594723,172568572,172587174,172581865,172584857,172577285,172596698,172570629,172577917,172595241,172572600,172585945,172574262,172575104,172600625,172594312,172581086,172575122,172582813,172591741,172575481,172585239,172586121,172597812,172584859,172599836,172589266,172575862,172581860,172589738,172568406,172572615,172574265,172599642,172570940,172579309,172590693,172596311,172597821,172568409,172592187,172599831,172572595,172598125,172597205,172566543,172587779,172593714,172581869,172579926,172569563,172569038,172599843,172596338,172582345,172570625,172587266,172584230,172591095,172592191,172573987,172577906,172591093,172597802,172575866,172579735,172581129,172575112,172569037,172590869,172600631,172574772,172597809,172562837,172583354,172600624,172594709,172574763,172582348,172574266,172575113,172585238,172566342,172585590,172569569,172570663,172592676,172593712,172590680,172586128,172593968,172592684,172593695,172594717,172594316,172570975,172589263,172562836,172567949,172567495,172570964,172595897,172590169,172570630,172563848,172582812,172583345,172587925,172576421,172577914,172595526,172597191,172582097,172591296,172590875,172590868,172572625,172570991,172585947,172590285,172570654,172591401,172600628,172600950,172593952,172575863,172570981,172594712,172588383,172582346,172591284,172594738,172576123,172572589,172583105,172577117,172577312,172589983,172590257,172595538,172582809,172597197,172566566,172590255,172584860,172595238,172575864,172586459,172580213,172590682,172570952,172570664,172591739,172568848,172591399,172567629,172579531,172589290,172578860,172593954,172592681,172589731,172593697,172584867,172577903,172595530,172569040,172584232,172566345,172592211,172597202,172576122,172575106,172583110,172587791,172570229,172581859,172590872,172569580,172598121,172598443,172587543,172568570,172581090,172582184,172592196,172595891,172591743,172599223,172587546,172567634,172570231,172601050,172596680,172572631,172574008,172593974,172578852,172596701,172568410,172570982,172587933,172570230,172585229,172590871,172586135,172599218,172573995,172599632,172590283,172592677,172570970,172583338,172578871,172593720,172582178,172587794,172591400,172572602,172585596,172594543,172581862,172579308,172577913,172588381,172589276,172567494,172591097,172569579,172585092,172599839,172591976,172594732,172576423,172568662,172581231,172577116,172562910,172596314,172576424,172585226,172568663,172574770,172580026,172589974,172595537,172600946,172589262,172578870,172587175,172599639,172594305,172567632,172589750,172590685,172570634,172568841,172578208,172566140,172562840,172582349,172570227,172583341,172592689,172568844,172591287,172575099,172574370,172566341,172568564,172593982,172592212,172597813,172577907,172585946,172578607,172574269,172574760,172597800,172572594,172577516,172579738,172597195,172589291,172589260,172580478,172587793,172576704,172589280,172570633,172591294,172590426,172567628,172593293,172587186,172587775,172579729,172589295,172595901,172569280,172592951,172569043,172595245,172577891,172597822,172586462,172572596,172577897,172593699,172578868,172583109,172599651,172581230,172576705,172574267,172601049,172572612,172566539,172587932,172590167,172570651,172573989,172597815,172592703,172579533,172569564,172566145,172595894,172591852,172587548,172583343,172570960,172570243,172570954,172577306,172590686,172582182,172572632,172590425,172589744,172575111,172586464,172577310,172578599,172574762,172600414,172575107,172595893,172597823,172595539,172591730,172582094,172587191,172589734,172599838,172579537,172575114,172591104,172590870,172589292,172598447,172592687,172584236,172584412,172577287,172596316,172577295,172596691,172592704,172574259,172592215,172579739,172597207,172596318,172592695,172601141,172585230,172593978,172586453,172585097,172590428,172597201,172595251,172574691,172578881,172576702,172600630,172580259,172595890,172599847,172593703,172579534,172585593,172596342,172583358,172596692,172573996,172583118,172584413,172591297,172566911,172570631,172592682,172566146,172566540,172570661,172579736,172567493,172590172,172583746,172575483,172591288,172600417,172575126,172584237,172597816,172582818,172591745,172581863,172570638,172595529,172583759,172570946,172572597,172594307,172592460,172570659,172568849,172586469,172566567,172599220,172574261,172594313,172585951,172583749,172592952,172595533,172574260,172593702,172578609,172579500,172578867,172593973,172576431,172591106,172580476,172592962,172572619,172589743,172593291,172583752,172591293,172578879,172593722,172593725,172599846,172577299,172594752,172581861,172583753,172596341,172597824,172582817,172581085,172575479,172600618,172595239,172579310,172592437,172568411,172570637,172595250,172599655,172594544,172587549,172594737,172597181,172577893,172579319,172585244,172583344,172574003,172570247,172577511,172581227,172581868,172595532,172594309,172593701,172567936,172589742,172591105,172576430,172590287,172590692,172589741,172598124,172574372,172578849,172589975,172596340,172592955,172569566,172598446,172597806,172567947,172593724,172567946,172577281,172594731,172583112,172597204,172589265,172570246,172600629,172567636,172587269,172587184,172570636,172567944,172579316,172577292,172595900,172577515,172576119,172593960,172569279,172584861,172574690,172568665,172581468,172591404,172593700,172592688,172566629,172578880,172594729,172583103,172570660,172579312,172589740,172596690,172596339,172591853,172577902,172600416,172570971,172590286,172601048,172567938,172582183,172579724,172574769,172568847,172599638,172589281,172581092,172599644,172594725,172590874,172573994,172588384,172575865,172570992,172582096,172580475,172566344,172593687,172589979,172594745,172591101,172575128,172570228,172599634,172578608,172592435,172592458,172582347,172578210,172582814,172598700,172577514,172575482,172596315,172595899,172593294,172587931,172585091,172589739,172583751,172580022,172584234,172570939,172586126,172562908,172588793,172580215,172590690,172592200,172579317,172562839,172595536,172595248,172591398,172577892,172577302,172568846,172594751,172577305,172590171,172597180,172570245,172597801,172576428,172591102,172587778,172586449,172574756,172519753,172593691,172585237,172595898,172595535,172577916,172566144,172570658,172578604,172570969,172566382,172587789,172570963,172590688,172585948,172570632,172597807,172580257,172569278,172591409,172576427,172581467,172568843,172572627,172586132,172585592,172570657,172574777,172575129,172583750,172594715,172579532,172587777,172567630,172587930,172595246,172600415,172599637,172584233,172597814,172574768,172592198,172590873,172594724,172592214,172567942,172582095,172592459,172583357,172566343,172575127,172598123,172598445,172581127,172582804,172583353,172582358,172569578,172593953,172579974,172583356,172596313,172570240,172567631,172599646,172591286,172599840,172583107,172587929,172589736,172579445,172582816,172587792,172585227,172570226,172596335,172597199,172587173,172576121,172599653,172589279,172578869,172594542,172586122,172579315,172592197,172579718,172589732,172591295,172590170,172574689,172597179,172579734,172581864,172575121,172570222,172582810,172587776,172578854,172594711,172586448,172596334,172600948,172593718,172567940,172574755,172589735,172595064,172595244,172563062,172595895,172585944,172592675,172566143,172570242,172577303,172590427,172563061,172570962,172594730,172574688,172593717,172566628,172577114,172569287,172593694,172594541,172580256,172563847,172591098,172572626,172568408,172590684,172583106,172568713,172585591,172574776,172579530,172591305,172582811,172583748,172566381,172566142,172592961,172587928,172579314,172584231,172592701,172595063,172574767,172596312,172587187,172590284,172589980,172578207,172594539,172567939,172570225,172567633,172593693,172598122,172572605,172591281,172574753,172578859,172593716,172569035,172599633,172585943,172592434,172592457,172570989,172586117,172585087,172569577,172601140,172594308,172587545,172599837,172587790,172595892,172590683,172570653,172572613,172562835,172570224,172576120,172583747,172580477,172570937,172562911,172597196,172591737,172581087,172568842,172589973,172575480,172595242,172592194,172579529,172595243,172583757,172570241,172594716,172573992,172593692,172569277,172568716,172585243,172578853,172594710,172586446,172596684,172593715,172583758,172574754,172585088,172593967,172596332,172592193,172595057,172597798,172570931,172579730,172586119,172578603,172570652,172591736,172589972,172577311,172570961,172601047,172583117,172589264,172592210,172591735,172592192,172599835,172593972,172595240,172589971,172597194,172592209,172583337,172596331,172591734,172584410,172575470,172586118,172575135,172589301,172583765,172580254,172596682,172569583,172593977,172595058,172574258,172568405,172577111,172569276,172593690,172584856,172577112,172581465,172589730,172577512,172582806,172596330,172596681,172577896,172562838,172591304,172587544,172579528,172578877,172592208,172590681,172600413,172582177,172566538,172591850,172568840,172566380,172595889,172577290,172597193,172570239,172570943,172593958,172568566,172592190,172599834,172589289,172569034,172578601,172570973,172599641,172586443,172583336,172566340,172569576,172597820,172593689,172572592,172578600,172563844,172567492,172591094,172591282,172568321,172584855,172596317,172566542,172593713,172589729,172592189,172573988,172593951,172582176,172568404,172585225,172591732,172595527,172597192,172567935,172583745,172572601,172570936,172587185,172577889,172577284,172579716,172590166,172583335,172592680,172575469,172596697,172577109,172593688,172586442,172582175,172590691,172585090,172591740,172596328,172567934,172596679,172569562,172592690,172592195,172601142,172570635,172570953,172570938,172596686,172589970,172592953,172570944,172594304,172579717,172574687,172599648,172593292,172587171,172570650,172577110,172589288,172587788,172593696) 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'