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 '2024-06-15' and '2024-06-19'
and t.termin_id in (167696116,167689745,167704876,167679491,167679487,167687824,167694344,167696123,167716552,167679131,167714780,167705720,167709680,167694650,167693689,167704171,167716313,167711000,167687746,167710996,167694348,167713247,167701972,167714173,167714775,167688879,167714774,167715354,167700221,167710993,167698126,167697087,167688401,167688878,167693167,167694122,167701741,167688880,167694894,167697437,167719308,167707137,167691228,167697083,167713785,167699969,167705239,167719311,167714716,167688403,167483259,167702251,167694347,167698124,167696118,167689746,167716312,167704689,167687825,167706907,167688404,167706909,167719309,167716551,167711005,167714174,167704877,167702841,167694647,167698123,167713788,167712609,167696117,167695208,167717915,167695760,167712938,167691231,167697440,167697438,167695210,167705718,167719064,167702254,167706652,167707475,167687491,167713245,167701743,167714651,167689378,167712937,167697700,167705725,167695209,167714179,167707630,167706651,167718226,167699966,167687768,167714182,167694346,167695764,167712936,167694119,167701333,167695765,167713244,167704690,167637258,167714177,167694651,167715352,167694120,167699967,167679486,167696382,167715742,167707140,167714445,167714776,167719063,167710992,167707660,167688881,167696294,167697086,167702842,167696292,167696293,167719068,167705721,167687826,167716054,167715737,167698125,167693166,167637257,167718224,167686049,167714783,167694893,167715740,167700530,167699970,167712605,167717160,167679488,167706915,167707139,167693175,167715350,167679489,167700528,167692029,167714449,167705238,167702840,167714175,167717494,167697433,167706913,167714181,167715351,167707854,167700527,167687748,167714782,167689750,167714650,167705236,167717226,167712608,167706906,167679835,167709679,167693164,167705726,167702839,167714781,167707631,167693172,167637584,167694895,167679493,167717495,167694896,167717919,167696381,167717917,167701336,167702252,167687747,167714778,167718225,167694648,167705717,167693165,167719312,167716218,167701968,167697702,167692153,167715982,167716219,167714777,167704521,167711004,167691416,167704879,167714448,167693174,167701744,167687769,167712607,167719310,167715738,167710998,167688402,167712606,167702253,167691229,167706916,167706912,167693173,167709131,167701973,167705531,167688400,167693163,167693687,167707853,167719069,167716055,167718223,167705719,167719067,167689376,167717493,167698556,167713820,167705237,167707141,167694897,167717496,167707632,167712978,167694123,167697704,167703382,167689379,167710999,167688882,167704522,167697084,167707855,167715353,167714180,167701538,167713246,167693688,167707471,167700529,167697703,167679492,167679132,167714630,167701969,167717918,167719066,167718414,167692100,167714447,167714178,167692008,167706908,167715739,167691230,167637259,167701539,167679490,167694649,167694121,167697085,167706914,167697436,167713789,167687645,167699968,167719065,167713821,167707138,167714446,167717916,167716895,167714176,167700526,167710997,167707474,167694345,167696122,167716896,167701742,167709681,167715741,167715981,167695766,167697439,167689377,167679495,167701974,167704878,167714779,167695759,167697701,167698336,167717524,167704740,167707636,167710763,167707635,167714193,167714799,167714797,167714196,167714194,167714190,167714197,167716744,167714801,167714624,167694675,167715357,167710764,167714798,167716706,167714195,167714191,167714189,167694676,167714800,167707637,167714192,167698337) 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,828,159032779,3138320,685,3308890,27722768,159032776,690,5177115,167341712,86558852,68181750,158652367,660,797,90722560,674,114793025,576,523,159032782,155235885,29833136,28701456,730,575,137006144,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'