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-11' and '2025-05-14'
and t.termin_id in (170062159,170067208,170049979,170053981,170059056,170077702,170082580,170062838,170074777,170052111,170057063,170079772,170081869,170065970,170057213,170061220,170056275,170079430,170054533,170054534,170067605,170053904,170064286,170082055,170079774,170069739,170056272,170065967,170056793,170065965,170077700,170053813,170053989,170075539,170054769,170068586,170075842,170061226,170075074,170076527,170051340,170080988,170074345,170076194,170079422,170070153,170059718,170071621,170069435,170082974,170080811,170062158,170056204,170073545,170063136,170069063,170072993,170072080,170062156,170068663,170074347,170064823,170055957,170073299,170053979,170067922,170082971,170054532,170073872,170076878,170081079,170081868,170051818,170055947,170079425,170049975,170081755,170067225,170048932,170050787,170086474,170069988,170052457,170053906,170064282,170070154,170051346,170056205,170075073,170055634,170057069,170055391,170054760,170055963,170075844,170056239,170076876,170049977,170062154,170068573,170054768,170071620,170053814,170048791,170084691,170060978,170071619,170057067,170068877,170056532,170076874,170052456,170062524,170055390,170079771,170056531,170081196,170062514,170061225,170082579,170073543,170054762,170079426,170051611,170075075,170067923,170060612,170061222,170068575,170067602,170080990,170046724,170068878,170076200,170069433,170072992,170053812,170085965,170085967,170076873,170081656,170058347,170048792,170068363,170058348,170079429,170078804,170074344,170062840,170075845,170064818,170075544,170061223,170064287,170050263,170082972,170046727,170071622,170055158,170061921,170054948,170067226,170055151,170079423,170076530,170055165,170060979,170064271,170058349,170078807,170080809,170065966,170069059,170076199,170064819,170067224,170075249,170056206,170051356,170068582,170060611,170068583,170064281,170081756,170051617,170076193,170067940,170086465,170054770,170058350,170080989,170067606,170053983,170075076,170055159,170048794,170076879,170073874,170072081,170067604,170048793,170079421,170084335,170049974,170059053,170051345,170051618,170063137,170079431,170056530,170060613,170056529,170058301,170080810,170076872,170072995,170049197,170055631,170050790,170049196,170054155,170062513,170050275,170056792,170051352,170050788,170067607,170065410,170062523,170051360,170067941,170065669,170046726,170067227,170063138,170075540,170050277,170068243,170068876,170049195,170074346,170082056,170048934,170052461,170058398,170077701,170064288,170076196,170064262,170073544,170055392,170062155,170057216,170064289,170064817,170081654,170069989,170059054,170067600,170056791,170073298,170046725,170075250,170049006,170060255,170084693,170060980,170073300,170057215,170061920,170064268,170054154,170083436,170053905,170065409,170075545,170080808,170057227,170057065,170065407,170068576,170053984,170053988,170086471,170059719,170065408,170065671,170062843,170049978,170075251,170067209,170056274,170054761,170055951,170083099,170049976,170069990,170076525,170086472,170082582,170069741,170068366,170062161,170060256,170052112,170049198,170077703,170064824,170075252,170073301,170075543,170059055,170063374,170060988,170074778,170067925,170076532,170054754,170067924,170052455,170054771,170083437,170082973,170082970,170051344,170065413,170055160,170057214,170067228,170065971,170062160,170062842,170076531,170067211,170074348,170073548,170064261,170073546,170057066,170057068,170062837,170052460,170073873,170068365,170076877,170086473,170076198,170060252,170054949,170050789,170053980,170072994,170048933,170078806,170062841,170071616,170069062,170055633,170063373,170064821,170065412,170059723,170053982,170069740,170051820,170079773,170065968,170063372,170069434,170073547,170064267,170061224,170068574,170065411,170062516,170068660,170076197,170060985,170076529,170082968,170069061,170082969,170083434,170071618,170068364,170069738,170055958,170076875,170062157,170068659,170070152,170064280,170084692,170078805,170062839,170075843,170055164,170057212,170052468,170073877,170068879,170071617,170081657,170076528,170074776,170051819,170081078,170085966,170081655,170052110,170081870,170082057,170065969,170062509,170055161,170058300,170086466,170075541,170076195,170069060,170060615,170083098,170056273,170061221,170067601,170070151,170064279,170068875,170063135,170051609,170075841,170081077,170048931,170081754,170076526,170049194,170074775,170067223,170069432,170073542,170071615,170058375,170049973,170072991,170057062,170051343,170057211,170083435,170055632,170062836,170054152,170055389,170064820,170049193,170060984,170067603,170082581,170075846,170049980,170064822,170052109,170075538,170067210,170051357,170085968,170054153,170079424,170057064,170056732,170052467,170075542,170055460,170074349,170072082,170052454,170073549) 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'