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-27' and '2024-05-01'
and t.termin_id in (167377049,167375802,167371821,167379183,167374693,167360688,167362042,167364901,167361854,167373894,167356852,167368648,167369782,167345782,167374705,167364930,167348421,167377050,167367667,167381115,167352790,167349019,167374456,167357240,167344594,167370079,167350072,167370051,167359170,167377044,167373735,167376414,167349023,167371332,167353428,167350070,167362054,167361858,167373108,167351504,167369985,167375795,167350075,167370805,167368649,167344907,167368641,167369984,167347219,167377936,167369434,167345483,167376073,167347516,167374453,167345199,167371338,167368923,167369320,167373753,167368261,167354146,167370257,167357247,167361271,167356654,167352414,167377937,167365366,167355055,167364926,167365865,167373110,167365955,167373469,167371330,167373893,167357226,167376851,167375120,167377041,167355413,167362052,167376417,167373750,167357784,167373117,167360474,167345212,167367660,167355056,167345190,167374712,167371818,167346525,167342995,167351507,167370807,167346984,167361537,167363339,167350059,167349865,167380009,167358449,167373745,167359518,167361849,167362053,167344106,167360966,167367923,167347388,167361533,167373746,167371345,167360974,167346988,167361531,167350068,167347846,167346823,167350053,167369322,167364912,167358119,167356285,167368646,167377939,167359168,167357777,167352282,167356648,167353145,167365545,167359176,167349024,167343411,167356649,167360958,167370080,167344905,167371335,167344600,167362363,167360690,167364921,167363341,167358451,167356286,167360682,167360475,167372161,167370256,167346772,167362775,167362045,167353146,167354150,167347524,167360689,167358335,167361270,167362770,167380071,167359167,167347515,167350060,167366385,167360970,167342726,167380506,167362369,167374694,167374711,167357775,167355050,167367306,167346511,167352280,167373478,167357227,167349395,167371339,167380503,167368792,167352413,167343001,167351684,167342724,167344912,167348420,167367659,167365867,167356287,167346822,167377048,167379207,167355730,167374703,167377534,167376074,167359173,167374134,167354459,167362056,167346185,167374704,167347301,167381117,167345486,167359522,167345201,167376078,167346527,167374458,167342728,167345476,167367303,167372745,167347520,167371812,167345193,167348431,167354144,167346181,167380008,167380344,167380502,167357245,167375798,167376411,167361269,167368263,167372164,167344317,167354456,167346010,167364402,167373748,167345484,167357779,167354778,167363196,167369448,167361534,167381114,167352792,167373485,167373098,167364902,167371811,167361855,167367291,167355975,167361275,167354775,167350050,167350662,167360176,167373114,167358447,167360473,167377058,167356283,167344894,167369443,167362051,167342994,167380007,167367092,167373470,167362767,167357239,167373486,167361530,167357238,167346524,167349018,167361538,167360468,167364907,167344900,167351502,167373107,167342727,167370802,167354774,167377532,167346739,167368642,167371343,167371807,167358126,167372165,167344591,167367666,167358127,167371817,167346004,167361851,167363561,167356655,167349231,167362365,167367658,167358446,167378806,167346009,167375804,167346194,167355729,167367305,167379205,167362364,167359758,167366386,167360167,167344312,167368791,167367922,167377039,167373468,167344597,167350069,167377944,167353427,167362040,167369212,167353429,167377060,167358118,167358334,167356284,167342720,167375118,167362371,167351689,167378669,167344107,167371328,167345207,167363191,167346195,167345480,167351696,167377046,167376076,167367919,167345194,167364903,167376413,167368645,167364923,167373477,167350663,167362771,167349389,167363562,167373900,167349261,167349022,167361274,167345478,167370801,167374132,167350055,167359761,167378808,167365363,167367298,167344589,167344596,167355977,167366851,167359920,167348422,167362038,167376412,167377945,167349020,167346771,167381113,167344588,167360173,167359519,167360169,167375091,167366854,167342721,167357259,167355409,167379210,167369444,167367669,167360957,167350049,167342722,167376847,167354468,167367091,167356850,167361282,167379182,167365362,167346011,167366855,167359918,167369435,167355054,167350067,167345490,167357780,167355976,167346001,167359917,167349397,167373736,167359760,167373111,167359169,167360968,167348423,167347521,167344313,167354460,167377535,167360972,167361857,167360967,167345785,167367671,167346005,167371331,167377043,167354458,167360170,167346767,167364922,167346188,167374713,167376849,167358336,167373888,167365866,167371344,167379204,167375121,167355410,167362367,167344587,167371327,167362768,167359164,167376075,167364934,167370044,167361529,167365863,167347386,167374452,167350054,167345196,167345773,167345195,167360476,167373099,167370258,167377045,167347394,167365725,167373887,167357778,167355732,167344311,167373744,167367295,167359924,167371808,167364408,167361284,167355983,167362041,167352574,167378976,167354773,167353859,167373480,167374130,167346521,167378651,167351697,167358331,167351695,167353861,167373100,167350051,167344904,167366853,167343412,167347299,167366384,167361848,167342725,167343410,167379200,167349258,167362183,167342729,167351505,167358120,167348419,167377040,167354455,167369035,167352793,167346978,167377059,167344891,167347389,167381149,167351685,167348424,167368795,167343004,167375093,167373484,167363194,167343413,167353860,167345477,167360681,167372748,167357233,167358117,167346000,167349390,167355411,167344892,167356282,167360466,167368794,167360691,167350057,167369436,167355049,167373747,167365832,167363768,167364415,167354143,167365836,167360973,167346006,167380346,167374135,167364911,167373897,167343409,167346773,167364906,167348427,167347222,167343415,167371809,167350666,167354781,167374691,167343005,167378950,167370081,167362057,167354464,167378809,167354783,167360469,167360465,167355408,167353430,167348426,167375122,167356857,167373743,167377940,167365493,167344315,167353862,167368644,167343002,167364913,167346986,167359165,167355980,167369447,167354463,167357232,167349396,167369039,167360694,167375095,167358448,167359177,167360693,167371805,167346517,167356851,167349388,167374707,167362044,167377051,167369437,167369781,167345781,167360470,167362181,167359925,167369438,167365492,167358122,167356656,167361276,167372166,167357783,167367293,167367294,167364905,167378810,167350076,167364401,167362059,167347221,167343414,167359521,167359163,167362058,167367672,167370045,167360172,167344895,167371806,167371342,167353857,167349262,167364405,167359763,167373734,167360956,167359175,167363560,167358124,167349263,167354461,167355051,167370096,167352575,167361536,167355733,167354149,167368922,167365864,167354777,167360969,167345493,167344598,167376089,167369321,167346989,167354462,167342998,167364931,167348425,167358450,167350058,167354782,167367668,167346819,167367918,167351687,167357231,167364407,167363195,167365835,167380345,167350071,167379208,167362370,167375801,167360171,167371820,167350665,167373488,167356653,167359174,167358125,167350074,167345485,167368647,167360971,167357230,167364904,167378650,167346012,167347523,167345200,167376077,167344906,167347300,167360168,167367662,167373109,167363559,167359166,167346193,167351506,167354148,167344314,167374457,167371337,167361272,167373482,167354469,167352281,167368262,167356651,167367292,167346526,167369038,167344899,167359762,167361535,167374710,167357782,167346985,167367300,167355412,167342997,167370259,167350664,167357252,167345492,167373116,167375094,167345772,167373899,167347849,167378979,167379206,167359172,167357229,167345479,167350052,167363192,167356856,167357781,167354780,167347522,167363769,167351688,167371814,167345189,167377047,167381116,167370806,167352791,167361856,167354145,167347517,167374454,167365833,167351503,167357788,167344590,167373115,167373752,167374706,167367299,167360467,167373113,167367304,167368264,167367663,167375800,167378977,167378668,167359520,167379184,167373751,167359922,167343003,167380505,167355984,167365365,167349260,167355053,167356855,167369780,167345780,167358332,167347845,167377533,167364406,167377938,167347395,167379203,167349021,167374708,167374702,167365834,167349259,167357228,167350073,167369215,167381150,167369037,167372747,167347390,167351683,167377946,167380011,167350056,167362368,167355979,167359923,167373487,167342996,167355978,167369214,167354779,167344897,167361273,167371819,167362055,167358123,167372736,167359171,167356854,167380010,167359921,167351686,167349232,167362050,167345771,167371329,167346983,167357776,167347393,167379199,167356652,167346013,167364914,167347853,167379202,167356650,167344893,167373112,167373483,167373749,167371813,167370810,167342723,167369213,167360959,167361283,167369036,167376415,167365364,167364413,167363193,167348105,167347220,167367307,167357246,167375799,167363773,167366856,167344595,167347298,167347844,167356853,167376088,167354457,167361532,167362182,167370046,167378807,167369445,167346189,167363340,167380504,167380070,167359182,167373896,167362769,167355052,167361850,167378978,167347519,167357254,167377052,167345779,167364404,167379201,167368793,167364412,167373479,167370800,167360680,167360464,167359757,167374692,167368643,167362366,167377042,167355731,167345205,167372735,167366852,167364403,167353858,167375119,167359919,167375092,167354776,167347518,167347843,167357260,167373481,167373895,167374455,167358116,167358121,167347387,167376848,167374133,167359759,167374709,167368265,167380507,167373898,167347297,167378667,167369446,167365367,167366857,167364414,167367093,167376418,167367290,167346190,167362039,167356849,167362772,167356859,167356657,167356858,167346774,167345208,167360692,167362043,167364910,167354147,167371336,167349233) 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'