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 (167374823,167357836,167345829,167355146,167363661,167352364,167378012,167365950,167364528,167352638,167368860,167379025,167375859,167355136,167344869,167375860,167366641,167356057,167345558,167369993,167358500,167367949,167371885,167360514,167365874,167371976,167355822,167359548,167379010,167344604,167356439,167347903,167361901,167355509,167354816,167364953,167354527,167354528,167367396,167366888,167367415,167366923,167359967,167346248,167360511,167375948,167354798,167366920,167357356,167349469,167365949,167347586,167348200,167351555,167355147,167359970,167357835,167353339,167346543,167354210,167347888,167345256,167358159,167351572,167351570,167358165,167348531,167361889,167346938,167348226,167356903,167348524,167374223,167350166,167360765,167344619,167356915,167361335,167369996,167359966,167370597,167360510,167379022,167367402,167367424,167351569,167374834,167344857,167374833,167350192,167380556,167353906,167344621,167346535,167375867,167355499,167358493,167348509,167371673,167345289,167366931,167356704,167354198,167346234,167359964,167371877,167379020,167374831,167346931,167366925,167368502,167344607,167368162,167359965,167345262,167356908,167356049,167359960,167344620,167346540,167369754,167380547,167361891,167368827,167366636,167352637,167374222,167377172,167354197,167354525,167361895,167368161,167358172,167377170,167361336,167361612,167348229,167354536,167355832,167361890,167379000,167354810,167351568,167355498,167359216,167360770,167346534,167362509,167350183,167356047,167367407,167344882,167357374,167349472,167374516,167365730,167345573,167356906,167365947,167357833,167353904,167369312,167357358,167367734,167376549,167376465,167350824,167360775,167361050,167357380,167345846,167344321,167362499,167344858,167369314,167356436,167345564,167351567,167372466,167354811,167360761,167369071,167376231,167364960,167379017,167356904,167371452,167359208,167367416,167364544,167343301,167361051,167355489,167346242,167355135,167374520,167355151,167344861,167345568,167366889,167376236,167368675,167355506,167350826,167354516,167359971,167344322,167356895,167369998,167368230,167354523,167369249,167375865,167371462,167378008,167357834,167354538,167344606,167361614,167346926,167360767,167360199,167345841,167354209,167345279,167380557,167355824,167374818,167347602,167345581,167379021,167379011,167356434,167356905,167374835,167350167,167364954,167369994,167361892,167376472,167345288,167362741,167362505,167350823,167364941,167375951,167364538,167355825,167357832,167362500,167372417,167346537,167359963,167358171,167346538,167356052,167358158,167352636,167352996,167377163,167360517,167353073,167347911,167354512,167362099,167368861,167361618,167343712,167366640,167360758,167380558,167374331,167346249,167370032,167364943,167348202,167365948,167367420,167378011,167356432,167352158,167364545,167360760,167369752,167358167,167361607,167362511,167369529,167364527,167362101,167354195,167355132,167350193,167346939,167352581,167357367,167347604,167371456,167352580,167359961,167344337,167367951,167374819,167344346,167374217,167364546,167344618,167361039,167366402,167374507,167358502,167352155,167364948,167365729,167361040,167371143,167354812,167362493,167359189,167375862,167359209,167365945,167371459,167354207,167378996,167350179,167374334,167374824,167377167,167354206,167371876,167357842,167344329,167376553,167347591,167352159,167364942,167345287,167377165,167358491,167364540,167355490,167376307,167377169,167355487,167362512,167372626,167368515,167359805,167359191,167376234,167358170,167346920,167371973,167347587,167352998,167371468,167358157,167354813,167345839,167362735,167362094,167350834,167367954,167345830,167378013,167363660,167356050,167352157,167344870,167376238,167371974,167374332,167364963,167371467,167344610,167379002,167364940,167347603,167347896,167377168,167354513,167355502,167360202,167359198,167363601,167367950,167371458,167364939,167350836,167344868,167378002,167361610,167344340,167352363,167361611,167375409,167350178,167374216,167371464,167343304,167380550,167348507,167365873,167353902,167348519,167357355,167362732,167359962,167346917,167379009,167350181,167377162,167350177,167346550,167366929,167366403,167370033,167374821,167356916,167372627,167359193,167371041,167371980,167364952,167344338,167367425,167353908,167374218,167376308,167372467,167360768,167357844,167349473,167374836,167374820,167356914,167371884,167356708,167375870,167360201,167359213,167371038,167356058,167345277,167374519,167345570,167354524,167363598,167346919,167372418,167354800,167369991,167353907,167365944,167375080,167358168,167355823,167375869,167359206,167346554,167379008,167344615,167378006,167376550,167358166,167348228,167371037,167367413,167366930,167360764,167347905,167360759,167361608,167362734,167346929,167343421,167345275,167374219,167379012,167367399,167358156,167343302,167360762,167355501,167346253,167346940,167355831,167356048,167362506,167359969,167346231,167355133,167347891,167353903,167353071,167378003,167365951,167350169,167364956,167357359,167345847,167369896,167362095,167371457,167362096,167348510,167366927,167361903,167344884,167358173,167359804,167356051,167353072,167356703,167355830,167367406,167375949,167351558,167345828,167376475,167347585,167346533,167368940,167359207,167360763,167371455,167363595,167374839,167345560,167359811,167366404,167376237,167355145,167347600,167371471,167377174,167344859,167374509,167356431,167345582,167368233,167374517,167350195,167371470,167353076,167380549,167375863,167354205,167375413,167364965,167371036,167374224,167361044,167348526,167364949,167371972,167357360,167371975,167344873,167371042,167374226,167371453,167367410,167348511,167361904,167347589,167372465,167346935,167376311,167347594,167376309,167371146,167347606,167366634,167355488,167356907,167366918,167354199,167359194,167371144,167345280,167354802,167374335,167378015,167345815,167369315,167343424,167345255,167352639,167352999,167359959,167357829,167374220,167377171,167359551,167346932,167354522,167344603,167374515,167377173,167371149,167348520,167356433,167352997,167375412,167367419,167374518,167369523,167358154,167351559,167376467,167347593,167354817,167344608,167350185,167351566,167345557,167346229,167348231,167376470,167367397,167348525,167356059,167344320,167371981,167353160,167354529,167354808,167366919,167368512,167371675,167354801,167350191,167347887,167371463,167357357,167361334,167347592,167369992,167364533,167346934,167376474,167345845,167344880,167347889,167369533,167345257,167357830,167359215,167367401,167379016,167360769,167353161,167345842,167378998,167355508,167367409,167365844,167366921,167358494,167347605,167360198,167360776,167371676,167374510,167356709,167378001,167361043,167355507,167356442,167374225,167350184,167354815,167345269,167347906,167364537,167354515,167362510,167375411,167364534,167349474,167356894,167369997,167344883,167359809,167363596,167345266,167343715,167361617,167374822,167362494,167364532,167375410,167350180,167347897,167345268,167380555,167379001,167346930,167361337,167357845,167361615,167359806,167378014,167355148,167346230,167343303,167360200,167366928,167364536,167353342,167365843,167345263,167359968,167366400,167348521,167360516,167348523,167347892,167354526,167355829,167356441,167351571,167361042,167356430,167378009,167351556,167369250,167362100,167374838,167354537,167361894,167348522,167379015,167348230,167346232,167374837,167356056,167361616,167367421,167379024,167347601,167349470,167357831,167347237,167345271,167371454,167354514,167346927,167364961,167362508,167356438,167375947,167353340,167361338,167355150,167367408,167356055,167374832,167347590,167350168,167364955,167356440,167369532,167379014,167376466,167346235,167362495,167356437,167359810,167356054,167350825,167366926,167361624,167371881,167360509,167352156,167344350,167360766,167361041,167368862,167361619,167368939,167354211,167355828,167359212,167360515,167346548,167356705,167369530,167355500,167347315,167363600,167344881,167354814,167356053,167343423,167356707,167359192,167364530,167355134,167351557,167367414,167376473,167371674,167368514,167348227,167355504,167368232,167369751,167343713,167369072,167346551,167345561,167343714,167354208,167353341,167368941,167371979,167368513,167347904,167359550,167363659,167355505,167353075,167348508,167362740,167359205,167366924,167356706,167363599,167355149,167375082,167369753,167362507,167362742,167369524,167346941,167366887,167376242,167375861,167371886,167371878,167347236,167365872,167350165,167353074,167371883,167350194,167345563,167346251,167357373,167361902,167345267,167346553,167371469,167371145,167364964,167368231,167359549,167355826,167374215,167343422,167361613,167354196,167380548,167369313,167358155,167376548,167359211,167362098,167359217,167374508,167354530,167353905,167354799,167366635,167364529,167376235,167377164,167362498,167369070,167354809,167346241,167364531,167347588,167348201,167357843,167357365,167350835,167367403,167350182,167366922,167358492,167370598,167378997,167346223,167345579,167362733,167345276,167360513,167345831,167376471,167344330,167367955,167367423,167358499,167361893,167344616,167349468,167376243,167364539,167357375,167355503,167356435,167359210,167365946,167348533,167343121,167358169,167368501,167375081,167363597,167346544,167355827,167359214,167349471,167371882,167348532,167345814,167376310,167358501,167369995,167349475,167375083,167376244,167369531,167357366,167364535,167371672,167377166,167368160,167361620,167344867,167360512,167345833,167361609,167345571,167379013,167362097,167359190,167363658,167361625,167378007,167346247) 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'