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 (167420352,167408339,167433095,167416573,167394804,167403209,167401547,167430170,167432607,167416509,167417366,167415105,167387365,167384705,167404495,167418631,167413570,167412344,167429933,167428248,167418396,167402185,167429490,167405631,167426627,167394801,167395592,167415486,167420354,167401285,167384833,167420351,167422262,167405769,167419408,167422260,167339817,167428378,167394920,167420046,167395205,167408345,167409167,167405696,167423701,167384704,167428380,167432186,167428880,167408342,167414638,167395199,167412947,167403212,167418562,167408337,167427647,167408347,167417904,167394917,167429488,167399465,167410821,167417903,167394806,167428941,167433094,167416248,167428379,167417367,167415487,167427076,167413346,167422261,167428608,167405697,167416575,167428384,167429497,167422732,167429487,167429491,167428607,167408346,167413571,167401203,167428598,167424024,167426630,167424715,167395202,167427975,167417369,167395204,167429935,167399428,167405632,167430172,167422072,167424712,167423706,167432465,167394921,167418487,167412346,167428383,167429495,167429500,167410822,167428606,167394805,167418564,167421403,167401546,167399322,167401207,167408338,167413343,167428605,167395862,167398357,167429934,167415485,167419406,167422737,167433093,167418395,167429493,167428604,167412340,167428382,167296230,167420045,167408344,167399466,167421402,167395201,167399321,167404496,167428603,167416557,167429492,167412092,167423704,167433096,167422736,167408343,167418394,167402184,167395200,167425591,167394919,167412091,167422074,167415145,167428600,167428381,167401714,167428597,167416508,167428245,167416571,167428247,167411202,167432185,167432609,167416574,167430058,167416510,167428601,167405767,167401607,167408340,167424714,167401205,167408341,167409890,167426628,167424717,167431110,167398356,167428244,167418485,167419407,167422735,167405768,167391225,167418563,167430169,167395198,167403211,167394802,167418393,167418632,167414639,167411506,167414640,167429494,167413350,167428599,167433092,167418392,167413345,167401206,167432608,167401204,167413351,167405766,167404493,167427971,167401712,167412678,167427973,167394918,167422738,167395203,167426626,167296229,167418484,167429496,167404494,167427972,167422731,167412946,167401713,167423702,167424037,167408336,167394772,167417368,167415144,167413344,167426629,167429944,167419409,167424716,167394771,167424713,167418486,167429489,167423705,167427974,167416570,167428246,167416411,167413342,167399319,167416572,167413352,167339816,167428602,167430059,167399320,167416247,167432862,167422734,167414641,167418391,167414637,167423703,167416249,167394916,167399323,167395591,167431260,167412339,167412677,167430171,167412345,167427077) 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'