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 (167377049,167375802,167371821,167374693,167362042,167368648,167369782,167345782,167377050,167367667,167381115,167357240,167350072,167370051,167359170,167377044,167373735,167376414,167349023,167361858,167369985,167350075,167368649,167344907,167371338,167373753,167357247,167356654,167365366,167355055,167365865,167373469,167371330,167376851,167375120,167355413,167373750,167357784,167373117,167360474,167345212,167367660,167355056,167345190,167374712,167351507,167370807,167346984,167361537,167350059,167358449,167344106,167347388,167361533,167371345,167360974,167347846,167346823,167369322,167356285,167368646,167377939,167352282,167365545,167359176,167349024,167370080,167363341,167358451,167356286,167360682,167360475,167362775,167362045,167353146,167354150,167347524,167362770,167380071,167350060,167360970,167342726,167380506,167362369,167374694,167374711,167367306,167346511,167342724,167367659,167365867,167356287,167377048,167379207,167377534,167359173,167374134,167354459,167362056,167346185,167347301,167381117,167345486,167359522,167345201,167376078,167346527,167374458,167342728,167347520,167371812,167345193,167348431,167380344,167368263,167357779,167354778,167363196,167369448,167361534,167352792,167373485,167373098,167361275,167360176,167373114,167360473,167344894,167367092,167373470,167373486,167361538,167364907,167344900,167342727,167370802,167371343,167371807,167358126,167372165,167344591,167358127,167346004,167361851,167363561,167356655,167375804,167346194,167367305,167379205,167366386,167373468,167344597,167353429,167377060,167362371,167351689,167378669,167344107,167346195,167345480,167377046,167376076,167367919,167364903,167376413,167368645,167364923,167362771,167363562,167373900,167349261,167349022,167361274,167345478,167370801,167350055,167359761,167378808,167344589,167344596,167355977,167360173,167366854,167346011,167366855,167355054,167345490,167357780,167349397,167373736,167348423,167347521,167344313,167354460,167377535,167360972,167361857,167345785,167346005,167371331,167374713,167376849,167358336,167373888,167365866,167371344,167379204,167375121,167362367,167376075,167364934,167350054,167345196,167360476,167373099,167370258,167377045,167373887,167355732,167359924,167371808,167364408,167361284,167353859,167346521,167378651,167351697,167353861,167373100,167366853,167343412,167347299,167342725,167362183,167342729,167351505,167352793,167347389,167348424,167368795,167343004,167375093,167373484,167363194,167343413,167353860,167372748,167357233,167349390,167355411,167368794,167360691,167350057,167369436,167364415,167365836,167360973,167346006,167380346,167374135,167364911,167373897,167346773,167364906,167348427,167347222,167343415,167371809,167350666,167354781,167343005,167378950,167370081,167362057,167354464,167378809,167354783,167360469,167353430,167348426,167375122,167356857,167377940,167365493,167344315,167353862,167368644,167346986,167355980,167369447,167354463,167357232,167349396,167369039,167360694,167375095,167358448,167359177,167360693,167374707,167362044,167377051,167369437,167369781,167345781,167360470,167359925,167369438,167365492,167356656,167361276,167372166,167357783,167367293,167367294,167364905,167378810,167350076,167362059,167347221,167343414,167359521,167362058,167367672,167360172,167344895,167349262,167364405,167359763,167373734,167359175,167358124,167349263,167354461,167361536,167355733,167354149,167345493,167344598,167376089,167369321,167346989,167354462,167342998,167348425,167358450,167350058,167354782,167367668,167346819,167367918,167351687,167357231,167364407,167363195,167365835,167380345,167379208,167362370,167375801,167360171,167371820,167350665,167373488,167356653,167359174,167358125,167350074,167345485,167368647,167360971,167357230,167364904,167378650,167346012,167347523,167345200,167376077,167344906,167347300,167346193,167351506,167354148,167344314,167374457,167371337,167367292,167346526,167369038,167359762,167361535,167374710,167357782,167346985,167367300,167355412,167342997,167370259,167350664,167373116,167375094,167373899,167347849,167378979,167379206,167359172,167357229,167345479,167356856,167357781,167354780,167347522,167363769,167351688,167371814,167345189,167377047,167381116,167361856,167344590,167373115,167373752,167367299,167373113,167367304,167368264,167367663,167375800,167378977,167359520,167379184,167373751,167359922,167343003,167380505,167355984,167365365,167349260,167355053,167356855,167369780,167345780,167347845,167377533,167364406,167377938,167347395,167379203,167349021,167374708,167365834,167357228,167350073,167369215,167381150,167369037,167347390,167377946,167380011,167350056,167362368,167355979,167359923,167373487,167342996,167355978,167369214,167354779,167344897,167361273,167371819,167362055,167358123,167372736,167359171,167356854,167380010,167359921,167351686,167345771,167371329,167356652,167346013,167364914,167344893,167373112,167373483,167373749,167371813,167370810,167360959,167376415,167357254,167377052,167374709,167368265,167380507,167373898,167369446,167365367,167366857,167364414,167367093,167376418,167346190,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'