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 (167343653,167344460,167361443,167375205,167368563,167353045,167375204,167376935,167353384,167358999,167375200,167361185,167363493,167372132,167357693,167363488,167369002,167353837,167348193,167371192,167368738,167345120,167374175,167355459,167356788,167359013,167355445,167380491,167367167,167344791,167377811,167347428,167356564,167345116,167349307,167356305,167356569,167366800,167364303,167361445,167355457,167360879,167361187,167345985,167367586,167346857,167363484,167362419,167358431,167368739,167349312,167375718,167354379,167372140,167356301,167352398,167360608,167360876,167376944,167356307,167361196,167359901,167348337,167370767,167345709,167360600,167352761,167347741,167343647,167349305,167345115,167345706,167357096,167368564,167376943,167359004,167356792,167344235,167367174,167374170,167363489,167367588,167366234,167352550,167372558,167369833,167360881,167376937,167357104,167353844,167375207,167356795,167369180,167345981,167375480,167357099,167370763,167357690,167356785,167379151,167370759,167372550,167353095,167369830,167362422,167345698,167348188,167361988,167346407,167354964,167353041,167363437,167352231,167352684,167347732,167345703,167354375,167343353,167363324,167345109,167359897,167375201,167372560,167363326,167354086,167367911,167369359,167351451,167368207,167376336,167366796,167355455,167352762,167369007,167369354,167356304,167372136,167361785,167360598,167345696,167345986,167368448,167361188,167357973,167362851,167352553,167352678,167359659,167367169,167375482,167343361,167353382,167370550,167345982,167357702,167359660,167353388,167362849,167374603,167376946,167368745,167366235,167360601,167352403,167346398,167356787,167357095,167352232,167354384,167344463,167375474,167343356,167354373,167360883,167346873,167364304,167358438,167360878,167356308,167363487,167374601,167348343,167375716,167352676,167360602,167353381,167354372,167360877,167376933,167344784,167371211,167360108,167368736,167355456,167352766,167347436,167360104,167376947,167353100,167344793,167356303,167380496,167354087,167374183,167352235,167368565,167348100,167357967,167343648,167352677,167355993,167357695,167354095,167354707,167371204,167353086,167379839,167371206,167343365,167358440,167366599,167347744,167360614,167343359,167380488,167363486,167371722,167343650,167344458,167368203,167344785,167361987,167355997,167349954,167358435,167347736,167344453,167360605,167344451,167361198,167351457,167379144,167377806,167357965,167354702,167346397,167367916,167352402,167348184,167354956,167364308,167379830,167374417,167346858,167366595,167356783,167362423,167352223,167366226,167363497,167364759,167355995,167349951,167366793,167376344,167360890,167360373,167363327,167372561,167367599,167368560,167355453,167352228,167377804,167371725,167371209,167367171,167353084,167363435,167348186,167352237,167345702,167362847,167348183,167361782,167361186,167351456,167347434,167360382,167369831,167353035,167368881,167361781,167376342,167358998,167353096,167364772,167367163,167348194,167352222,167356306,167356298,167375475,167364767,167354708,167376339,167354699,167374419,167356786,167346867,167371202,167371210,167360109,167360887,167357111,167356000,167347743,167360880,167357694,167361442,167379828,167371196,167357105,167348189,167354960,167379837,167356794,167379831,167355447,167343354,167367157,167349953,167379838,167366598,167368742,167346872,167368200,167376934,167353380,167346856,167354094,167357688,167374421,167366593,167369175,167349949,167364762,167349957,167376932,167356578,167353044,167360609,167346404,167371716,167368445,167352767,167352404,167354701,167355463,167352225,167359666,167354378,167366225,167357969,167359662,167370771,167361992,167370547,167364768,167351458,167343364,167369179,167359658,167360110,167352405,167377817,167379833,167345979,167374418,167375709,167374172,167369009,167347439,167377815,167344459,167354093,167369828,167369184,167361449,167354959,167354376,167360884,167371186,167363439,167366233,167366231,167367595,167357971,167352680,167361453,167366596,167356791,167366798,167372554,167375712,167361787,167347731,167354961,167361452,167346403,167346865,167368877,167354085,167369173,167354377,167360603,167361454,167360607,167352397,167346863,167360612,167368878,167359015,167370916,167363496,167353840,167379142,167371717,167369350,167375714,167376340,167354958,167369853,167352764,167360604,167349306,167375203,167343649,167363490,167366794,167353043,167355994,167368202,167356300,167360383,167364311,167377814,167354957,167380490,167374410,167364305,167368201,167360381,167359001,167354090,167367178,167377803,167356297,167362418,167369182,167379149,167354088,167370920,167345123,167359900,167375199,167360599,167362845,167352760,167345697,167368873,167368734,167370554,167363325,167346401,167374179,167370912,167361456,167360103,167371711,167344237,167353097,167368882,167355991,167376940,167367592,167370546,167344452,167367176,167364310,167349303,167379140,167344233,167353088,167374425,167345124,167352401,167353099,167367168,167361986,167344246,167367587,167354948,167363323,167368744,167359005,167352233,167356573,167361455,167379138,167360390,167367909,167354706,167374422,167351455,167357974,167352236,167348192,167358437,167361985,167363440,167361447,167361184,167369174,167345107,167368880,167357975,167367910,167357697,167374173,167355992,167377813,167347735,167358997,167359657,167356565,167344783,167376936,167361984,167345711,167354092,167345114,167361780,167367914,167368559,167353836,167368875,167353036,167349947,167359006,167367160,167352683,167366594,167369006,167364770,167372125,167367598,167357696,167354096,167369351,167366792,167344786,167360372,167356567,167379152,167346866,167356572,167356793,167345704,167356796,167364302,167369837,167371193,167345978,167368733,167356789,167360885,167376942,167353039,167371208,167359661,167371715,167357979,167366795,167349304,167347427,167374609,167352681,167352546,167370922,167369834,167348342,167360386,167368199,167361451,167348336,167367159,167357968,167365388,167369942,167360888,167371198,167363433,167354097,167368741,167352234,167369353,167362852,167346868,167347437,167343652,167368743,167356579,167359002,167343363,167356797,167355450,167352400,167368206,167364307,167353040,167377822,167361783,167359664,167364758,167375472,167360886,167374186,167379143,167357701,167366592,167354955,167352224,167360388,167353383,167367583,167375198,167361983,167351450,167344245,167358432,167354700,167377809,167376335,167352552,167356007,167357098,167372124,167361991,167376948,167357110,167354963,167346859,167371187,167357966,167371212,167376341,167357108,167348191,167365389,167368446,167343360,167370555,167359668,167345987,167353085,167352396,167363495,167353845,167367593,167347440,167357704,167361791,167370924,167356799,167377821,167346869,167362854,167359008,167367589,167368444,167364301,167375706,167352759,167344248,167367177,167362426,167366801,167370762,167343358,167344467,167344794,167372142,167372551,167362853,167371199,167352685,167377825,167353842,167372131,167354380,167353841,167362429,167352238,167375719,167354709,167355448,167353387,167372556,167354381,167356003,167366229,167361199,167363498,167367594,167376334,167348182,167353038,167367912,167364315,167353094,167348190,167366799,167360891,167375210,167368566,167360613,167375483,167361790,167379150,167370764,167368413,167353087,167357703,167369358,167355458,167345118,167344449,167347426,167352675,167349958,167369829,167356002,167352769,167360389,167361779,167379137,167379146,167353843,167374608,167357978,167356784,167355998,167347432,167357103,167367175,167348339,167371719,167364314,167349296,167374185,167357977,167346393,167353182,167349311,167357970,167347737,167377802,167374171,167365387,167357109,167362425,167354385,167363436,167361789,167359016,167359665,167361990,167375717,167360889,167374184,167372555,167379145,167345105,167364313,167368460,167346860,167347729,167363485,167372127,167369181,167361197,167344234,167360611,167356001,167343352,167369836,167367154,167354091,167375209,167344465,167376945,167349959,167343654,167371185,167348099,167374177,167349956,167352765,167363438,167357976,167369835,167380494,167374607,167366236,167343362,167371205,167353042,167377824,167370772,167366597,167370553,167370923,167362846,167354962,167371712,167353386,167364312,167367170,167362424,167357689,167375481,167349310,167369008,167352682,167374423,167356576,167345699,167374181,167348330,167358439,167344240,167365392,167344788,167363494,167352551,167353385,167347738,167345705,167379836,167357972,167368879,167370917,167369356,167364306,167352763,167344241,167372137,167345117,167349309,167361189,167357691,167375208,167357107,167372552,167344236,167364765,167374606,167380493,167345129,167371718,167374180,167360387,167355999,167346394,167347730,167368205,167376931,167361195,167369010,167345988,167346396,167377807,167345111,167372553,167363432,167364763,167359899,167371713,167368208,167355454,167380487,167374600,167349948,167347435,167370545,167356574,167379139,167361194,167357699,167348341,167375202,167347747,167371203,167368746,167346408,167366797,167379835,167348340,167354089,167346864,167368740,167366228,167357983,167368561,167380495,167370768,167346874,167349308,167375479,167362850,167357698,167377823,167351449,167369355,167376941,167370551,167371197,167359667,167376343,167361786,167352679,167372133,167374420,167374424,167357700,167345125,167365391,167358436,167372141,167362420,167367915,167361446,167374602,167344247,167374605,167359663,167371724,167359003,167351454,167375711,167368204,167374178,167343651,167360371,167346395,167375206,167360107,167361193,167354705,167361450,167369832,167360606,167344242,167364309,167352230,167348338,167364764,167380492,167352226,167379834,167375473,167357692,167354947,167369178,167375478,167368735,167347433,167356798,167369183,167364769,167360610,167346402,167360385,167367596,167361192,167363491,167374604,167361788,167371191,167347438,167343357,167361989,167361444,167370552,167356302,167379141,167361191,167376939,167369352,167355452,167345110,167361190,167357102,167345989,167361448,167360106,167348329,167370921,167353422,167363434,167366227,167356571,167368876,167365390,167361784,167345710,167344464,167356790,167347431,167348187,167367164,167362848,167359898,167349295,167362421,167352549,167347417,167355451,167369177,167349952,167355446,167357097,167344456,167356570,167351453,167353839,167360882,167368562,167376938,167354703,167344792,167360384,167343355,167370761,167356577,167372126,167345119,167368447,167352227,167355996,167352548,167359014,167352547,167370549,167357101,167344457,167347430,167353098,167375476,167369003,167353838,167356296,167374176,167369176,167358433,167359000,167354374,167352399,167380489,167368737,167379829,167351452,167352768,167377818,167352229,167360105,167364757,167370919,167356566,167368874,167369357,167377810,167366232,167367158,167356299,167355449,167357100,167348185,167344450,167349950,167347742,167357106,167370548,167371188,167369005,167374174,167360374,167344466,167369001,167349955,167345980,167375477,167365393,167347429,167372130,167354704,167367161,167371723,167363492,167366230,167369004,167367597,167356568,167353037,167375710,167379832,167375211,167359007,167344787,167356575,167358434) 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'