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 (170000207,170034104,170018681,170022101,170014399,170036819,170027124,170035056,170025394,170027851,170034107,170037884,170012783,170035045,170022446,170029349,170025709,170037689,170027841,170027113,170023171,170025708,170025391,170023569,170027336,170029297,170005969,170029300,170027338,170023570,170012786,170010164,170025392,170007616,170037253,170036869,170025702,170027125,170027121,170036870,170023568,170007613,170023174,170036871,170023175,170010572,170012787,170037254,170025701,170010162,170022104,170027838,170029299,170029461,170022444,170034946,170010568,170037256,170028088,170035047,170010566,170029460,170002873,170005975,170028095,170027852,170027837,170023563,170007615,170037691,170019043,170018680,170022102,170027842,170027340,170019045,170029459,170028097,170019047,170007614,170028092,170037257,170036872,170036816,170000205,170028089,170037688,170000206,170023566,170035053,170023167,170025395,170023177,170023178,170002872,170023571,170034109,170035048,170029458,170035050,170002869,170027849,170014768,170028098,170029301,170036873,170014392,170014767,170012788,170022103,170035044,170014393,170022098,170027848,170018748,170030652,170030650,170023176,170035051,170022445,170034108,170029457,170036874,170014769,170027339,170028096,170037690,170027337,170028094,170025704,170023564,170025707,170005967,170028093,170010571,170018747,170022099,170010165,170014391,170035057,170025706,170005974,170010167,170037883,170037255,170023173,170027850,170027840,170002871,170025705,170036817,170029298,170002870,170019046,170022100,170027335,170019048,170036818,170025393,170012785,170034106,170010166,170035049,170010570,170027123,170030651,170022443,170027839,170022442,170028091,170023567,170027846,170007612,170025396,170012784,170025703,170014771,170034105,170028090,170010569,170027122,170036820,170023172,170019044,170023169,170023562,170030653,170000204,170027847,170035046,170010168,170005968,170014774,170029348,170029347,170023565,170037252,170023168,170014396,170023561,170022097,170030649,170022441,170002868,170007608,170005973,170023560,170000203,170028087,170014397,170035052,170023170,170014766,170018582) 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'