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 (167381414,167377645,167350965,167377399,167373010,167362606,167374026,167373363,167344750,167344196,167376131,167369147,167377524,167347353,167370450,167379964,167375553,167376728,167367523,167379486,167379539,167350572,167373001,167373378,167373069,167377522,167376138,167367084,167376781,167379967,167373358,167379968,167376730,167347352,167347090,167377644,167368100,167380217,167365427,167351967,167381033,167367089,167340908,167378367,167381458,167370449,167377527,167375556,167347356,167351971,167350574,167379735,167379491,167363746,167367087,167373377,167352904,167380224,167381461,167373366,167367527,167363783,167373585,167375298,167373389,167344744,167377646,167373074,167373530,167362604,167366461,167351318,167366468,167349143,167352903,167373008,167340912,167375304,167379969,167347354,167350971,167378373,167378418,167352908,167377642,167379966,167380805,167347086,167347087,167340914,167340905,167350570,167347403,167373933,167367529,167376135,167377523,167376785,167370454,167375305,167373576,167351319,167381029,167379963,167373524,167373383,167373553,167349144,167362601,167351320,167344753,167368097,167367520,167349149,167366459,167375297,167376786,167378933,167376733,167379484,167370883,167368098,167376139,167367521,167362598,167340907,167352902,167379538,167373384,167380218,167351972,167363232,167381032,167379488,167379734,167373781,167373583,167378374,167378870,167378419,167373935,167378596,167370879,167378368,167378935,167373523,167373068,167376735,167350969,167344195,167381031,167381412,167372293,167366465,167379485,167373929,167367083,167367528,167363786,167347093,167381030,167373386,167378569,167360115,167379487,167378371,167377521,167381027,167349142,167362599,167379492,167350970,167375299,167380799,167351969,167344743,167367088,167370882,167381028,167373780,167378570,167367086,167373936,167340909,167347092,167350575,167377647,167373012,167379771,167351316,167374025,167350967,167378370,167378927,167373589,167378929,167362603,167380803,167366467,167350966,167368101,167370447,167373782,167373361,167352913,167379489,167376787,167378599,167360119,167377400,167373777,167368105,167376784,167340910,167365428,167378571,167372288,167350576,167363234,167379962,167379490,167373385,167347085,167376137,167380222,167376729,167376136,167369148,167373362,167378597,167378934,167373588,167375306,167340911,167370453,167377403,167370881,167352912,167380220,167360117,167370452,167373007,167373073,167378567,167380806,167375557,167350571,167378928,167373584,167377643,167377641,167350579,167377525,167378926,167379736,167363236,167373527,167380221,167350968,167344199,167373586,167378369,167373002,167347094,167373930,167340913,167373577,167349150,167351325,167377651,167378600,167373518,167365431,167379971,167381415,167369151,167372297,167373923,167373082,167381413,167370448,167378930,167379970,167349141,167347355,167352907,167372296,167377526,167379493,167380223,167351966,167367526,167373517,167366462,167344747,167350578,167378372,167365430,167381460,167369150,167351324,167367519,167370880,167363235,167362605,167351942,167370451,167377650,167363749,167378681,167373528,167352906,167350577,167369149,167347402,167344198,167380804,167380801,167378568,167376780,167368104,167373011,167379448,167373014,167373390,167373083,167373582,167378873,167379772,167360118,167368102,167349148,167340906,167351323,167367516,167377649,167377627,167373783,167368103,167373078,167344746,167373013,167352905,167377648,167351322,167367522,167381026,167349147,167351317,167351941,167370877,167379737,167373388,167375554,167344751,167375303,167378871,167372289,167363784,167377401,167350569,167376734,167349146,167365429,167372295,167373077,167363748,167351321,167373934,167378680,167362602,167367085,167366466,167344752,167381411,167376732,167376731,167376777,167363782,167380800,167373587,167372290,167366460,167344197,167376783,167344745,167373076,167373387,167375301,167350568,167373365,167349145,167350573,167351970,167378598,167363233,167370878,167378874,167363747,167375300,167379965,167373526,167376778,167360116,167372294,167380219,167340904,167373357,167373364,167368099,167366520,167373009,167376132,167373931,167373525,167362600,167363785,167380802,167380807,167373529,167377402,167347091,167378872,167375302,167376779,167381459,167347357,167373075,167365426,167379770,167363750,167375555) 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'