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-02' and '2025-05-07'
and t.termin_id in (170018538,170004263,170036798,170008812,169989989,169999407,170004319,169998748,170030974,169999411,170030973,170026630,170012340,170006596,170037576,170030161,170036797,170030972,170005634,169999408,170036796,169989986,170030988,170012103,170008816,170039162,170034776,169989990,170012106,170021155,170005633,170004262,169998750,170004775,170012343,170030265,170012102,170034773,170004772,170039163,169989991,170021156,170035184,169987852,169993714,170026629,169998206,170031193,170004320,170031190,169998746,169989987,170012107,170030162,170008815,170031020,170012105,169998749,169999409,170034775,170008813,170004318,170031189,170004773,170037575,170031192,170031449,170008814,169999412,170012104,169998747,170034774,170004774,169989988,170031191,169987851,170038290,170026628,169998205,170030264,170030163,170038291,170031448,169998745,170030263,169999406,170006595,170021154,170008811,170037574,170037069,170001557,170007098,170009422,170007101,170001556,170037008,170030407,170018684,169989054,170012109,170004252,170009421,170035824,170012112,170012113,170031107,170020631,170009419,170014080,170014888,170020636,169993690,170009414,170004364,169989053,169989980,170001555,170004250,170031505,170007100,170004251,170031108,170031109,169993691,170020634,170031246,170009420,170013646,170020628,169989055,170031110,169989981,170031507,170035825,170009425,170013647,170037070,170009423,169989979,169989982,169989050,169989984,170031111,170014083,170012114,170004365,170037287,170020630,170013645,169989983,170030364,170020632,170037260,169990218,170007096,170037261,170030270,170031245,170026729,170007099,170014082,170020635,170004248,170037068,170037067,170018686,169990217,170009048,170014886,170009417,170014081,170037007,170020351,170031506,170012111,169989052,170026728,170035823,170018685,170030269,170020629,169990216,170030406,170012110,170020350,170004249,169989051,170007097,170014885,170026727,170009416,170009424,169990219,170035822,169990215,170009415,170026730,170020349,170009418,170031106,170031244,169993692,169993693,170009047,170004363,170001558) 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'