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-04-19' and '2025-04-23'
and t.termin_id in (169919686,169921659,169920426,169899102,169917665,169896976,169913508,169921798,169905432,169901217,169918930,169917096,169907378,169921437,169912486,169920428,169915452,169907738,169928385,169925215,169896352,169900444,169918478,169897269,169907379,169913199,169903937,169904858,169903939,169896978,169904857,169918932,169928384,169897272,169908542,169926169,169901731,169900443,169930851,169912583,169902312,169896359,169894354,169894356,169924779,169921436,169917336,169905434,169918934,169903934,169900439,169901728,169920103,169920429,169918935,169923593,169925209,169915449,169933086,169917093,169904561,169894367,169896975,169913509,169919253,169901219,169911400,169921658,169920424,169930270,169904856,169908541,169903936,169894365,169933297,169912585,169917662,169906197,169911399,169921802,169892889,169920427,169903935,169904854,169926346,169906211,169921803,169926747,169928381,169915451,169894355,169900787,169918924,169902995,169930277,169933302,169924778,169905423,169908543,169894368,169896977,169932744,169930853,169920434,169902324,169930274,169901214,169892946,169902993,169921661,169897270,169906210,169926749,169901732,169932633,169921801,169892947,169906204,169907380,169901222,169930275,169923591,169913192,169920433,169894366,169924776,169907372,169902323,169925577,169913194,169918929,169904859,169926746,169902319,169901213,169906203,169918476,169918928,169933298,169917668,169917669,169917339,169901220,169900440,169930849,169913191,169918481,169926413,169892893,169900796,169895926,169917095,169907375,169926745,169899107,169923594,169892894,169918936,169915970,169908544,169919689,169918482,169925212,169926743,169906207,169900788,169918474,169900794,169926168,169928382,169930276,169924780,169894369,169930269,169932634,169918933,169902992,169919256,169905430,169902314,169892887,169906198,169906219,169920104,169921804,169896354,169913512,169913513,169932748,169919257,169932637,169899514,169912489,169925581,169933300,169900441,169892948,169920107,169917671,169899103,169906214,169904855,169917092,169915454,169931193,169921662,169930278,169903940,169917340,169892892,169931190,169906217,169901216,169913510,169919690,169915968,169933088,169931195,169917670,169907376,169896358,169902321,169904554,169906218,169906215,169917661,169917666,169912488,169932746,169903933,169902994,169926744,169894363,169918480,169911401,169930852,169894360,169921800,169930850,169906213,169901211,169902325,169894362,169931196,169913193,169932636,169895925,169900789,169925580,169915969,169933299,169926418,169905433,169920106,169925518,169905422,169925214,169899098,169901221,169915453,169906212,169915966,169907377,169933108,169917664,169905424,169926417,169900442,169931189,169894364,169918479,169906209,169896353,169923592,169919255,169895924,169929417,169912487,169900795,169920105,169901730,169906208,169917094,169897271,169892945,169917667,169906216,169902991,169917337,169917338,169925213,169901218,169918931,169899097,169919688,169921660,169928383,169925579,169892890,169930273,169933087,169902320,169906206,169892891,169894361,169903932,169896974,169918477,169915967,169906205,169919254,169892944,169926750,169907374,169924777,169931194,169932745,169895923,169901215,169901735,169921435,169904553,169905431,169930272,169913511,169925211,169926167,169925578,169919687,169907371,169906202,169907373,169894359,169920425,169925519,169906201,169903931,169892943,169930271,169905421,169894357,169926415,169894358,169899513,169907737,169918475,169926414,169911402,169921799,169915965,169933304,169906200,169904552,169917663,169892888,169915450,169899106,169908540,169918926,169919252,169903924,169925210,169906199,169913190,169923590,169913507,169919251,169895922,169912582,169928380,169901212,169918925,169912485,169915964,169892942,169905420,169899101,169917335,169908539,169904559,169933085,169906196,169919685,169902326,169911398,169920423,169902311,169905429,169926412,169932747,169928379,169903938,169907739,169912584,169926416,169918927,169912586,169904560,169929418,169932635,169901729,169907736,169921434,169899512) 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'