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-05-03' and '2024-05-08'
and t.termin_id in (167401185,167420998,167421266,167421260,167409721,167422446,167405019,167409725,167427282,167426396,167421272,167426394,167420727,167427290,167433798,167400320,167413622,167416440,167419526,167426739,167421268,167396578,167396903,167406947,167407651,167425584,167432242,167421567,167420457,167399712,167401590,167432741,167408455,167419151,167406152,167418061,167394828,167408635,167406692,167408456,167416202,167400624,167405866,167412174,167403402,167423346,167410721,167398938,167406165,167410454,167428289,167418880,167403955,167416690,167404712,167412543,167400318,167411828,167400472,167411393,167401184,167433566,167404165,167416201,167433802,167411006,167425273,167403610,167410282,167423460,167430262,167410084,167415644,167428295,167423856,167422445,167400628,167411538,167421273,167420152,167412542,167408642,167421900,167401909,167411826,167413186,167418051,167394898,167433567,167411536,167407190,167401394,167431502,167416442,167413789,167406161,167410459,167408637,167428019,167433796,167425863,167405621,167430663,167407387,167398543,167422442,167425271,167399701,167427287,167410085,167417130,167418063,167405413,167403054,167405869,167422927,167404476,167433809,167431145,167422443,167409534,167417127,167422930,167422920,167408453,167410087,167431336,167424659,167417133,167418053,167404470,167406172,167431499,167422435,167395120,167397286,167410284,167418065,167420720,167402638,167427279,167403951,167433810,167431148,167418062,167423459,167405016,167422440,167425860,167396581,167408634,167419533,167422918,167416908,167394899,167403405,167406616,167420064,167428022,167396906,167431147,167421569,167400969,167411010,167405872,167420994,167406169,167428533,167405021,167405022,167396909,167411008,167404235,167405015,167395117,167411012,167430268,167427281,167421562,167401925,167400633,167428523,167404164,167402310,167405871,167421552,167413790,167402302,167424470,167406951,167409727,167423278,167419530,167420723,167411539,167412179,167416441,167406157,167415734,167420725,167428294,167425277,167408643,167409726,167418066,167405404,167417135,167410096,167410456,167411398,167431337,167423853,167422931,167406171,167425272,167403612,167405023,167418070,167421555,167416133,167431759,167414820,167410462,167424276,167407191,167421568,167422432,167394896,167427293,167424661,167428535,167404168,167400129,167424284,167421895,167403623,167428297,167410461,167426397,167402306,167422924,167428026,167420157,167395122,167406948,167418886,167421263,167410451,167433808,167401188,167399699,167400476,167421564,167422033,167401187,167401398,167402301,167419141,167424658,167421000,167422039,167400622,167405406,167409728,167420458,167403084,167406176,167413624,167400128,167428296,167400968,167406481,167422434,167431020,167420995,167401396,167431146,167426778,167406619,167406950,167417126,167428025,167424750,167410090,167428024,167425270,167428531,167415648,167421898,167422439,167416700,167410088,167427291,167394397,167411396,167401397,167428016,167421570,167403952,167420452,167401922,167414819,167427289,167431758,167394825,167428011,167416691,167418881,167424469,167410452,167399709,167411005,167397283,167405627,167410094,167428018,167425588,167411535,167432241,167433805,167424272,167415649,167404166,167430668,167421264,167403620,167425278,167412178,167404843,167394414,167405630,167424749,167428023,167394830,167410089,167420156,167430267,167427280,167424275,167406163,167400475,167404715,167394895,167409538,167413189,167407388,167401911,167423276,167421271,167410097,167431501,167401902,167426740,167419143,167431149,167420728,167403087,167420726,167396911,167400127,167411835,167398549,167411397,167399692,167406174,167401589,167411830,167417134,167406170,167404475,167419146,167428532,167428014,167426743,167427278,167401189,167421262,167404841,167400631,167432240,167416130,167420453,167410453,167409722,167433804,167424283,167417136,167394827,167396579,167421566,167432243,167414817,167409724,167424746,167410287,167418068,167425856,167427288,167416698,167421896,167399688,167406691,167433815,167397285,167418067,167428021,167413184,167410095,167422929,167421899,167401912,167428530,167429653,167416132,167430665,167410457,167410724,167425276,167400627,167403954,167420456,167422923,167396905,167396580,167423855,167402303,167394398,167401910,167411829,167433586,167404714,167404236,167422036,167403617,167426776,167409537,167400130,167413188,167423277,167402304,167420065,167415647,167398544,167431338,167413623,167415650,167403086,167426393,167420724,167415643,167430882,167399691,167406949,167427283,167421559,167408636,167411009,167401901,167431500,167428529,167406618,167411832,167399703,167425275,167413190,167418884,167399693,167430880,167433585,167401904,167426392,167425279,167427285,167404713,167406173,167416693,167401935,167428528,167405410,167431757,167422430,167403192,167406154,167401190,167398761,167407189,167406615,167428287,167419529,167394826,167431335,167400131,167422928,167421554,167420722,167427284,167398937,167429955,167428527,167430266,167433807,167408454,167403622,167417138,167430667,167403959,167425858,167430664,167428291,167398762,167411537,167404471,167410723,167403404,167405870,167412176,167413626,167406159,167433806,167426387,167419525,167403083,167411831,167423854,167405411,167426775,167411395,167397284,167400473,167416450,167400319,167401903,167407389,167403953,167400625,167413625,167429956,167394897,167406592,167429654,167420718,167421267,167424660,167401917,167403085,167426391,167420721,167396910,167415645,167424274,167395121,167428520,167426390,167424285,167401936,167411007,167424280,167428526,167416203,167426741,167411394,167408641,167403611,167403052,167405867,167422926,167418049,167405405,167398763,167401916,167416701,167421565,167428525,167406158,167418064,167425586,167433811,167404479,167428020,167408457,167422431,167421561,167420153,167416443,167431497,167433803,167415115,167422921,167418882,167428292,167419531,167401907,167419152,167428519,167407650,167426773,167416696,167411004,167396577,167396902,167406946,167421558,167416449,167424282,167413791,167425274,167425585,167422922,167416695,167420999,167406160,167419528,167410283,167414818,167430265,167419142,167421265,167410455,167404842,167413185,167422441,167400970,167395119,167411825,167416910,167424273,167399694,167399690,167420154,167417139,167403403,167404167,167412177,167427286,167398540,167418048,167408633,167406943,167398551,167428524,167429954,167422438,167421270,167429170,167408452,167400471,167423461,167419145,167415646,167424281,167421261,167401921,167420717,167400317,167402311,167405018,167398542,167410086,167407737,167414814,167420997,167421553,167401931,167418883,167425587,167425859,167416699,167427276,167413191,167405628,167409536,167425857,167428015,167405868,167412175,167428293,167410460,167396904,167411003,167411833,167422034,167409723,167405017,167409535,167422444,167414816,167403619,167417137,167419147,167419527,167428012,167428286,167411824,167428010,167413183,167416697,167420454,167413627,167418885,167432244,167424270,167431498,167419524,167418050,167406155,167401920,167411837,167410726,167411011,167410286,167422031,167421560,167402312,167418055,167432740,167427292,167422447,167433812,167429655,167432794,167405629,167426388,167416692,167423347,167420996,167431021,167404716,167420455,167394829,167410285,167405020,167400967,167406164,167400126,167416909,167426742,167411834,167398545,167402305,167403200,167424471,167406162,167433797,167404472,167401186,167406944,167422035,167418069,167410722,167428017,167428534,167416694,167410725,167416912,167426395,167420155,167426777,167400626,167419144,167411392,167419532,167412544,167417128,167431334,167407652,167421269,167428521,167420063,167404469,167406175,167422437,167430264,167418052,167407739,167404711,167406153,167433813,167424747,167414813,167427277,167410458,167401900,167417131,167428522,167411838,167417129,167413187,167430666,167420719,167403618,167430662,167408644,167401930,167433801,167426386,167426389,167399687,167400321,167403406,167401919,167399686,167420066,167401183,167433565,167406156,167395118,167401395,167400620,167404844,167417132,167400632,167416911,167407653,167405407,167400474,167430881,167424472,167418054,167400621,167398550,167429957,167428290,167405412,167411836,167424748,167399711,167424271,167411827,167426774,167394399,167404480,167418056,167421556,167422433,167416131,167428288,167428013) 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,167341712,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'