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-29' and '2024-05-01'
and t.termin_id in (167348556,167359150,167369680,167354291,167354616,167355569,167347635,167368149,167355190,167359610,167346299,167372245,167348007,167348571,167344416,167347640,167359131,167351586,167356161,167356932,167371501,167371492,167362547,167356931,167357427,167377223,167371056,167353979,167368947,167346021,167376628,167356933,167347383,167356727,167345930,167368150,167360532,167348555,167355193,167367930,167366670,167351720,167369562,167350884,167378037,167351362,167355858,167361069,167362880,167372634,167366908,167345364,167359608,167371505,167358110,167369969,167365006,167349089,167369583,167364582,167346624,167345648,167360024,167354833,167380645,167365023,167353978,167376255,167367457,167362545,167371899,167357862,167361359,167356160,167359147,167344636,167377212,167346307,167345646,167350233,167365004,167355191,167356724,167347381,167351717,167376684,167377225,167374382,167364041,167350886,167365042,167352127,167378036,167371496,167371987,167358581,167355866,167374891,167356165,167365030,167346630,167377214,167357411,167352320,167374887,167371992,167360529,167346636,167377215,167354617,167355862,167353974,167361653,167371682,167355585,167371491,167379271,167376256,167374889,167379255,167374892,167365040,167380643,167379253,167346028,167355863,167345390,167372247,167369581,167375372,167347636,167354288,167362539,167356475,167347051,167363971,167345938,167359606,167354618,167376265,167356474,167350231,167365299,167363614,167348011,167350885,167379273,167348542,167371502,167355586,167360027,167361071,167348568,167365297,167345631,167372252,167353977,167353976,167355570,167343294,167344637,167356476,167376627,167348148,167360531,167366911,167376497,167354619,167351363,167359796,167361650,167352122,167360794,167375890,167358577,167347052,167347639,167361070,167364587,167361651,167345397,167370017,167355865,167345030,167361918,167345371,167348147,167372633,167356472,167375155,167378767,167362882,167352493,167345647,167374867,167358580,167361917,167360796,167371900,167364585,167369681,167361916,167348570,167378035,167369259,167346306,167344635,167360528,167368683,167358105,167346308,167357864,167349507,167367463,167355584,167364594,167361073,167375153,167366101,167375887,167365298,167359148,167358107,167366907,167359797,167367450,167358579,167346298,167356170,167353310,167379254,167360530,167361358,167376631,167355864,167376007,167351361,167348014,167374886,167346621,167351585,167346629,167352128,167368151,167362151,167354823,167356164,167359798,167355588,167350234,167374542,167365035,167378026,167371916,167360800,167343291,167371061,167373372,167374885,167380646,167361648,167374544,167360798,167365240,167348149,167365238,167354290,167360029,167354835,167359486,167345370,167349504,167374339,167374868,167356480,167355587,167368696,167370299,167364584,167368684,167362883,167375374,167369078,167356146,167376266,167379276,167356454,167362149,167374888,167354292,167372635,167357410,167335140,167365209,167348150,167356453,167371688,167371912,167376496,167352993,167376009,167352124,167344407,167362150,167363613,167356473,167371911,167360795,167375154,167371906,167348572,167374383,167371055,167364588,167361654,167356482,167367465,167345932,167347641,167359484,167353980,167344409,167351587,167361074,167360797,167355195,167375375,167343293,167354293,167350237,167369580,167349087,167355859,167356159,167356930,167348015,167354836,167205112,167360028,167354620,167344625,167351721,167358109,167368688,167370624,167354276,167378030,167343178,167370300,167360799,167349506,167369584,167363211,167367458,167352633,167346623,167375876,167368442,167350236,167376261,167350313,167345019,167358582,167347042,167374543,167364141,167345634,167375891,167360023,167352121,167352355,167355194,167363279,167379275,167376872,167367449,167369971,167357412,167353312,167367451,167348251,167369557,167352126,167356163,167377213,167374289,167363936,167362546,167365890,167364586,167365036,167371058,167378024,167360349,167348567,167375884,167376008,167350235,167362528,167352125,167345381,167368310,167369970,167365017,167366906,167366669,167376259,167371915,167356479,167343295,167361652,167343726,167355192,167346297,167355583,167358108,167359149,167359609,167360026,167377224,167365041,167362540,167345931,167361072,167344408,167376500,167351719,167354289,167356162,167379274,167345029,167354834,167349505,167375373,167353311,167345387,167360025,167347045,167350976,167343725,167355176,167374884,167365005,167368309,167362881,167363612,167356477,167355861,167369582,167357420,167350217,167374866,167356478,167347046,167351718,167347637,167374254,167344624,167345640,167347382,167357863,167365239,167356726,167362541,167371051,167377211,167371689,167345372,167346622,167365801,167362538,167376495,167355175,167376626,167376006,167363653,167343724,167361649,167349088,167359607,167368834,167380648,167345028,167348554,167343727,167355860,167363611,167353975,167379272,167359146,167379261,167368695,167364581,167376254,167348553,167371905,167343292,167379280,167374251,167374865,167376490,167343296,167345922,167345944,167344630,167355189,167377210,167357419,167345386,167369569,167357861,167371490,167354615,167345636,167358106,167359151,167369968,167371687,167367456,167345037,167380647,167347638,167355589,167372251,167352123,167350216,167371907,167371991,167360527,167363452,167350977,167360350,167356725,167380644,167347053,167350232,167348569,167375893,167368284,167364583,167356481,167375879,167350218,167374255,167374890,167367464,167358578,167345937) 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'