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-09-07' and '2025-09-10'
and t.termin_id in (170863238,170844833,170852457,170855755,170855452,170859115,170838574,170846562,170842234,170864184,170847124,170864985,170850847,170840227,170845872,170744938,170846563,170855751,170850850,170847123,170850849,170847118,170855753,170855754,170859116,170856261,170869951,170863567,170869608,170850359,170784973,170863569,170859884,170850848,170856263,170863568,170859883,170845232,170864986,170856262,170857808,170859882,170847122,170789700,170784972,170880882,170871125,170853250,170878436,170869950,170846561,170843451,170864404,170856260,170859881,170862838,170876466,170878216,170864334,170862656,170843002,170853842,170855752,170845963,170863237,170851750,170854179,170854400,170860216,170860049,170873865,170864775,170875573,170841840,170857253,170873004,170873861,170873005,170853648,170873860,170869474,170868122,170880686,170869475,170856119,170873001,170874686,170877436,170870063,170868123,170873452,170875983,170862195,170880688,170860693,170869819,170849343,170850278,170853637,170875985,170875523,170845737,170874811,170866315,170877583,170868349,170856889,170848344,170860694,170875984,170873011,170874812,170880437,170845173,170875524,170870061,170853635,170857255,170848342,170856574,170862196,170873862,170856571,170853647,170864791,170846923,170859123,170859611,170854577,170873002,170843326,170856575,170866314,170849347,170847459,170856886,170860050,170856887,170871048,170858142,170852145,170853638,170845168,170856118,170847458,170880417,170848343,170859614,170869822,170846919,170843325,170849339,170859124,170844012,170841191,170878102,170841837,170864777,170844736,170856573,170869818,170873866,170873007,170873454,170866321,170866320,170854291,170841194,170844735,170873009,170841843,170843324,170862397,170858438,170855290,170849032,170875522,170841841,170866317,170847461,170875986,170864789,170873012,170873858,170845736,170870064,170856577,170869476,170856890,170876560,170863914,170873463,170863221,170845738,170873003,170877584,170873462,170842842,170858139,170856117,170873457,170864788,170873460,170846346,170871262,170878103,170853649,170856576,170876564,170857664,170855291,170854294,170874814,170842204,170848585,170874687,170849346,170859125,170854580,170875575,170847462,170841842,170879987,170849342,170855867,170877434,170873010,170873461,170871047,170879561,170855295,170849345,170866319,170864778,170844011,170869821,170857254,170856888,170871049,170845169,170857663,170851714,170876123,170859613,170864787,170854293,170873864,170841836,170855296,170880687,170848580,170866318,170874813,170849344,170864790,170854579,170875574,170880685,170860051,170873008,170873459,170859300,170862396,170873863,170864779,170844010,170857662,170858437,170873458,170873006,170877437,170876559,170846922,170863219,170863912,170862763,170862194,170844730,170879560,170869820,170877582,170842841,170841839,170876122,170851713,170858138,170868127,170853374,170854292,170842573,170853636,170848584,170866316,170873456,170854578,170877435,170847460,170841838,170879986,170862395,170855866,170864776,170873455,170868126,170856572,170849340,170863911,170862760,170863365,170862200,170844009,170845735,170868348,170856885,170879559,170877581,170880436,170848341,170853373,170878101,170858436,170857661,170853375,170864774,170859122,170875572,170873453,170862394,170868121,170879984,170854877,170849031,170852144,170859612,170846921,170853376,170875521,170876121,170864780,170876124,170863913,170863220,170844733,170870062,170880416,170849341,170873859,170879562,170871050) 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'