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-30' and '2024-05-08'
and t.termin_id in (167348984,167373026,167350767,167351117,167373124,167368625,167342989,167372013,167363840,167354354,167369960,167362806,167352506,167377799,167371255,167373397,167357190,167362803,167366818,167353326,167362931,167378477,167351115,167366584,167355006,167346423,167363839,167372025,167375391,167370230,167372150,167360424,167359681,167365420,167346420,167371766,167356250,167354075,167342992,167356252,167347480,167365880,167369961,167360644,167355393,167369399,167342991,167344480,167367230,167377788,167366361,167352504,167345455,167351176,167367218,167376369,167364744,167373345,167373123,167373844,167353827,167362930,167351113,167373260,167351114,167365258,167373351,167355948,167376993,167362404,167376368,167377784,167344103,167343822,167376375,167356612,167371249,167373598,167351177,167361230,167371264,167373246,167377787,167367651,167363837,167360427,167360312,167365261,167377511,167354077,167350009,167366369,167370949,167373027,167362405,167376860,167350008,167365260,167357180,167379698,167361494,167342990,167379169,167360922,167347479,167354353,167348382,167349359,167351175,167373040,167359029,167365767,167365879,167380699,167375063,167365421,167360923,167349361,167345454,167367211,167360426,167352049,167376992,167347478,167367223,167363529,167350007,167373261,167375064,167347476,167343031,167364345,167369398,167354076,167344102,167362932,167361233,167352728,167378313,167355949,167363174,167364344,167362407,167363383,167357996,167359040,167350766,167351116,167354365,167361229,167377708,167344479,167357189,167375393,167353826,167373138,167355394,167359889,167343030,167375113,167370954,167356610,167376991,167372151,167375390,167363527,167363128,167371256,167360309,167379699,167352505,167375755,167371753,167370961,167359682,167346124,167371270,167362403,167356248,167355003,167350006,167373599,167347763,167353202,167360425,167349871,167346429,167351663,167362406,167358420,167366368,167370381,167380476,167371751,167352052,167352947,167381058,167343064,167348985,167353324,167357998,167355005,167355396,167366582,167354352,167359684,167352053,167367237,167343063,167348986,167357178,167352726,167348378,167357191,167359030,167353327,167363175,167354355,167377709,167375746,167352727,167360310,167381057,167366585,167364347,167359892,167368627,167344487,167361976,167358421,167370382,167360648,167373832,167356613,167359032,167378971,167381056,167361496,167346137,167373247,167381089,167348381,167374654,167351664,167357179,167367893,167379170,167375394,167354691,167375756,167367899,167351178,167351665,167354988,167353829,167352729,167355951,167376376,167345461,167378480,167376861,167367652,167361818,167367238,167364752,167352466,167347764,167370231,167380698,167366812,167371752,167357999,167373396,167373831,167368626,167366362,167353199,167377674,167379697,167362805,167378479,167379700,167360311,167370232,167347754,167355395,167361232,167359891,167377785,167380479,167343821,167346415,167349360,167346130,167363526,167359683,167361817,167361497,167367224,167374124,167354690,167359031,167372027,167356611,167350765,167360645,167357736,167353325,167353828,167360647,167367639,167353198,167371765,167377782,167357997,167356249,167368525,167347477,167360921,167346136,167371754,167380480,167365813,167377798,167367644,167354689,167352051,167358419,167374639,167362804,167348379,167380478,167343820,167364343,167343819,167373612,167375392,167367210,167361231,167364742,167345462,167363838,167371651,167365419,167352465,167378478,167361495,167354074,167365259,167375745,167344486,167369883,167361816,167366583,167355004,167348983,167369959,167365769,167359890,167354351,167379696,167374653,167363384,167379168,167373041,167361975,167360646,167358418,167370792,167378314,167378315,167367638,167354688,167367892,167366367,167380477,167371254,167373409,167350764,167354364,167364750,167368624,167373843,167357177,167373137,167351662,167354350,167369396,167370960,167346427,167354073,167348377,167361974,167364736,167363405,167369958,167364346,167379167,167360920,167363334,167367898,167361815,167348982,167365768,167374655,167358417,167349358,167374123,167374652,167377781,167373408,167377510,167366372,167367217,167367229,167371263,167365418,167367643,167378972,167348380,167354687,167355950,167357738,167370779,167357737,167347755,167372026,167365847,167376866,167363129,167357735,167370233,167369397,167371271,167363528,167373611,167352050,167364743,167356251,167352952) 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'