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-26' and '2024-05-01'
and t.termin_id in (167352785,167349316,167353872,167350916,167352440,167367630,167371234,167359775,167349324,167369371,167370637,167352872,167351904,167348955,167360619,167359227,167359530,167370943,167349968,167354155,167368330,167373722,167357131,167372580,167363153,167363896,167358468,167367610,167369662,167347191,167343623,167370067,167367614,167352689,167351370,167376353,167356336,167372772,167377695,167360411,167358144,167357148,167368611,167353115,167343828,167346265,167345218,167366381,167363149,167352562,167365542,167374189,167376577,167373459,167348952,167361465,167360896,167360151,167349326,167364323,167347829,167376161,167377694,167361801,167347275,167357715,167365827,167354156,167357147,167364321,167364980,167364322,167345526,167368335,167353871,167371227,167377894,167370071,167352272,167357709,167368754,167345226,167348950,167360898,167348361,167354581,167358148,167367192,167371742,167379796,167370070,167356587,167358472,167374194,167374614,167368994,167349987,167357124,167359930,167351634,167366207,167364974,167342674,167376688,167376805,167356018,167368977,167353870,167372170,167379864,167371223,167374198,167368544,167360408,167343624,167368464,167357150,167358137,167369363,167344551,167348951,167343661,167375189,167363021,167368465,167363159,167353418,167359234,167349985,167373730,167349194,167344929,167371216,167361480,167343666,167354565,167365487,167368610,167351905,167352565,167367905,167371734,167348156,167370355,167379553,167362083,167361214,167363793,167349315,167343186,167356016,167365821,167342895,167359931,167370009,167347819,167346501,167343382,167353118,167357721,167372785,167348161,167372573,167376062,167347818,167373305,167380534,167369772,167369370,167376164,167370632,167343858,167347447,167358466,167344364,167358141,167354571,167348158,167363293,167343387,167348962,167376358,167344925,167348791,167377729,167357130,167376964,167373727,167371739,167367620,167364330,167343386,167348166,167374203,167368541,167357157,167377498,167353874,167352869,167361472,167352783,167353270,167370073,167360149,167354976,167353419,167370008,167354159,167362750,167352434,167350650,167354572,167357161,167355743,167364331,167370212,167374199,167363369,167356020,167344552,167205237,167381124,167368416,167365819,167342928,167358134,167357126,167376175,167370940,167346260,167347821,167353411,167345805,167376963,167346499,167354852,167369374,167376965,167376166,167375499,167348359,167353121,167360625,167365346,167353878,167351389,167365355,167363510,167368575,167362752,167367193,167355429,167344366,167360623,167377903,167376108,167358470,167356027,167354573,167376804,167376973,167374209,167347193,167349972,167372008,167344920,167376583,167348162,167364970,167366627,167359535,167379519,167351022,167379122,167379880,167358138,167365824,167351643,167363894,167373458,167368219,167343824,167379515,167375498,167362755,167369372,167360629,167370360,167354974,167355423,167372171,167357125,167361215,167343562,167360630,167373303,167346963,167370216,167348954,167374207,167368756,167362384,167364979,167372172,167376691,167368976,167381153,167361463,167360153,167367605,167377900,167368980,167368605,167357134,167368578,167343660,167373712,167360403,167351635,167359932,167358467,167356585,167369109,167368079,167347452,167369375,167362379,167365822,167349983,167374362,167366629,167198995,167366527,167342673,167372932,167379522,167357158,167353268,167356345,167356334,167361467,167357149,167342894,167360905,167369377,167346504,167376356,167371236,167368752,167356338,167376163,167375491,167379118,167379876,167374619,167375496,167352865,167375739,167352431,167363503,167367609,167370636,167346267,167362386,167373449,167343559,167360155,167353266,167370215,167345810,167343829,167380182,167352781,167368333,167367619,167357132,167359777,167343667,167349322,167343860,167360158,167372582,167351374,167376692,167379868,167371996,167372177,167351138,167357722,167358475,167354981,167361469,167373300,167348958,167361799,167364326,167356023,167362382,167363296,167356592,167354978,167355426,167349333,167358140,167379881,167379124,167367201,167355741,167343622,167370487,167349328,167376100,167361209,167345801,167367940,167346259,167383274,167376063,167379121,167360899,167354163,167354979,167347837,167351739,167357151,167363019,167372771,167371240,167368576,167355744,167368546,167373718,167350912,167370631,167367934,167360152,167348159,167369362,167359233,167343825,167363152,167361795,167349989,167355421,167349327,167374202,167360900,167362067,167344560,167368078,167372931,167356809,167352270,167367624,167372169,167348789,167353124,167366996,167349323,167373293,167355424,167349331,167356590,167357716,167380526,167357123,167366485,167360620,167343563,167372578,167359222,167343626,167362761,167371221,167379879,167345532,167361208,167342931,167365818,167348797,167380537,167344559,167376966,167349197,167343190,167348351,167350651,167356583,167373456,167368890,167369664,167349965,167347446,167346503,167365345,167371127,167370357,167344553,167353119,167363991,167359230,167360407,167371232,167349195,167376057,167359231,167368270,167349337,167368083,167362385,167376065,167345525,167373455,167366378,167368214,167344370,167347822,167368216,167363895,167345225,167370562,167383272,167376066,167361470,167348348,167365927,167370359,167379935,167371647,167372784,167371230,167369157,167347831,167376974,167348963,167359940,167374363,167353412,167355422,167348163,167379884,167376106,167366997,167348094,167368577,167377500,167376807,167368979,167351024,167379866,167372786,167362377,167376962,167367607,167367617,167357155,167373457,167379517,167379878,167379125,167354846,167377893,167368608,167347451,167365705,167347196,167360622,167370358,167347272,167349338,167351903,167352433,167372577,167348953,167372770,167348350,167375734,167346264,167205241,167354853,167351466,167370209,167356588,167354848,167356805,167356589,167376969,167354851,167370211,167377696,167363897,167358469,167353122,167372004,167356335,167368549,167368761,167343859,167345527,167356339,167361468,167371222,167354982,167343564,167371731,167380957,167363507,167352868,167353410,167352278,167360897,167370213,167368332,167374206,167370561,167380940,167357140,167380183,167375051,167358145,167349201,167356814,167359933,167354566,167356597,167380184,167371740,167352271,167347188,167368887,167343857,167345804,167351464,167375727,167346716,167347836,167380245,167381128,167377897,167351207,167366487,167379129,167353053,167379521,167353271,167368418,167349980,167380956,167363506,167368274,167370105,167353877,167373724,167346971,167361796,167360402,167362080,167380529,167362065,167369110,167354984,167356596,167357711,167345224,167351021,167354845,167367182,167356584,167357710,167370939,167356340,167361474,167357719,167359534,167352871,167370931,167372780,167355752,167360397,167358473,167351471,167347192,167363511,167351637,167368081,167362383,167363330,167370214,167359781,167373729,167368607,167347820,167366204,167359529,167373721,167368080,167376357,167363794,167356803,167362081,167359935,167376689,167376806,167381129,167360150,167348157,167376355,167365804,167361475,167368218,167352273,167362380,167368547,167356013,167354569,167347130,167366486,167351209,167355420,167353873,167359532,167368606,167345809,167372579,167379797,167365351,167368545,167376348,167356021,167370072,167350652,167363020,167351929,167346258,167344918,167371646,167347445,167373453,167349199,167367106,167354849,167343665,167351134,167374364,167205239,167356807,167353267,167377896,167352563,167373454,167368888,167364978,167349244,167368543,167375494,167351740,167347814,167366208,167376096,167368215,167367105,167347828,167369770,167360161,167381130,167375724,167368269,167350913,167346756,167367932,167381125,167356804,167383273,167349978,167368417,167368601,167350914,167354970,167359533,167346966,167362070,167366621,167376349,167353875,167359528,167363055,167368604,167349977,167344917,167342898,167374368,167349964,167380531,167368220,167363022,167352275,167351983,167373460,167368894,167366205,167357720,167357128,167360404,167343383,167346500,167351133,167362066,167346964,167370560,167376174,167364983,167375736,167371995,167349982,167380297,167370930,167360627,167372575,167368548,167348165,167344562,167348959,167376575,167347129,167360148,167348155,167367184,167352276,167350920,167376961,167374114,167347455,167371235,167344921,167351470,167350643,167380528,167361477,167354854,167352437,167346261,167370633,167366626,167359229,167361462,167374208,167370559,167370068,167363994,167351132,167380939,167343381,167368462,167370210,167360902,167348360,167360410,167349984,167372003,167352690,167353050,167370564,167358135,167362378,167363292,167360621,167374618,167376582,167372794,167348096,167365823,167380181,167356017,167349988,167352439,167342675,167361206,167373301,167366209,167376808,167376173,167356342,167348357,167380242,167368223,167352564,167355419,167351738,167370488,167346714,167348349,167349979,167372006,167376584,167368272,167370489,167360398,167354971,167366885,167354157,167365484,167359538,167353414,167348792,167373723,167342897,167371226,167343192,167357718,167359223,167370356,167342671,167379120,167351465,167355749,167347453,167367183,167361211,167343826,167356024,167351473,167343668,167381123,167352780,167353869,167365966,167368123,167349198,167350649,167364968,167368892,167351211,167345216,167346715,167343664,167359226,167376960,167368753,167367604,167376105,167376352,167363157,167365348,167368897,167352779,167375504,167376690,167367625,167357129,167371241,167374626,167344367,167366880,167362760,167345803,167373717,167344373,167371735,167361476,167349967,167343662,167344371,167351371,167343118,167346975,167361802,167344549,167376957,167359235,167344365,167379798,167368224,167375503,167345800,167371219,167346758,167367613,167376581,167364320,167371229,167343823,167362376,167375735,167368271,167375052,167357717,167354574,167357138,167347454,167352784,167373461,167375728,167374210,167380244,167352693,167373450,167361213,167373304,167367199,167345797,167375184,167373711,167381133,167347273,167359531,167376103,167376350,167354850,167351212,167354158,167355745,167366628,167356812,167356810,167370206,167369114,167350919,167343798,167347269,167359225,167370937,167354973,167360401,167354564,167357127,167368758,167367000,167365349,167353269,167363151,167370069,167375185,167379513,167356591,167343670,167345807,167376975,167354980,167373299,167365354,167373297,167354847,167360157,167356806,167372928,167351213,167377699,167367936,167346508,167366482,167355332,167368583,167349330,167356019,167346760,167375188,167366998,167362075,167376360,167359779,167357135,167360156,167343627,167366883,167363995,167355747,167370217,167360907,167369379,167368898,167377496,167376169,167356028,167361481,167353123,167345536,167359784,167353880,167351210,167372929,167343561,167366882,167348164,167367195,167368334,167353125,167205243,167342899,167349246,167368762,167369737,167370568,167373713,167343558,167370642,167354577,167375055,167352569,167359232,167357156,167370566,167354166,167343621,167363023,167374627,167345808,167355740,167379863,167353868,167376687,167363893,167358465,167362748,167353116,167345228,167351636,167345533,167351025,167344557,167376586,167366879,167349196,167351639,167346262,167368582,167377697,167346759,167346498,167371743,167359236,167359934,167380186,167354167,167376811,167380243,167383276,167363512,167364971,167376098,167363290,167368273,167374366,167363370,167371729,167368339,167380247,167354857,167359537,167368895,167376585,167372934,167369773,167370927,167370567,167344368,167351472,167354856,167369378,167346968,167362074,167343669,167376170,167360903,167354576,167360906,167380536,167381126,167376959,167356344,167352432,167365483,167343799,167354983,167372009,167360399,167368757,167343830,167344554,167347448,167366623,167359774,167376099,167347813,167357712,167342678,167374188,167379128,167347277,167345529,167371736,167343663,167347190,167368217,167350915,167361800,167374617,167365347,167344922,167347815,167348352,167371239,167346257,167374361,167366884,167343379,167359773,167372001,167367608,167354855,167361466,167376101,167345217,167380176,167365820,167379119,167354575,167363158,167348964,167374196,167372581,167354975,167346826,167367198,167380943,167351638,167363900,167365356,167343831,167369113,167198994,167368751,167379512,167380241,167368609,167356595,167371220,167344919,167356025,167362749,167361473,167380941,167356343,167371217,167369787,167355748,167351027,167362759,167376092,167347832,167361479,167371218,167367185,167364329,167345535,167374367,167368602,167383271,167348347,167351026,167373306,167344561,167368889,167368082,167373731,167376972,167352826,167367629,167347131,167198998,167343187,167342932,167379882,167367933,167375502,167345222,167381132,167368222,167347195,167366379,167363041,167373462,167355428,167368896,167369115,167365965,167365887,167356813,167342677,167377906,167346507,167359536,167379520,167342929,167349193,167349245,167370933,167368221,167379867,167379127,167369665,167363992,167346974,167349981,167349986,167371238,167374625,167368760,167362758,167365806,167363508,167359939,167354165,167376064,167380535,167346506,167344556,167348961,167370639,167352568,167348356,167370490,167375054,167349336,167356026,167375738,167368337,167373720,167377499,167349966,167359783,167370074,167367627,167376810,167383275,167358142,167380958,167352438,167353417,167350653,167342676,167368463,167369376,167376060,167351208,167357122,167354561,167362079,167343797,167352870,167346497,167352436,167352691,167353051,167348358,167347276,167348960,167357137,167376971,167379514,167374115,167359224,167372176,167344555,167368759,167369369,167379795,167353416,167346967,167362757,167362072,167349970,167375729,167374624,167360904,167365805,167364328,167355750,167371233,167360409,167346757,167354164,167364982,167372781,167347197,167372576,167366203,167380527,167370486,167367186,167345221,167376167,167368336,167372007,167375501,167349335,167349329,167352692,167353052,167379126,167380185,167368978,167381131,167365486,167377698,167205238,167377497,167365353,167347449,167375495,167375493,167379454,167355742,167346718,167374205,167367200,167345799,167362073,167363505,167367189,167357146,167379132,167344934,167368581,167367612,167368338,167358474,167360626,167198997,167343385,167365352,167379554,167380942,167357136,167377495,167349325,167359937,167373728,167343388,167367001,167349200,167362071,167376172,167350644,167369112,167345227,167364327,167362064,167370565,167361797,167375053,167363899,167358471,167370638,167358136,167351136,167355427,167354972,167373725,167346495,167354570,167346268,167364324,167357152,167374616,167351373,167364973,167343625,167347128,167351191,167376359,167353876,167375731,167359938,167205242,167380533,167347456,167350654,167366380,167363792,167368076,167356586,167363297,167354567,167374200,167374620,167362389,167345534,167359780,167375500,167374204,167376958,167379877,167363509,167374370,167375737,167351469,167371741,167359239,167367191,167366878,167363990,167375725,167365826,167361212,167381154,167349334,167344927,167372574,167373298,167366484,167366202,167374623,167362069,167376104,167360154,167376351,167376809,167377892,167370350,167359936,167346717,167351463,167366999,167362753,167350921,167367606,167357139,167377904,167347830,167364325,167353415,167342672,167356015,167380296,167381127,167345220,167354162,167376970,167363798,167376061,167370934,167380532,167362756,167363898,167376093,167379516,167376578,167374622,167360628,167358133,167343380,167346970,167361207,167375050,167370635,167376576,167352269,167343117,167347270,167376107,167353049,167370929,167345531,167362751,167359941,167372005,167369786,167345802,167351644,167363155,167374615,167370207,167344924,167369661,167374195,167375492,167368542,167367188,167371738,167363504,167372002,167361464,167356332,167367938,167356014,167371128,167375187,167372783,167347817,167343560,167367904,167377889,167369663,167367603,167343659,167368213,167368075,167351633,167352778,167353867,167380180,167348788,167362747,167369368,167355418,167363892,167358464,167359527,167344363,167348794,167358132,167351123,167354563,167376109,167345215,167370932,167356331,167360400,167366206,167357713,167370936,167356594,167350648,167361205,167371732,167363156,167371225,167371733,167346973,167360396,167370942,167356330,167355739,167367623,167367616,167375723,167362068,167356808,167348956,167352274,167376058,167344372,167377905,167374116,167366622,167373719,167363150,167373726,167366526,167356022,167351752,167198996,167367618,167351135,167343565,167342930,167373302,167348957,167343827,167380955,167367621,167363291,167367935,167350917,167362381,167367611,167368580,167357153,167360624,167380246,167379934,167372930,167377898,167354568,167348160,167343119,167355746,167349969,167379518,167376580,167360901,167369373,167352567,167342689,167346505,167358139,167347450,167379123,167365825,167376171,167355425,167357133,167354977,167374621,167363295,167365350,167353120,167374201,167351023,167347274,167343384,167349332,167351372,167370208,167377890,167347271,167374193,167368077,167376059,167353117,167353879,167367190,167346266,167346972,167361798,167351468,167344926,167359778,167205240,167366625,167364969,167353413,167363154,167374365,167367939,167368579,167370563,167363294,167354161,167352566,167365485,167362754,167346965,167375730,167359776,167376165,167375732,167377891,167352782,167376579,167368419,167368755,167363902,167356341,167368891,167369771,167368599,167380530,167354160,167359228,167360405,167371728,167351467,167356337,167361471,167375497,167374197,167370938,167361210,167379130,167348793,167342896,167352435,167369111,167348790,167362082,167375186,167379865,167373294,167346829,167358143,167352277,167364981,167377728,167363901,167342933,167354562,167346723,167368893,167343191,167371231,167344928,167356333,167377899,167367196,167361794,167363331,167372927,167353409,167357154,167347189,167366881,167363993,167379131,167343189,167352268,167198992,167351137,167361478,167357714,167360406,167379883,167367628,167350918,167366624,167356593,167347823,167355751,167359782,167349971,167356811,167368331,167345528) 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'