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-04-28' and '2024-05-01'
and t.termin_id in (167374592,167354055,167370201,167360097,167357679,167368596,167371164,167344303,167359649,167343757,167361170,167345313,167361168,167370908,167348324,167355935,167361770,167361172,167371169,167361432,167371167,167353023,167376917,167363477,167348325,167365114,167357956,167351438,167362715,167357677,167349929,167361169,167354330,167360865,167362301,167345550,167358348,167357954,167344643,167366395,167346557,167367142,167351439,167353367,167361768,167356555,167352455,167367134,167359647,167355934,167358988,167345552,167360366,167360866,167374589,167344987,167358349,167374407,167368593,167362304,167371703,167380328,167358984,167375697,167371704,167357083,167354331,167360363,167370200,167369165,167380413,167356232,167344304,167380330,167365113,167349926,167344644,167369907,167357953,167360096,167345312,167346276,167360364,167364290,167361769,167360589,167377884,167380411,167371698,167371168,167374590,167379219,167371172,167360867,167354058,167357078,167352663,167380412,167365112,167368595,167358989,167358986,167360365,167352199,167375702,167354943,167357082,167354057,167376157,167359874,167351440,167349587,167354056,167379221,167361430,167361431,167358985,167348322,167344645,167368594,167345311,167364292,167371706,167367140,167357957,167377885,167344646,167363877,167356554,167374593,167375436,167361433,167367135,167380329,167362716,167354329,167354941,167370525,167346274,167358350,167345316,167346277,167365111,167371705,167345543,167369910,167352200,167362303,167369976,167346565,167376329,167361171,167357081,167354672,167355363,167364291,167347943,167344988,167347414,167356233,167353813,167359876,167349586,167349928,167345793,167371173,167363879,167379220,167374591,167344986,167364289,167380327,167349584,167367132,167376918,167369909,167357080,167357678,167355362,167354671,167371162,167371165,167371157,167362714,167349585,167353812,167359875,167361960,167345792,167354942,167362302,167345551,167348323,167356553,167349927,167360095,167370526,167370909,167347412,167346996,167376326,167371699,167343758,167363878,167369908,167357079,167367133,167377882,167376158,167354944,167353811,167346275,167371161,167354328,167360864,167345791,167367926,167354670,167360094,167375700,167361959,167379218,167356552,167355361,167360588,167361767,167359646,167351437,167346995,167357676,167376154,167344301,167376916,167377877,167367141,167366861,167367139,167377878,167345794,167347413,167346562,167357955,167376919,167346999,167346561,167358987,167344302,167366862,167359648,167377883) 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,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'