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 (170037547,170037551,170008082,170018703,169887785,170012843,170013825,170030423,170018704,170037546,170030424,170021188,170013145,169999298,170037550,170037549,170032261,169887784,170006107,169999299,169887783,170022224,169993365,170035060,170039484,170020808,170018564,170037548,170018705,169887781,170034803,169887782,170001641,170000618,170037038,170012392,170035907,170012391,170012393,170004316,170037418,170012390,170012394,170037419,170012389,170004317,170030286,170030167,170030166,170035906,170035905,170001640,170001639,170028885,170000081,170000068,169999861,169999860,170036308,170033532,170009133,170009132,170034172,170033535,170000080,170009131,169884738,170034171,170014310,170001599,170007933,170009784,170014896,170014892,170013093,169993847,170014088,170014321,170035860,169989687,170035870,170020056,169993979,170014331,170029946,170012572,170001593,170037512,170007404,170001603,170027094,169999308,170027095,170001598,170034071,170010867,170035437,170020072,170031564,170038356,170035867,170014318,170007947,170031536,170035435,170038376,170009788,169999302,170001592,170009785,170013095,169993850,170007396,170013108,170018697,170037480,169989682,170018737,170034809,170020057,169989685,170035859,170031540,170018738,170001601,170007946,170035436,170035869,170001590,170014327,170014320,170032184,170014311,170017651,170034070,169993848,170039369,170008697,170013100,170014897,170018739,169993983,170014090,170014093,170014317,170031563,170014315,170007932,170014332,170001589,170007938,169993981,170010865,170038357,169940484,170013097,170010856,170014330,170032182,170014087,170039368,170027097,169999306,170010862,170018734,170035432,170014314,169993849,170007943,170039372,170035438,170014313,170026715,170008696,170014322,170007931,170010857,170008936,170034811,170008691,170030012,170039498,170020075,170037484,169940482,170007399,170027093,169989684,170035868,170035861,170020055,170032185,170017653,170034807,170026718,170013107,170010859,170007934,170013098,170034072,170010861,169940485,170038359,170007401,170034812,170029871,170034068,170030016,170017649,170007948,170020074,170008933,170037482,169999307,170026736,170001602,169993982,170010866,170009786,170012573,169993851,170007407,170014328,169989688,170020053,170030014,170039370,170030001,169989686,170027096,170008935,170039371,170013101,170029870,170007408,170007940,169999304,170009787,170018735,170012571,170014319,170014089,170008931,170013102,170014895,170008690,170007409,170014329,170032189,170038358,170007406,169993996,169940481,170008934,170013096,170030015,170007939,170007945,170007944,170035434,169999305,170034808,170018736,170029943,170031541,170014894,170034067,170032188,170034069,170007405,170012634,169940483,170035857,170020073,170029869,170035433,170014316,170010858,170007398,170035856,170026717,170008698,170039457,170035866,170037481,170026716,170030013,169993980,170010863,170032183,170014893,170012570,170020054,170009783,170012565,170007400,170008932,170017652,170035858,170007930,170013094,170007397,170007937,170029867,170034810,170010860,170035865,170013106,170035431,170031539,170014312,170009782,170038355,170007403,170020071,170014326,170027092,170035430,170008695,170007929,170039367,170007941,170001591,170020058,170010864,170001594,170029868,170037483,170001600,170012569) 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'