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 (167363645,167375997,167353301,167363144,167346118,167363818,167367883,167357510,167354398,167361413,167361714,167343839,167362725,167352065,167347365,167347715,167349643,167364659,167353300,167347310,167372647,167348486,167361395,167357507,167356269,167347716,167373327,167353108,167344230,167363318,167358387,167376286,167363817,167352064,167369504,167352344,167373330,167355960,167359060,167370324,167374163,167359062,167364724,167344777,167365775,167357521,167350940,167364728,167345972,167370889,167354131,167360841,167380442,167375922,167345101,167374491,167368931,167369818,167380311,167371092,167363632,167357509,167366569,167345683,167364668,167364694,167345438,167363860,167352345,167370887,167370325,167367884,167365287,167351534,167347233,167356965,167366376,167348470,167361405,167351770,167364710,167361124,167380446,167346107,167361394,167343276,167369285,167366216,167377309,167365738,167375145,167362721,167376527,167346379,167346843,167367727,167361403,167361132,167374492,167379547,167343568,167375363,167349218,167351538,167358025,167358384,167372564,167361939,167370061,167355721,167355969,167379946,167350138,167362003,167345435,167349214,167369495,167368722,167346388,167379945,167379172,167343786,167369503,167356758,167368719,167343787,167346747,167361401,167343108,167377856,167379542,167357908,167377850,167350128,167366802,167346115,167355377,167359504,167355718,167344761,167350132,167347564,167371946,167363646,167370322,167381136,167368930,167364693,167352483,167361711,167352623,167377299,167368140,167368932,167361998,167362723,167380447,167376522,167377849,167369063,167344115,167368139,167360833,167375920,167379899,167345444,167352708,167347309,167374490,167343278,167370060,167346849,167345085,167371558,167344439,167358383,167371090,167356273,167379178,167344770,167348471,167352343,167371944,167361126,167377306,167344219,167346108,167344773,167355962,167344765,167346749,167344763,167357907,167370326,167368141,167376842,167361996,167368810,167377310,167347560,167360827,167376287,167357516,167350129,167351768,167368552,167343790,167364705,167355970,167343791,167363864,167345693,167349057,167363319,167366220,167361717,167356760,167351772,167364661,167344220,167374776,167377857,167347230,167348475,167364701,167374770,167375921,167355968,167343277,167375918,167370610,167349215,167375917,167371943,167352061,167375360,167368553,167363638,167358386,167370611,167374771,167355108,167364722,167357501,167374128,167379843,167359058,167351537,167361409,167354395,167368142,167349055,167364692,167357526,167354717,167355103,167359507,167380945,167343838,167379543,167375362,167354022,167365776,167357522,167369694,167370886,167364660,167347311,167350133,167349641,167349624,167374493,167352624,167356966,167366219,167346380,167357511,167355967,167356268,167377316,167356274,167346109,167346383,167374781,167362465,167345677,167366805,167365286,167347718,167348304,167355372,167358020,167355717,167375998,167355105,167364723,167364669,167380313,167361406,167346851,167349056,167369289,167343835,167368724,167372117,167375996,167362467,167371561,167376844,167369287,167363142,167364665,167343788,167369288,167351536,167359907,167368138,167354721,167374323,167363814,167353106,167360272,167372118,167352983,167380443,167361130,167375992,167355959,167377312,167381140,167360275,167352486,167362006,167351767,167369816,167358339,167359905,167345969,167345970,167372460,167359059,167349445,167379174,167361943,167367885,167379546,167350143,167377855,167345436,167371094,167366804,167353299,167367723,167367728,167376524,167353110,167354716,167370892,167379947,167374772,167372752,167377311,167354024,167371940,167356264,167344224,167355104,167353298,167348305,167365810,167346382,167371562,167372645,167356756,167349444,167364700,167374160,167364656,167354718,167343569,167355107,167365739,167354129,167349642,167371559,167352346,167350141,167362004,167371665,167370057,167360564,167355719,167363316,167354125,167345692,167344764,167356263,167381137,167348480,167361136,167348476,167369060,167369502,167375069,167355961,167359909,167349570,167364691,167360831,167350144,167350816,167372751,167350941,167374126,167364713,167355369,167368808,167344762,167377304,167361133,167361712,167357909,167346116,167374783,167359703,167362466,167355367,167348473,167359702,167376521,167348469,167355366,167356261,167355715,167355109,167344227,167352627,167352987,167368934,167354400,167367901,167370323,167371945,167358022,167352626,167352986,167376291,167346110,167369064,167345440,167346848,167374774,167358021,167351771,167369499,167347312,167344226,167364658,167347722,167363815,167362722,167374782,167357910,167347717,167364662,167345087,167357527,167376843,167373328,167345687,167340821,167365777,167377313,167381138,167379175,167365809,167364714,167350134,167367534,167360836,167369505,167368433,167352066,167375999,167365740,167364719,167345097,167369496,167359065,167365290,167344444,167350817,167355373,167350944,167345973,167357911,167359704,167345102,167361946,167367726,167361129,167361708,167377852,167360569,167360839,167348303,167352488,167346752,167375146,167370614,167355378,167343280,167361135,167361942,167381141,167362000,167346844,167362469,167372461,167366807,167357523,167375919,167358389,167352710,167377320,167371089,167372121,167347712,167354394,167349448,167379950,167380448,167372648,167355963,167367902,167368813,167364655,167361139,167359508,167364718,167371565,167356276,167379898,167374494,167360277,167343111,167372567,167365289,167360832,167347565,167361143,167355964,167367903,167347364,167357504,167344225,167345083,167368458,167344778,167366806,167374326,167377302,167376523,167346111,167365288,167356262,167372119,167347719,167347360,167380944,167364666,167340820,167345685,167371666,167356270,167370888,167377848,167347363,167354026,167368721,167366570,167368933,167346751,167347232,167360566,167366568,167377305,167370613,167363863,167345971,167350943,167360568,167346381,167343566,167369493,167359908,167358024,167348474,167362468,167347710,167349253,167376289,167361393,167343275,167372568,167371941,167359061,167374775,167360276,167354393,167349447,167379171,167350139,167350814,167369817,167358340,167377851,167372750,167376525,167361713,167343279,167354130,167360840,167356759,167344218,167371563,167361999,167361134,167379949,167377303,167368811,167374325,167364667,167349446,167346750,167355722,167346121,167354025,167374159,167348484,167376845,167368434,167373326,167357503,167367724,167343112,167343837,167349217,167362005,167369062,167379948,167350942,167363862,167359906,167345081,167350815,167363366,167343110,167354391,167349216,167374162,167366218,167348483,167361396,167344440,167354389,167371093,167355720,167350142,167381139,167361404,167355371,167352625,167352985,167360567,167347563,167359506,167345093,167345439,167347726,167367533,167364699,167356964,167379545,167371087,167350131,167370058,167354127,167360830,167376526,167356267,167367537,167357515,167380444,167347711,167354713,167368720,167356963,167346387,167366375,167359701,167345088,167348472,167360274,167360829,167355106,167357520,167356266,167376292,167347562,167372649,167354128,167374127,167363635,167380312,167349569,167352062,167375995,167348482,167361123,167380445,167374773,167367540,167356275,167354392,167346384,167346850,167379177,167360280,167345086,167349625,167363634,167352485,167344114,167354399,167360838,167362472,167349054,167350130,167346117,167343567,167375994,167364704,167347362,167351769,167367532,167349568,167374324,167344769,167346845,167347229,167369501,167347561,167371088,167354126,167372646,167376288,167348302,167343836,167358385,167371564,167372565,167366217,167363317,167364657,167356757,167361940,167346748,167354714,167361402,167361131,167344443,167356265,167351535,167363861,167364702,167349053,167369061,167372749,167368809,167360273,167379544,167358023,167347361,167345684,167359700,167345084,167360828,167343109,167375359,167376290,167369286,167355376,167367725,167352060,167344113,167352487,167365969,167360837,167366803,167374125,167345682,167363141,167345082,167363633,167357502,167345094,167357508,167345678,167354023,167352342,167347231,167347308,167361121,167344441,167367882,167345686,167375068,167354390,167369500,167367538,167359057,167356962,167359699,167354712,167348301,167370056,167374779,167357906,167352482,167345437,167361709,167374780,167362464,167355368,167375358,167366374,167367900,167361941,167374161,167347709,167370062,167352059,167368723,167368137,167362719,167361995,167361120,167366215,167363813,167350939,167377847,167350812,167359904,167372462,167349051,167355716,167375915,167350137,167354388,167349052,167367536,167356961,167365737,167347559,167367729,167356755,167370055,167371560,167352484,167348479,167360271,167362463,167361400,167360826,167343834,167343789,167353109,167350140,167374784,167348485,167361125,167362724,167358388,167345096,167366567,167350813,167379173,167363637,167375361,167358341,167366571,167358342,167361710,167376528,167372416,167368812,167352709,167362720,167374785,167361397,167367539,167354027,167375070,167373329,167352707,167360565,167372566,167369290,167375993,167370612,167355370,167370059,167354715,167359505,167375916,167374158,167367535,167375067,167361997,167363636,167353107,167372120,167371942,167345679,167363143,167377300,167361122,167377301,167379176,167363816,167352063,167345095,167369494,167352984,167357517,167353302,167364703,167344442,167348481,167344217,167371091,167346746) 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'