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 (167375351,167348495,167345855,167345624,167351547,167377993,167369513,167355886,167356890,167354250,167367393,167348213,167347018,167376602,167364513,167344383,167361033,167357821,167361329,167377146,167348823,167354253,167357342,167361589,167363587,167358222,167371444,167353292,167379245,167348210,167350157,167368537,167352479,167366951,167354600,167351549,167371435,167357814,167354599,167356132,167380609,167361884,167360747,167360500,167374808,167355125,167361597,167357816,167359269,167369518,167344971,167360010,167360745,167365840,167374501,167374804,167364514,167356694,167348500,167375989,167344568,167349455,167345860,167356888,167369509,167355120,167344978,167355124,167361326,167359272,167347954,167355126,167366938,167366947,167368822,167374811,167374796,167344571,167377998,167364517,167357339,167375350,167380308,167355593,167368130,167346046,167356693,167374801,167344382,167361595,167345858,167379237,167366949,167360005,167375355,167363396,167356695,167357813,167359271,167359267,167348212,167361030,167349458,167367385,167347023,167369740,167364519,167351548,167354883,167352132,167379238,167374806,167347575,167345299,167369516,167360748,167357817,167358551,167371439,167375352,167344965,167360003,167364997,167345623,167347574,167345298,167345852,167347020,167361026,167347577,167357819,167364989,167355884,167353290,167347952,167345293,167345296,167368133,167361028,167345304,167359276,167345305,167358218,167368134,167354884,167380608,167360007,167364512,167371436,167376601,167360750,167379242,167359270,167355888,167356133,167356487,167352133,167346347,167369931,167350153,167348826,167345865,167368821,167348499,167371446,167345853,167359280,167345866,167371443,167368823,167354885,167366946,167350159,167356490,167356134,167348494,167377997,167362862,167377151,167358221,167371445,167344574,167366941,167344569,167353955,167356696,167374798,167353293,167369515,167356697,167353295,167344381,167368468,167345854,167360749,167366944,167367970,167353954,167380610,167353291,167344980,167344580,167365935,167346346,167364988,167344575,167377152,167361328,167359859,167346350,167347955,167346344,167377994,167377147,167367390,167347573,167361588,167363586,167362486,167379236,167369930,167360744,167365936,167374799,167365937,167374805,167375855,167361031,167345625,167348825,167376599,167344970,167349457,167348215,167361590,167348501,167357347,167379243,167344567,167361883,167359265,167345297,167367389,167344377,167346574,167346045,167350791,167360004,167346568,167379240,167359278,167377153,167361594,167352135,167361034,167374809,167360746,167357818,167374810,167359858,167362488,167344979,167347024,167354252,167374802,167366940,167359279,167359275,167374795,167346571,167350790,167379246,167352478,167349460,167362487,167369514,167344378,167367391,167361599,167376460,167361587,167368131,167343769,167350789,167366945,167360243,167347014,167358223,167371447,167347951,167350792,167346048,167358549,167356486,167345862,167355885,167361598,167345301,167358550,167356887,167363588,167345861,167344576,167360244,167357341,167359268,167371440,167347015,167357343,167355592,167357350,167366948,167366950,167360011,167355594,167351546,167357340,167361586,167364991,167360499,167348214,167359277,167354603,167356136,167357822,167360743,167356698,167350158,167371873,167346570,167345864,167347021,167353957,167364999,167380611,167364515,167366952,167346349,167377148,167375354,167361027,167348216,167364992,167374797,167357344,167344967,167361327,167346052,167349459,167361029,167361596,167379239,167347576,167354886,167364996,167345300,167344973,167369517,167344582,167364990,167365938,167347017,167369508,167356135,167356886,167369746,167360742,167379244,167365000,167354602,167356889,167355887,167360002,167367388,167377150,167377145,167379235,167360009,167344977,167344966,167353953,167374807,167344581,167361325,167347016,167344968,167376600,167364510,167369745,167357820,167358552,167371442,167353956,167357346,167346047,167347953,167344578,167345303,167359266,167345859,167347022,167364516,167353294,167354255,167348824,167358217,167371438,167346051,167366939,167355119,167369744,167344380,167348211,167347572,167367392,167360501,167348493,167360242,167347013,167362861,167374800,167364511,167360008,167355118,167354598,167356131,167356692,167344566,167359273,167354601,167350156,167356489,167357345,167375353,167344972,167359274,167361593,167367387,167348830,167376598,167360751,167358220,167366943,167352134,167367971,167355121,167374803,167357815,167346351,167377995,167348827,167358219,167361032,167357348,167361592,167346348,167354254,167364993,167366942,167343770,167356488,167368132,167365934,167360006,167345294,167350155,167361591,167355123,167355122,167346572,167377149,167344579,167354251,167365839,167344572,167344573,167350154,167349456,167350152,167356891,167357349,167364518,167370283,167371437) 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'