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-06-15' and '2024-06-19'
and t.termin_id in (167693573,167709349,167696956,167696954,167688764,167696955,167700093,167709209,167694238,167697262,167706826,167690084,167692696,167703016,167689703,167689712,167693338,167715678,167693356,167702176,167691613,167698761,167699113,167689126,167697263,167709459,167703252,167693833,167706830,167694244,167697277,167686645,167689936,167690401,167704374,167704240,167701095,167693828,167691908,167704868,167711425,167704375,167698236,167702413,167702609,167691190,167708486,167711078,167689002,167699117,167694236,167689127,167712866,167700881,167695038,167691909,167689000,167699890,167700472,167703015,167693339,167699120,167699886,167690956,167689935,167690704,167688139,167689294,167710321,167704371,167692697,167699118,167703008,167688152,167693832,167702602,167711959,167703012,167704245,167700095,167690955,167690085,167690948,167690958,167712190,167689705,167691607,167699887,167689001,167712447,167698470,167694248,167705968,167711958,167699456,167698239,167702173,167699888,167695040,167694241,167700097,167713581,167707201,167697281,167695891,167697868,167700098,167703251,167698763,167698764,167701703,167711782,167689004,167694488,167697276,167706833,167702174,167705421,167694243,167700878,167697888,167710327,167704870,167703007,167688151,167697874,167704243,167697282,167701520,167712189,167712695,167703249,167704865,167703248,167690711,167710326,167718895,167713583,167689003,167709769,167701944,167709462,167704631,167688142,167693350,167715905,167688664,167702172,167693349,167700096,167712868,167704635,167707203,167690402,167697273,167697878,167706825,167688155,167698760,167697508,167709766,167690411,167711966,167689358,167697505,167688662,167695050,167699584,167692887,167697269,167698234,167697882,167710324,167699463,167702175,167704634,167697506,167705971,167695892,167691907,167703566,167689713,167688154,167709775,167712188,167690400,167701697,167689313,167710320,167704246,167690710,167715907,167697865,167701091,167705886,167705969,167697887,167711963,167690408,167690957,167703011,167701300,167695041,167701515,167712694,167697272,167695047,167695295,167691610,167713950,167697278,167690077,167693346,167712448,167718889,167695890,167698968,167696091,167704867,167699459,167702416,167693929,167688419,167689311,167718896,167693831,167706964,167704633,167688143,167709464,167695039,167691614,167693537,167711780,167701699,167699122,167697870,167697871,167692884,167704871,167711960,167690954,167700475,167701093,167701945,167686644,167709771,167694237,167691615,167689707,167693355,167700091,167698759,167688661,167695893,167689312,167701948,167703390,167713584,167697864,167699884,167712696,167698766,167712698,167698471,167690083,167702414,167695048,167711968,167706827,167711075,167686827,167693347,167700481,167712449,167694247,167712453,167709465,167700473,167713948,167702179,167704627,167699461,167706824,167699462,167711969,167710323,167697268,167695894,167695049,167692885,167689353,167689125,167711076,167712865,167686825,167701518,167701519,167688663,167712450,167704020,167704373,167711072,167704241,167698235,167697264,167701514,167699112,167699454,167696087,167693337,167702182,167704628,167693830,167703250,167716111,167693825,167711779,167703389,167688153,167701516,167705884,167688665,167700092,167704864,167693829,167698241,167697884,167711077,167688144,167699581,167702412,167701299,167690410,167690713,167701303,167706963,167712446,167700477,167712730,167711071,167706828,167690714,167712451,167706829,167709211,167713079,167704372,167713585,167698762,167701301,167713582,167698232,167700471,167702178,167701947,167709206,167694240,167690947,167702606,167699123,167705892,167707202,167690945,167709764,167690946,167704869,167703010,167705888,167700476,167697877,167691609,167709773,167711426,167718888,167689714,167718898,167712452,167713951,167696325,167713949,167699116,167712909,167693827,167698233,167711423,167693534,167697889,167711961,167703567,167718891,167705889,167690712,167703013,167695548,167702607,167700100,167700879,167699583,167699885,167690078,167712697,167696094,167702177,167689356,167711084,167703009,167698765,167689355,167688141,167705885,167689354,167693535,167689309,167715674,167699455,167692325,167695294,167706823,167697872,167697267,167702181,167690405,167705883,167711967,167700099,167690086,167712191,167694239,167693538,167699114,167713586,167705970,167701700,167693357,167691194,167718897,167701949,167704247,167699585,167704636,167692329,167691616,167709213,167690949,167697879,167696095,167701698,167703014,167712869,167688420,167706962,167700480,167709770,167694246,167705891,167702608,167705890,167704021,167705274,167704632,167695042,167694245,167711781,167706831,167689706,167693354,167691193,167709765,167698456,167700479,167711965,167701094,167692328,167697507,167702415,167715677,167709212,167701302,167699121,167700880,167698240,167689357,167710325,167701701,167704244,167697883,167699889,167692886,167718894,167718890,167697284,167699460,167700478,167699119,167699458,167711424,167693353,167704019,167693352,167697890,167698758,167706832,167690409,167691192,167699457,167710322,167718893,167715904,167696093,167702180,167697274,167715676,167692327,167712867,167686826,167693826,167693536,167697283,167718892,167694242,167693351,167705887,167702605,167693348,167701946,167688418,167689704,167704866,167711778,167711083,167690705,167691191,167689310,167704630,167702604,167696415,167699582,167709463,167701092,167700094,167696088,167699115,167709210,167692326,167715675,167715903,167708485,167711422,167701517,167704018,167691608,167700474,167696414,167702603,167701702,167704629,167704242,167697504,167718899,167688417,167709774,167711962,167697869,167697285,167697275,167711964,167699111,167697875,167697891,167696092) 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'