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-06-18' and '2025-06-25'
and t.termin_id in (170355529,170320331,170365350,170360459,170313314,170346698,170357367,170339672,170314496,170368048,170340934,170355530,170345296,170302550,170358147,170339674,170304078,170344404,170355884,170314497,170292507,170302553,170328893,170365353,170312375,170362927,170347489,170346697,170361650,170346690,170337177,170358662,170347930,170359455,170358397,170339403,170340461,170361376,170370837,170346908,170346685,170304708,170358976,170370830,170364730,170345301,170319455,170360464,170320780,170327965,170355533,170339666,170321337,170346694,170366059,170369474,170350997,170361645,170313812,170346911,170358969,170316081,170344924,170321902,170318876,170300347,170355090,170359458,170362928,170338938,170314167,170328165,170310662,170343688,170338941,170358975,170307681,170360010,170349565,170364740,170355532,170362531,170347932,170363218,170361648,170329372,170358402,170339402,170339668,170315635,170349568,170346696,170348569,170347490,170355883,170312964,170306978,170371774,170361653,170366069,170371768,170345293,170369473,170360877,170361151,170366062,170362033,170360460,170364732,170361646,170358970,170360470,170365351,170342254,170326437,170341338,170361817,170288455,170358971,170349700,170349702,170355059,170346909,170346692,170308247,170318408,170368640,170339408,170362524,170371771,170346693,170355528,170343897,170334823,170312696,170342255,170358972,170318407,170357729,170358663,170346907,170355531,170301947,170307808,170319211,170352435,170336775,170334821,170359453,170368641,170323927,170339667,170366067,170352436,170356809,170312176,170344929,170338939,170355234,170342251,170287994,170360461,170355089,170360879,170365352,170360012,170362527,170360014,170347928,170347491,170342493,170346689,170342253,170365070,170291861,170371145,170364398,170371773,170323857,170306316,170336777,170370834,170337176,170364120,170357728,170365072,170339407,170365356,170291244,170368047,170326057,170360463,170355232,170350998,170326436,170337172,170369496,170346699,170340935,170361651,170360471,170317825,170355881,170362522,170364737,170343682,170359460,170367838,170308978,170363510,170360466,170358974,170343898,170344402,170346376,170364733,170355882,170369494,170358400,170321901,170360462,170361377,170365071,170359454,170344928,170341339,170334825,170359456,170360469,170346380,170336774,170365357,170313313,170358398,170334663,170344921,170308249,170316082,170334826,170362525,170360013,170349171,170358967,170346688,170340939,170319210,170315049,170361818,170345300,170365349,170371770,170340933,170347493,170304089,170298691,170305740,170370831,170315050,170359789,170297184,170312963,170320776,170346379,170292975,170299506,170361644,170349567,170315634,170371769,170295566,170301432,170364741,170337171,170320775,170295565,170314495,170336776,170360467,170361375,170317823,170355091,170346687,170364739,170361819,170337169,170344405,170299872,170366063,170362931,170296491,170365354,170362523,170355527,170302680,170366068,170368642,170364402,170342256,170349701,170340464,170366064,170359461,170365360,170362528,170360011,170340460,170334822,170360468,170361371,170311312,170337174,170361652,170336780,170313491,170299347,170369475,170349566,170365361,170329371,170372599,170367837,170336779,170337170,170318585,170364734,170369495,170317824,170314166,170297191,170307337,170360016,170352439,170344930,170339676,170370829,170343681,170370833,170338940,170346686,170346378,170355231,170335299,170338936,170344401,170352434,170366058,170337168,170355088,170369497,170360009,170346906,170347927,170369493,170347929,170344920,170321903,170342861,170347486,170344923,170361649,170357515,170347492,170362530,170364735,170362930,170340459,170348567,170346375,170364731,170365359,170338937,170344927,170320777,170340463,170352438,170339675,170370836,170339406,170365358,170336778,170362529,170346912,170340932,170359459,170360015,170343684,170347931,170346695,170371772,170362929,170360465,170357516,170345292,170364400,170352437,170366061,170339405,170313490,170370832,170358973,170361374,170334824,170365355,170344922,170364736,170366070,170364738,170328164,170295567,170300358,170344403,170346377,170355060,170312485,170347487,170358401,170344931,170321467,170291862,170339673,170357368,170358145,170364121,170346910,170370835,170361152,170364399,170361373,170363219,170370897,170359457,170342252,170342862,170343689,170355233,170346691,170358146,170345294,170339404,170366060,170358399,170360878,170361647,170347488,170361372,170363511,170361369,170339671,170343683,170364397,170358968,170364119,170337175,170362526,170364401,170361370,170371146,170359790,170345295,170305750,170337173,170340462,170356810,170311628) 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'