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-01-04' and '2025-01-08'
and t.termin_id in (169131394,169151165,169135236,169122559,169137851,169123692,169142457,169128701,169082104,169129149,169123710,169142961,169125220,169144245,169126429,169127647,169122560,169074089,169143007,169132439,169125956,169087203,169127646,169067497,169111099,169120927,169128703,169141372,169134747,169146540,169138494,169142931,169124112,169125325,169132295,169132092,169144306,169132436,169146495,169126368,169128514,169130754,169144312,169135239,169126626,169122603,169123532,169131397,169128560,169120926,169082103,169144244,169142445,169142446,169130752,169074088,169132438,169142960,169114362,169120925,169141371,169146558,169138493,169142930,169126181,169122624,169129379,169140783,169129138,169134317,169124111,169125324,169132303,169126625,169146494,169124110,169152195,169151219,169122602,169123531,169136224,169144310,169128559,169120924,169136484,169130746,169087201,169082102,169144309,169129137,169142929,169142959,169126428,169128512,169130750,169152199,169141370,169132437,169143005,169137849,169122558,169111098,169134745,169138492,169126180,169114360,169125340,169120923,169139959,169131091,169132302,169129381,169143004,169125954,169127635,169123690,169135668,169123530,169126624,169122565,169135669,169131395,169131096,169114368,169129698,169123708,169142958,169144242,169120339,169129136,169111097,169122557,169124116,169142928,169146539,169127634,169122623,169114359,169132301,169127179,169152194,169151166,169130748,169143002,169125953,169123689,169123529,169122601,169128557,169120922,169131101,169129699,169120921,169125322,169129134,169134314,169131100,169138488,169120342,169114364,169132435,169125230,169152193,169129135,169123696,169144241,169128510,169132091,169126622,169126427,169120702,169143001,169135235,169120337,169137847,169122556,169142927,169146556,169129378,169121444,169114358,169151164,169144304,169143000,169142443,169067496,169087202,169127641,169123688,169129697,169123528,169122600,169131393,169135237,169138487,169146493,169114365,169136222,169122564,169138495,169126623,169111093,169125323,169132093,169134315,169122607,169144313,169082101,169132094,169134316,169144308,169137850,169131099,169120341,169142957,169129613,169143006,169120338,169122563,169138491,169127643,169123697,169121446,169122606,169134746,169132090,169136221,169128699,169132095,169140784,169144311,169152196,169120340,169135238,169121447,169121445,169129380,169144307,169137848,169120336,169128511,169111092,169128556,169134318,169140781,169123709,169144305,169136225,169151168,169140782,169125952,169127645,169144243,169082100,169132096,169122567,169131102,169129700,169131396,169128513,169127644,169125955,169123691,169122566,169131098,169074087,169146557,169122610,169151167,169128558,169136223,169122609,169144316,169132413,169142444,169143003,169120703,169141369,169074093,169124115,169128698,169111096,169127642,169132300,169141368,169135667,169127178,169126367,169074092) 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,167341712,86558852,68181750,158652367,660,797,90722560,674,114793025,576,523,159032782,155235885,167893195,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'