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-12' and '2025-05-14'
and t.termin_id in (170062159,170049979,170053981,170059056,170077702,170082580,170062838,170074777,170052111,170079772,170081869,170065970,170057213,170056275,170079430,170054533,170054534,170067605,170079774,170069739,170065967,170056793,170053813,170053989,170054769,170068586,170075842,170061226,170075074,170076527,170051340,170080988,170074345,170070153,170059718,170071621,170069435,170082974,170080811,170062158,170056204,170073545,170063136,170069063,170072993,170062156,170068663,170074347,170064823,170073299,170082971,170076878,170081079,170055947,170079425,170049975,170081755,170067225,170048932,170086474,170052457,170053906,170064282,170070154,170051346,170056205,170055634,170057069,170055391,170055963,170075844,170056239,170076876,170049977,170071620,170053814,170071619,170057067,170068877,170056532,170076874,170052456,170055390,170056531,170062514,170061225,170054762,170079426,170051611,170075075,170067923,170060612,170061222,170068575,170067602,170080990,170068878,170076200,170069433,170085967,170081656,170058347,170048792,170058348,170079429,170062840,170075845,170075544,170061223,170064287,170082972,170046727,170071622,170061921,170067226,170055151,170079423,170076530,170055165,170060979,170058349,170078807,170080809,170076199,170064819,170067224,170056206,170051356,170060611,170068583,170064281,170081756,170051617,170086465,170054770,170058350,170080989,170067606,170053983,170075076,170055159,170048794,170076879,170073874,170072081,170067604,170048793,170084335,170051618,170063137,170079431,170056530,170060613,170058301,170080810,170072995,170049197,170050790,170049196,170054155,170062513,170056792,170051352,170050788,170067607,170065410,170062523,170051360,170067941,170046726,170067227,170063138,170050277,170068243,170068876,170049195,170074346,170082056,170048934,170052461,170077701,170064288,170076196,170064262,170073544,170055392,170057216,170064289,170069989,170059054,170046725,170075250,170049006,170084693,170060980,170073300,170057215,170064268,170054154,170083436,170053905,170065409,170075545,170057065,170068576,170053984,170065671,170062843,170049978,170075251,170067209,170056274,170054761,170055951,170083099,170049976,170069990,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,170052460,170073873,170068365,170076877,170086473,170076198,170054949,170050789,170053980,170072994,170048933,170078806,170062841,170069062,170055633,170063373,170064821,170065412,170059723,170053982,170069740,170051820,170079773,170065968,170069434,170073547,170061224,170068574,170065411,170062516,170068660,170076197,170060985,170076529,170069061,170071618,170068364,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,170057211,170083435,170055632,170064820,170067603,170082581,170075846,170049980,170064822,170067210,170051357,170085968,170054153,170079424,170057064,170056732,170075542,170055460,170074349,170072082,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'