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-29' and '2024-05-01'
and t.termin_id in (167352785,167352440,167367630,167371234,167352872,167370943,167347191,167367614,167376353,167372772,167360411,167358144,167368611,167345218,167366381,167365542,167374189,167373459,167376161,167361801,167347275,167365827,167364980,167371227,167377894,167348361,167358148,167367192,167371742,167358472,167368994,167349987,167371223,167360408,167368464,167375189,167368465,167363159,167353418,167359234,167349985,167373730,167344929,167361480,167343666,167365487,167368610,167351905,167367905,167371734,167379553,167362083,167361214,167343186,167370009,167357721,167372785,167348161,167372573,167376062,167373305,167380534,167369772,167343858,167358141,167354571,167343387,167348962,167376358,167373727,167364330,167343386,167348166,167374203,167357157,167377498,167353874,167353270,167370073,167353419,167354572,167364331,167370212,167363369,167370940,167346260,167347821,167345805,167354852,167369374,167376965,167376166,167375499,167348359,167353121,167360625,167353878,167351389,167365355,167363510,167367193,167355429,167344366,167358470,167356027,167354573,167376973,167347193,167349972,167372008,167344920,167376583,167348162,167364970,167366627,167359535,167379519,167368219,167360629,167370360,167372171,167361215,167360630,167373303,167370216,167374207,167362384,167364979,167372172,167376691,167377900,167368980,167357134,167373712,167347452,167369375,167349983,167366629,167366527,167372932,167379522,167357158,167356345,167360905,167369377,167371236,167375739,167346267,167362386,167373449,167343559,167360155,167370215,167345810,167343829,167367619,167343667,167343860,167360158,167372582,167351374,167376692,167379868,167371996,167372177,167351138,167357722,167358475,167354981,167348958,167361799,167364326,167356023,167362382,167363296,167356592,167354978,167355426,167349333,167358140,167379881,167379124,167367201,167376100,167367940,167383274,167376063,167354163,167354979,167347837,167359233,167349989,167374202,167372931,167353124,167373293,167362761,167371221,167342931,167380537,167376966,167348351,167369664,167359230,167360407,167371232,167359231,167349337,167368083,167362385,167376065,167366378,167347822,167376066,167365927,167379935,167369157,167347831,167376974,167348963,167359940,167348163,167379884,167376106,167366997,167377500,167376807,167368979,167351024,167379866,167372786,167367607,167357155,167379125,167377893,167368608,167347451,167349338,167348350,167205241,167354853,167353122,167368549,167368761,167343859,167356339,167354982,167352278,167370213,167374206,167357140,167358145,167349201,167356814,167356597,167380184,167343857,167345804,167366487,167379129,167353053,167379521,167353271,167368274,167370105,167353877,167354984,167356596,167370939,167356340,167361474,167357719,167359534,167352871,167355752,167358473,167351471,167347192,167363511,167351637,167368081,167362383,167363330,167370214,167359781,167373729,167368607,167347820,167366204,167368080,167363794,167365804,167361475,167368547,167354569,167365351,167349199,167343665,167349244,167351740,167360161,167359533,167346966,167362070,167353875,167342898,167374368,167368220,167363022,167352275,167351983,167373460,167368894,167366205,167357720,167376174,167380297,167360627,167368548,167348165,167344562,167348959,167352276,167350920,167347455,167371235,167344921,167351470,167361477,167354854,167352437,167346261,167370633,167363994,167360902,167348360,167360410,167349984,167376582,167372794,167349988,167352439,167376808,167376173,167356342,167368223,167372006,167376584,167368272,167370489,167359538,167342897,167371226,167343192,167357718,167355749,167347453,167356024,167351473,167343668,167365966,167351211,167376105,167376352,167363157,167368897,167375504,167376690,167367625,167371241,167374626,167344367,167362760,167345803,167344373,167371735,167361476,167346975,167361802,167344549,167359235,167379798,167368224,167375503,167371219,167346758,167376581,167354574,167357138,167347454,167352784,167373461,167374210,167352693,167373450,167361213,167373304,167367199,167345797,167373711,167381133,167351212,167366628,167356812,167356810,167369114,167350919,167368758,167353269,167356591,167343670,167376975,167354980,167365354,167360157,167351213,167377699,167367936,167346508,167368583,167346760,167375188,167366998,167362075,167376360,167359779,167357135,167360156,167343627,167366883,167363995,167355747,167370217,167360907,167369379,167368898,167356028,167361481,167353123,167345536,167359784,167353880,167351210,167366882,167348164,167353125,167205243,167342899,167349246,167368762,167369737,167370568,167373713,167343558,167370642,167354577,167375055,167352569,167359232,167357156,167370566,167354166,167343621,167363023,167374627,167345228,167351025,167344557,167376586,167351639,167346262,167368582,167377697,167346759,167346498,167371743,167359236,167380186,167354167,167376811,167380243,167383276,167363512,167364971,167368273,167374366,167363370,167371729,167368339,167380247,167354857,167359537,167368895,167376585,167372934,167369773,167370927,167370567,167344368,167351472,167354856,167369378,167346968,167362074,167343669,167360903,167354576,167360906,167380536,167356344,167354983,167372009,167368757,167343830,167344554,167376099,167342678,167374188,167379128,167347277,167345529,167371736,167361800,167344922,167347815,167348352,167367608,167354855,167376101,167380176,167354575,167363158,167348964,167372581,167367198,167380943,167351638,167363900,167365356,167343831,167368609,167356595,167371220,167356025,167361473,167356343,167369787,167355748,167351027,167362759,167347832,167361479,167371218,167367185,167364329,167345535,167374367,167368602,167351026,167373306,167368082,167373731,167376972,167352826,167367629,167347131,167198998,167343187,167342932,167379882,167367933,167375502,167345222,167381132,167368222,167366379,167363041,167373462,167355428,167368896,167369115,167365965,167365887,167356813,167342677,167377906,167346507,167359536,167379520,167349245,167370933,167368221,167379867,167379127,167369665,167346974,167349986,167374625,167368760,167362758,167365806,167363508,167359939,167354165,167376064,167380535,167346506,167344556,167348961,167370639,167352568,167370490,167375054,167349336,167356026,167375738,167368337,167377499,167359783,167370074,167376810,167383275,167358142,167380958,167352438,167353417,167350653,167342676,167368463,167369376,167352870,167346497,167347276,167348960,167357137,167376971,167344555,167368759,167353416,167346967,167362757,167362072,167349970,167375729,167374624,167360904,167365805,167364328,167355750,167371233,167360409,167346757,167354164,167367186,167345221,167376167,167368336,167372007,167375501,167349335,167352692,167353052,167379126,167380185,167381131,167365486,167377698,167365353,167379454,167346718,167374205,167367200,167362073,167379132,167368581,167367612,167368338,167358474,167360626,167198997,167343385,167365352,167379554,167380942,167357136,167359937,167373728,167343388,167367001,167349200,167362071,167376172,167350644,167345227,167364327,167370565,167375053,167363899,167358471,167370638,167351136,167355427,167346495,167354570,167346268,167351373,167364973,167376359,167353876,167375731,167359938,167205242,167380533,167347456,167350654,167366380,167363297,167362389,167345534,167359780,167375500,167374204,167363509,167374370,167375737,167351469,167371741,167359239,167367191,167375725,167365826,167361212,167381154,167349334,167344927,167372574,167374623,167376104,167360154,167376351,167376809,167377892,167370350,167359936,167350921,167367606,167357139,167353415,167345220,167354162,167370934,167380532,167362756,167363898,167376093,167374622,167360628,167359941,167372005,167345802,167351644,167363155,167371128,167375187,167376109,167370932,167356594,167363156,167346973,167352274,167374116,167373726,167366526,167356022,167367618,167367621,167353879,167375732,167363902,167356341,167373294,167358143,167352277,167364981,167363901,167342933,167346723,167368893,167344928,167377899,167367196,167363331,167357154,167366881,167363993,167198992,167351137,167361478,167379883,167350918,167356593,167347823,167355751,167359782,167349971,167356811,167345528) 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'