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 (167348984,167373026,167350767,167351117,167373124,167373037,167354360,167370227,167368625,167357732,167381055,167354361,167375386,167342989,167372013,167363840,167354354,167371261,167371654,167349993,167369960,167376987,167373350,167362806,167343061,167352725,167344483,167352506,167377799,167359883,167371255,167354067,167380695,167381054,167365765,167359025,167373397,167357733,167359037,167354066,167357190,167345451,167362803,167379705,167373254,167363520,167352042,167376857,167376986,167351654,167343845,167366579,167361489,167355390,167377506,167367234,167370952,167366818,167348372,167365985,167359888,167353326,167362931,167373610,167378477,167351115,167361228,167365254,167366584,167376367,167367642,167377792,167373255,167355388,167355006,167373604,167373402,167361225,167346423,167363839,167372025,167373606,167360916,167347472,167375391,167370230,167372150,167360424,167359681,167365420,167346420,167369390,167363124,167371766,167352041,167376990,167376988,167375384,167356250,167354075,167363525,167367221,167380472,167355386,167361967,167342992,167356252,167347480,167365880,167365897,167369961,167360639,167379692,167350001,167375752,167355942,167369955,167352724,167360644,167355393,167362926,167345448,167361969,167377507,167364351,167373842,167369399,167342991,167362924,167373129,167344480,167363377,167367230,167364340,167343844,167377788,167366361,167352504,167346422,167375389,167370953,167356608,167354068,167345455,167351176,167367218,167376369,167373135,167373406,167347469,167361968,167364744,167365760,167367220,167373345,167373123,167363127,167373844,167364741,167353827,167362930,167351113,167373136,167373260,167358410,167351114,167357992,167346413,167353322,167367235,167352043,167363836,167347751,167365258,167356607,167375758,167361491,167367646,167357741,167380473,167352045,167365758,167373351,167354071,167352048,167355948,167378476,167376993,167356257,167377766,167354998,167362404,167354686,167376368,167372147,167377784,167344103,167367653,167343822,167376375,167373605,167357188,167354680,167357171,167356612,167360420,167362798,167371249,167354362,167355956,167365257,167356243,167354343,167371247,167373598,167351177,167378970,167365878,167361230,167371264,167351658,167373246,167380697,167343848,167348980,167342987,167377787,167367651,167368622,167362399,167375385,167363837,167363382,167360427,167360312,167365261,167377511,167354077,167350009,167366369,167370949,167373027,167370782,167348977,167362405,167344478,167351173,167354685,167361492,167361813,167359039,167353824,167376860,167358412,167372153,167350008,167365260,167379166,167357180,167377791,167352945,167379698,167361494,167354997,167366365,167370378,167365759,167378969,167360306,167359884,167364739,167352501,167347759,167381088,167363378,167357730,167365416,167367635,167374647,167377508,167378308,167353195,167360305,167381052,167342990,167349357,167353193,167378473,167372022,167348373,167361811,167376366,167366815,167379169,167360922,167347479,167354353,167373841,167381053,167364339,167365896,167351655,167348382,167349359,167351175,167347471,167373040,167354681,167369953,167359029,167365767,167364735,167366358,167380470,167365879,167380699,167357172,167375063,167365421,167360923,167349361,167357187,167379164,167359024,167345454,167367211,167360426,167351656,167352049,167354684,167362929,167351149,167379433,167370377,167376992,167347478,167371748,167367223,167371248,167354999,167363529,167359887,167350007,167373261,167375064,167347476,167348376,167343031,167366816,167373039,167343849,167364345,167373132,167375060,167369398,167367215,167349343,167346419,167361973,167354076,167375760,167363834,167365415,167368619,167365251,167354342,167352503,167377796,167344102,167362932,167361233,167365895,167361224,167355943,167356242,167365756,167359675,167361821,167368621,167355945,167355387,167351106,167352728,167346133,167378313,167354072,167355949,167363174,167364344,167369956,167360307,167362407,167345457,167363383,167357994,167346414,167354348,167361972,167353821,167352462,167357996,167359040,167350766,167351116,167354365,167351659,167346128,167361229,167351109,167357186,167343846,167355401,167361970,167380471,167377708,167344479,167357189,167375393,167355946,167376989,167379165,167360918,167347474,167346129,167372023,167350004,167358415,167348375,167363844,167342988,167377775,167350771,167353826,167371252,167373138,167370225,167355394,167359889,167343030,167375113,167370954,167356610,167376991,167364352,167363524,167370784,167347753,167366360,167351660,167361227,167373253,167348976,167375112,167365413,167351174,167373837,167360304,167379691,167372151,167347758,167367236,167359028,167361812,167350772,167377771,167374650,167373134,167354347,167360926,167360430,167375390,167364754,167374646,167354344,167363527,167373405,167363379,167363835,167374648,167364350,167348978,167342985,167367897,167367636,167379693,167363128,167376372,167373035,167365761,167362925,167349353,167365252,167367205,167369882,167371256,167343027,167357995,167354070,167362799,167373838,167377795,167362398,167363843,167364338,167366578,167351653,167359023,167373131,167360309,167368623,167377773,167358411,167343847,167377767,167365757,167361809,167379699,167377780,167352505,167370229,167361814,167355002,167369957,167371759,167377797,167373403,167353319,167375755,167354996,167362800,167375748,167375387,167359026,167355402,167371753,167377509,167373252,167370961,167359682,167355944,167346124,167371270,167362403,167356248,167355003,167346418,167347473,167350006,167379467,167371763,167373349,167377774,167373257,167373599,167376985,167369952,167347763,167375747,167373033,167367231,167353202,167360425,167362802,167348371,167349871,167346134,167373032,167346429,167344484,167352500,167346412,167370224,167352722,167351663,167380475,167356604,167354341,167367896,167352461,167362406,167363125,167371253,167353196,167367216,167375754,167370379,167349352,167358420,167361488,167366368,167369391,167359678,167359886,167370381,167380476,167371751,167349351,167377505,167352052,167348979,167379704,167371762,167346135,167352947,167381058,167343064,167357185,167376365,167361223,167353820,167351169,167372146,167371269,167348985,167375761,167370957,167350773,167353324,167364749,167357998,167342983,167343062,167363845,167357734,167355005,167372012,167360418,167353320,167368520,167356241,167379162,167355396,167375744,167364733,167363519,167346127,167362397,167371262,167369393,167366582,167354352,167359684,167356609,167352053,167374118,167370783,167379694,167346428,167353330,167366810,167366370,167367237,167360316,167354349,167373130,167361236,167365250,167354069,167373038,167379161,167360914,167350002,167371764,167343063,167348986,167355955,167344101,167368521,167376373,167357178,167352726,167370958,167348378,167365414,167349342,167357191,167359030,167353327,167363521,167352723,167373607,167351657,167363175,167354355,167377709,167375746,167352727,167360310,167381057,167366585,167364347,167359892,167368627,167344487,167361976,167377705,167358421,167370382,167356605,167360648,167373832,167356613,167359032,167378971,167379690,167378973,167374121,167381056,167372024,167361496,167346137,167373247,167381089,167352040,167348381,167374654,167351664,167357179,167367893,167379170,167375394,167354691,167375756,167367899,167351178,167351665,167351105,167354988,167353829,167352729,167355951,167367649,167376374,167376376,167345461,167378480,167376861,167367652,167361818,167367238,167364752,167352466,167374117,167347764,167370231,167380698,167366812,167358003,167371752,167342984,167354682,167357999,167373396,167373831,167368626,167366362,167353199,167377674,167379697,167351170,167379163,167362805,167378479,167379700,167360311,167370232,167347754,167355395,167361232,167359891,167377785,167380479,167343821,167346415,167349360,167346130,167363526,167359683,167361817,167361497,167367224,167374124,167371131,167342986,167354690,167359031,167372027,167356611,167350765,167360645,167357736,167353325,167343029,167353828,167360647,167367639,167353198,167371246,167371765,167367645,167377782,167375383,167360419,167374638,167365249,167373258,167357997,167356249,167368525,167360915,167347477,167365535,167379590,167360921,167346136,167371754,167380480,167376859,167378937,167362400,167365813,167377798,167367644,167366581,167371268,167378310,167376863,167354689,167352051,167358419,167370787,167374639,167362804,167348379,167380478,167343820,167364343,167343819,167373612,167375392,167367210,167361231,167364742,167345462,167363838,167371651,167365419,167352465,167373259,167378478,167361495,167354074,167365259,167375745,167344486,167369883,167361816,167366583,167355004,167348983,167369959,167365769,167352464,167368524,167359890,167354351,167373348,167351107,167379696,167374653,167363384,167379168,167373041,167373608,167380696,167361975,167363523,167360646,167358418,167370792,167378314,167378315,167378311,167356244,167367638,167354688,167367892,167377707,167366367,167380477,167371254,167347475,167373409,167372154,167375751,167350764,167354364,167364750,167368624,167353192,167373843,167357177,167348374,167373137,167365536,167351662,167359677,167354350,167370959,167369396,167370960,167346427,167354073,167348377,167361974,167364736,167363405,167369958,167352951,167364346,167379167,167360920,167361810,167363334,167367898,167361815,167348982,167365768,167360640,167375749,167350763,167363123,167374655,167358417,167349358,167374123,167374652,167377781,167373408,167377510,167366372,167376996,167367217,167360641,167368620,167367229,167380469,167355001,167351112,167367209,167378974,167371263,167365418,167367643,167378972,167357176,167353323,167370385,167348981,167366817,167375062,167371650,167364342,167365766,167360423,167365253,167372149,167353825,167361493,167347470,167355947,167348380,167370788,167373036,167369395,167353197,167373034,167365256,167349354,167359680,167354687,167362801,167344485,167366366,167355403,167354340,167367650,167365899,167345459,167362411,167378312,167347765,167360919,167363173,167367222,167355392,167363126,167357175,167360308,167379695,167366811,167366373,167355950,167376865,167357738,167373133,167367227,167351111,167373407,167369394,167374651,167374649,167373839,167362797,167378471,167373840,167352046,167352047,167360422,167380474,167363381,167363522,167370779,167345453,167378475,167359679,167371257,167371757,167378472,167372021,167367890,167359676,167378309,167370228,167360642,167355391,167378474,167367214,167375388,167356246,167362928,167362402,167375110,167359027,167371750,167363122,167354363,167367637,167363380,167357737,167352463,167355389,167347755,167345458,167353822,167370791,167351661,167350003,167357174,167362927,167354345,167359885,167354346,167352946,167377706,167375061,167370380,167365898,167356258,167365762,167367228,167360651,167360421,167357173,167372026,167351172,167360917,167349355,167376858,167351110,167353823,167371758,167361500,167367891,167362809,167361971,167355000,167370948,167359038,167344471,167364341,167364740,167356616,167368618,167377769,167344476,167360638,167381051,167357729,167357990,167365847,167357993,167356245,167358414,167353321,167376866,167365417,167375111,167350770,167378323,167362401,167343028,167347752,167345452,167366359,167373256,167357731,167377770,167351171,167366580,167344477,167370226,167352502,167367208,167348975,167363129,167358413,167361490,167354683,167357735,167369392,167348370,167350000,167372020,167370233,167369397,167353194,167352044,167366371,167365255,167365764,167373404,167351108,167368522,167356606,167364734,167369954,167371749,167373609,167350005,167350762,167364751,167371271,167363528,167373611,167360643,167374122,167371267,167352050,167364743,167356247,167358416,167371260,167356251,167361226,167357991,167376864,167369383,167352952,167349356,167371655,167368523) 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'