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-09' and '2025-05-14'
and t.termin_id in (170079868,170050012,170059133,170057005,170081832,170084680,170062432,170063303,170068067,170077789,170077782,170060923,170066008,170060508,170065392,170071362,170081723,170086560,170046782,170074485,170065630,170046705,170047777,170082012,170068308,170059126,170076069,170049912,170058218,170065373,170074851,170061334,170073376,170049036,170048779,170050889,170049239,170049260,170067473,170074867,170050008,170069400,170070035,170052437,170065658,170054670,170063081,170064751,170080942,170079865,170056419,170053970,170055848,170067465,170082944,170068618,170064132,170067796,170061811,170081067,170078409,170051245,170081604,170068844,170059129,170051272,170071390,170048867,170068702,170072005,170047810,170055827,170054519,170086556,170068306,170076719,170069408,170079846,170051271,170064184,170072016,170072968,170057559,170058213,170081600,170068860,170065648,170060208,170047803,170077140,170064143,170082008,170061354,170072750,170067477,170064124,170048857,170077777,170079151,170072142,170076064,170073834,170071376,170050898,170060533,170073379,170059636,170072959,170064766,170054674,170075052,170060224,170050281,170067028,170065642,170072001,170066004,170073390,170057236,170062450,170062074,170067675,170048780,170051573,170060213,170059107,170069690,170069125,170081601,170052443,170072014,170066009,170056775,170072753,170054219,170060222,170055453,170055144,170079240,170078572,170082380,170069705,170080548,170063294,170073598,170077772,170074460,170075723,170086543,170064173,170081210,170067036,170076430,170076446,170076747,170065384,170055538,170059616,170056420,170076733,170051277,170064762,170046781,170066039,170072273,170069385,170054221,170067479,170079243,170072144,170067022,170070044,170082680,170052418,170054701,170065383,170067470,170049259,170056774,170072966,170061348,170072768,170051249,170061689,170049243,170075045,170066036,170070555,170082664,170079146,170051567,170079266,170070033,170064747,170055138,170050371,170052161,170081216,170048785,170076736,170054215,170076726,170082007,170075745,170050376,170060521,170050010,170050362,170062744,170055852,170082676,170050369,170054665,170077047,170068620,170074862,170051589,170069190,170056776,170077786,170056768,170082009,170060507,170080706,170069911,170080705,170079237,170051575,170065628,170050259,170080698,170079245,170062430,170056305,170066041,170066010,170070336,170077044,170072981,170051592,170064764,170075342,170067029,170059617,170082102,170051593,170066030,170077137,170052436,170050367,170064165,170085972,170070332,170074459,170068246,170064155,170067026,170052434,170076061,170064153,170061337,170075732,170055447,170053965,170054695,170057562,170071372,170073388,170072766,170060537,170056430,170051793,170068843,170046784,170051230,170075484,170047808,170071359,170076444,170055141,170072954,170080549,170060936,170061855,170060547,170059114,170059606,170086552,170077781,170051268,170049904,170046783,170051566,170086527,170079238,170081599,170068862,170073381,170079845,170067463,170051594,170068557,170068836,170068621,170062076,170079242,170071384,170075344,170061351,170066006,170068305,170048870,170060896,170069133,170050860,170062423,170081719,170065624,170061687,170059603,170070109,170058448,170046706,170060911,170076729,170081834,170052441,170054228,170075735,170070460,170046780,170048858,170049911,170081602,170051266,170054671,170080941,170076722,170073386,170061336,170066007,170059124,170081323,170069189,170065660,170073809,170072017,170080699,170064761,170061317,170049244,170062087,170056450,170062425,170064749,170050872,170065386,170065644,170069691,170067467,170059645,170070043,170067042,170050883,170078750,170065369,170065371,170073811,170079873,170081069,170067017,170074871,170068310,170074462,170081515,170046707,170064126,170069138,170047776,170059608,170051258,170051270,170055142,170069409,170074475,170057177,170070377,170077142,170052149,170072148,170063069,170050361,170078760,170081100,170073389,170076059,170074489,170046785,170067476,170054220,170072958,170056427,170062448,170056705,170080940,170082662,170081837,170048781,170076428,170056436,170056413,170065657,170065374,170075722,170072752,170057010,170081214,170049268,170065661,170060927,170062442,170073385,170060210,170054694,170060905,170066048,170070335,170049258,170063295,170051218,170083455,170070102,170047773,170075741,170064185,170080545,170072747,170066029,170082942,170064760,170080544,170056414,170056422,170073377,170080944,170052433,170054692,170055229,170055225,170060510,170068563,170066003,170076717,170074480,170049903,170056421,170061695,170054222,170057181,170050258,170065296,170055452,170078488,170075051,170066034,170080939,170077749,170075483,170063080,170069413,170059601,170074483,170075048,170077139,170074465,170082658,170051588,170049264,170062741,170067460,170054693,170048175,170051786,170079273,170071347,170072002,170062082,170075743,170069394,170060523,170050363,170051224,170074868,170062415,170070376,170055454,170082677,170064757,170069398,170048866,170082013,170075727,170060223,170064144,170063311,170066043,170049906,170075347,170061325,170069219,170078754,170072755,170078407,170072141,170052162,170084678,170085121,170068304,170050857,170056444,170070331,170067011,170069395,170062452,170060207,170077770,170077788,170052415,170052414,170073601,170062443,170054092,170079867,170061320,170068834,170061358,170052426,170066033,170069702,170059620,170057560,170068556,170081099,170076056,170062422,170068851,170070330,170076720,170068171,170081718,170050902,170082928,170069126,170066055,170046786,170077750,170074849,170078751,170050903,170065385,170077045,170058388,170060522,170072008,170051227,170081610,170082573,170068857,170060218,170064122,170076065,170072757,170057006,170055532,170072969,170081598,170072970,170067012,170057553,170077778,170050879,170071998,170073586,170054216,170073810,170057555,170064121,170086539,170051219,170056765,170084679,170067468,170063292,170079254,170070115,170069703,170052442,170063301,170056428,170070461,170051276,170047771,170068317,170076427,170051571,170051784,170061308,170055851,170046709,170058389,170079248,170055553,170068856,170068150,170061333,170073382,170079850,170067464,170050888,170055448,170073597,170067795,170065627,170059599,170075407,170069221,170064138,170055227,170060926,170074872,170059130,170054904,170074879,170072764,170084685,170061688,170068248,170067461,170065388,170082265,170061332,170078757,170048865,170071370,170078502,170061854,170059614,170069396,170075046,170086550,170069127,170052145,170060516,170071356,170051785,170079852,170057554,170059128,170046775,170055834,170055815,170052411,170065623,170051580,170077149,170081514,170060907,170056706,170064142,170075471,170055857,170052160,170062431,170049905,170058214,170076742,170068554,170086533,170055849,170064169,170060206,170054675,170076730,170072145,170076732,170047772,170076725,170062439,170082939,170066005,170080685,170062737,170068314,170075472,170055824,170071358,170080691,170082266,170064178,170066015,170070337,170051229,170081324,170050880,170068837,170077752,170065647,170049261,170074461,170082929,170065390,170075482,170071387,170055832,170075054,170079866,170061313,170069386,170082652,170055847,170071368,170069218,170060524,170050009,170075050,170065376,170055825,170079878,170070039,170070340,170084681,170082673,170050375,170086554,170067478,170075338,170072972,170060892,170082678,170068555,170050370,170078406,170062424,170076062,170077784,170049049,170069402,170046698,170066028,170072760,170051563,170071379,170079853,170060928,170055844,170052448,170072751,170069249,170055836,170073833,170060912,170073823,170075719,170082674,170086537,170050859,170086559,170082101,170073828,170075340,170064759,170055534,170076426,170061330,170070034,170064742,170057557,170060914,170050541,170072957,170082931,170071354,170079265,170050878,170082571,170052159,170061324,170086538,170073378,170056412,170077759,170077779,170067034,170069134,170049262,170070333,170051260,170083454,170067469,170077144,170055228,170061361,170068174,170050895,170082654,170062736,170060529,170075475,170057545,170063076,170067033,170082671,170079145,170074874,170059127,170079244,170081517,170061310,170062735,170081071,170081838,170070339,170082948,170073812,170082478,170065396,170052416,170061312,170072139,170057558,170049255,170050892,170068699,170072960,170065367,170060918,170068068,170082684,170062080,170072980,170071382,170055535,170059132,170051789,170051565,170069401,170072758,170068559,170046787,170075724,170050893,170056439,170060212,170064746,170048860,170068867,170075476,170064166,170049913,170062083,170054700,170073591,170081211,170051791,170069129,170049898,170056438,170059138,170076746,170071375,170068625,170074850,170071361,170070037,170072748,170058219,170075721,170057544,170051259,170077767,170050867,170074863,170066001,170082687,170077043,170081209,170051788,170051595,170051590,170062433,170063304,170050279,170077769,170074472,170062413,170079268,170056306,170071351,170050283,170081717,170062738,170076057,170057561,170086551,170056452,170071353,170073375,170068175,170049254,170066031,170067013,170074865,170073815,170069132,170082567,170068861,170071374,170075720,170059596,170079856,170076070,170079234,170063297,170051255,170055554,170064133,170068841,170072982,170080697,170072010,170078490,170078487,170061346,170082656,170056437,170074458,170067038,170079155,170077146,170069139,170072140,170073587,170076438,170059136,170064767,170066045,170077042,170068561,170069120,170071383,170076058,170064765,170063075,170055530,170074484,170059118,170065650,170057240,170062075,170051239,170066037,170064156,170054691,170081607,170060536,170046704,170066016,170076718,170046776,170076723,170071345,170065387,170075341,170059648,170069388,170068866,170046777,170076743,170051241,170076434,170063068,170065641,170082945,170064770,170051569,170074869,170055537,170064741,170068176,170067673,170067466,170071355,170082100,170048869,170067462,170082675,170072754,170062445,170077145,170050865,170052168,170068070,170048783,170057179,170072977,170060217,170064739,170076429,170081721,170052435,170068854,170068863,170068151,170056767,170054685,170079847,170068315,170075740,170079148,170077143,170082099,170068624,170079862,170079267,170079253,170082938,170066054,170074456,170074473,170086558,170073832,170050015,170072749,170050863,170054224,170068622,170071389,170060211,170073596,170061318,170061349,170079147,170051247,170046779,170072007,170079144,170051238,170052158,170069709,170074474,170070112,170061851,170047807,170076721,170065654,170064750,170074464,170061353,170054905,170049240,170068700,170086542,170076060,170065646,170055555,170054669,170047842,170049256,170066038,170074877,170080695,170057547,170081597,170068852,170047770,170068302,170077148,170079876,170072961,170055226,170052150,170049914,170052425,170075473,170064123,170070372,170059115,170059598,170086534,170069387,170068562,170074457,170064131,170052439,170074873,170086525,170070103,170077780,170069699,170082672,170072967,170055137,170054981,170049266,170050890,170069188,170079262,170080943,170069119,170079250,170055557,170071357,170069711,170064151,170062742,170060929,170050540,170059604,170081098,170060915,170059631,170054663,170062440,170062739,170059108,170060505,170064154,170081070,170082688,170051242,170051576,170065368,170071380,170061696,170057241,170072147,170081096,170056434,170069399,170054667,170047840,170074860,170078571,170073581,170073813,170049910,170077753,170065621,170048174,170055829,170069700,170070553,170056769,170059635,170059135,170049253,170066046,170061309,170074875,170049265,170073384,170054223,170050280,170079235,170078758,170073366,170064745,170050282,170052419,170068704,170082661,170064159,170082381,170072274,170068560,170068703,170076055,170061853,170077138,170065375,170073822,170082949,170070114,170070045,170073821,170056429,170070329,170068623,170051269,170055531,170060519,170081095,170073583,170065370,170075339,170067474,170076443,170054091,170081831,170061315,170062746,170054513,170055140,170060925,170082003,170068316,170063078,170068245,170073374,170054226,170077748,170054093,170055539,170064769,170054515,170047845,170051783,170049238,170064163,170060506,170081606,170060532,170049900,170063074,170075479,170064140,170081609,170049267,170058447,170082004,170054514,170062078,170071366,170081720,170063312,170077766,170068301,170068619,170079851,170079249,170082479,170060904,170069698,170065629,170082683,170079154,170082663,170074478,170079255,170047778,170065640,170067015,170069248,170048777,170061319,170074861,170072765,170081066,170057004,170050539,170053968,170080543,170057546,170078500,170073824,170059125,170060546,170055540,170049917,170083453,170079863,170076728,170083457,170086530,170086532,170052157,170065631,170054672,170076445,170070374,170073582,170078501,170050856,170052412,170076072,170049901,170054518,170048859,170073808,170068069,170051790,170053969,170049257,170082005,170068312,170073825,170081724,170055843,170065382,170064758,170048856,170063298,170079256,170069220,170068698,170080546,170064744,170054903,170050364,170079838,170056417,170061311,170069706,170072761,170068838,170072767,170057009,170082930,170082653,170048855,170076433,170059613,170069393,170068071,170048784,170073589,170071350,170075726,170052165,170046778,170072971,170079848,170054696,170056764,170049237,170062451,170072013,170069136,170052432,170075049,170059630,170062749,170071999,170073816,170050864,170068868,170059597,170059624,170082570,170056686,170071363,170068319,170068553,170076737,170051579,170052171,170069404,170080945,170056778,170049899,170082267,170060542,170074486,170057008,170055850,170050016,170072018,170070101,170073590,170075349,170047812,170054680,170070107,170047805,170065639,170077765,170086531,170069693,170086561,170073592,170086549,170073588,170086536,170068706,170065633,170074854,170055450,170061364,170054677,170066050,170080702,170054909,170077790,170055145,170068318,170081722,170065398,170049247,170082011,170051794,170050372,170057013,170078473,170046700,170054908,170069710,170050868,170052170,170069412,170055833,170051233,170069403,170075348,170059618,170071388,170066058,170080690,170058212,170054227,170073814,170055230,170064768,170047843,170077758,170065397,170065632,170071386,170077771,170056737,170067020,170076735,170066018,170051568,170086529,170050011,170073602,170062444,170053971,170079247,170061357,170079855,170075477,170075734,170063072,170067021,170076437,170049916,170076071,170054979,170075336,170067794,170066017,170070338,170073580,170065649,170069692,170075343,170081830,170072015,170073599,170082937,170072978,170051278,170047766,170082566,170077785,170076734,170074876,170086541,170049245,170065643,170073387,170066012,170065620,170066002,170059116,170077147,170057176,170073373,170066040,170071367,170052148,170057552,170053966,170063070,170068865,170081608,170065395,170064186,170051256,170081215,170046703,170074866,170055845,170067016,170059137,170069137,170063291,170079239,170050866,170051591,170060895,170052143,170071348,170061307,170052156,170079153,170060509,170063067,170054684,170051246,170048776,170065366,170049897,170066026,170066032,170079241,170077046,170070113,170079252,170055821,170077783,170075053,170050858,170067027,170049246,170070038,170051232,170054217,170059117,170059600,170086548,170054566,170056777,170057011,170068842,170074853,170055449,170076447,170061363,170054676,170080701,170082932,170078759,170056304,170074864,170077757,170082010,170051792,170059622,170062748,170080694,170072150,170068705,170079152,170062438,170076436,170057012,170076068,170071381,170046699,170079875,170081212,170082685,170047844,170068853,170069708,170079269,170079854,170074471,170062086,170056447,170047769,170060902,170050901,170062426,170077756,170075744,170056435,170079272,170079236,170071377,170081516,170075728,170055846,170068309,170051257,170067472,170079251,170064125,170047809,170050014,170071352,170069701,170072003,170065625,170075346,170069397,170083456,170064740,170068864,170055835,170072149,170072000,170082655,170049909,170076067,170072763,170065394,170057180,170050900,170073831,170064748,170051587,170086528,170061362,170060933,170072012,170062447,170077787,170071378,170067041,170050882,170079874,170055828,170062079,170075733,170054906,170048778,170058215,170050873,170057007,170059106,170062414,170071371,170068313,170072004,170079263,170065622,170079864,170069250,170082006,170064174,170065652,170076066,170076731,170082569,170067471,170048173,170072955,170055556,170075047,170072975,170075725,170047768,170077754,170082682,170079872,170067039,170050881,170065372,170065655,170069135,170073367,170068859,170076435,170070375,170068300,170069707,170075730,170060894,170052167,170074482,170060543,170054662,170079849,170079150,170079871,170079271,170055456,170060520,170072956,170051578,170069191,170054225,170084682,170081605,170047811,170050374,170064134,170052444,170070111,170055458,170074463,170075345,170057239,170082947,170050368,170066042,170073383,170055143,170062453,170086547,170076745,170068850,170080700,170082946,170084684,170081836,170077755,170063079,170059113,170066013,170081205,170062747,170060221,170065651,170051574,170067018,170059134,170066057,170052417,170049263,170071373,170054980,170073830,170068172,170060903,170056448,170075729,170066056,170062085,170060545,170079149,170050899,170072009,170060917,170074481,170079270,170070110,170079264,170050284,170086526,170068311,170055841,170069251,170048868,170059629,170075337,170068839,170060535,170073829,170054517,170065393,170053967,170056418,170068835,170073600,170061335,170061359,170061316,170079877,170067031,170062740,170056445,170058217,170082660,170081213,170064152,170082568,170055457,170066011,170067035,170052144,170050897,170062745,170077751,170049241,170065626,170078756,170082941,170074878,170074870,170068247,170072759,170059619,170060891,170070104,170046702,170063300,170074476,170050891,170082681,170050861,170049907,170060916,170072006,170062449,170060893,170071369,170059621,170065391,170073827,170059646,170054702,170050013,170057238,170080707,170079246,170068303,170052166,170070334,170056449,170068173,170049908,170073380,170047775,170070554,170081835,170052440,170068858,170081596,170085971,170069872,170075481,170072976,170072146,170051226,170046708,170068701,170057237,170070373,170049242,170072973,170050366,170055558,170066049,170051240,170068855,170082665,170081068,170074479,170059605,170055533,170082572,170061331,170075480,170069704,170080693,170050896,170062084,170075742,170055455,170080547,170061812,170059615,170060544,170061321,170081548,170067030,170066044,170054907,170067014,170065297,170066047,170049915,170054218,170055856,170070108,170067674,170072974,170054681,170073585,170059139,170064168,170054516,170078568,170048782,170070036,170078410,170071385,170083452,170055536,170061356,170081833,170081603,170061314,170066014,170051787,170082943,170057178,170060219,170054567,170070462,170064763,170076432,170075408,170071365,170050365,170047804,170078573,170069131,170060517,170052147,170066035,170055816,170047774,170080692,170076431,170052164,170058216,170079870,170056415,170068307,170080686,170075474,170055826,170078489,170074477,170077141,170062077,170082679,170071364,170060534,170052146,170074490,170068558,170082927,170068833,170046774,170081595,170049048,170072756,170059623,170057556,170082657,170079839,170070106,170051231,170050894,170064139,170076724,170069130,170052163,170065389,170063077,170073826,170054668,170064167,170078503,170076063,170079869,170059131,170054664,170060530,170051562,170072143,170069411,170078408,170049902,170055822,170072138,170050862,170071346,170064164,170076716,170071349,170074848,170056766,170069128,170061852,170064743,170074852,170072979,170059647,170081716,170052169,170054683,170051228,170081097,170084683,170055831,170055451,170051572,170068840,170082940,170086555,170050855,170047841,170081322,170082103,170076727,170070105,170076744,170050260,170056451,170064145,170072762,170060906,170073584,170075731,170067019,170063071,170082686,170082659,170077768,170059607,170072011,170067475,170069410,170065645,170071360) 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'