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 '2025-05-09' and '2025-05-14'
and t.termin_id in (170059075,170080632,170073697,170063252,170085005,170086579,170052058,170066934,170054503,170060994,170051392,170055906,170080624,170063247,170065733,170068591,170077025,170084843,170075672,170080627,170075280,170062037,170079610,170052060,170069086,170048529,170058392,170061278,170064237,170084327,170049217,170080406,170069442,170077725,170061804,170058428,170059080,170065734,170052483,170080408,170051396,170064844,170064250,170060995,170053924,170057161,170079811,170055897,170057519,170057165,170055907,170053932,170082611,170058431,170069441,170054504,170062528,170063686,170078799,170056539,170052487,170065078,170077724,170057813,170079812,170062692,170061260,170069755,170061271,170050810,170073895,170079190,170075666,170082192,170051386,170059707,170076378,170066944,170066090,170061797,170054794,170064238,170075986,170053920,170061793,170061263,170057817,170060634,170083725,170062039,170081258,170061795,170061276,170064841,170060632,170079804,170086591,170065084,170055915,170075984,170075108,170059084,170067490,170081260,170048521,170055894,170071237,170076654,170067489,170069450,170075671,170080622,170051678,170065080,170057819,170048527,170073900,170074395,170055892,170074393,170061262,170078251,170053927,170069748,170069994,170069747,170080617,170082191,170055891,170075994,170077028,170077722,170084847,170053925,170082608,170082606,170055623,170065077,170056541,170060394,170073333,170066933,170067899,170075105,170050812,170069746,170059079,170055220,170057815,170057518,170062694,170084845,170063689,170076659,170057162,170053923,170064243,170079196,170068275,170069446,170084328,170054063,170084329,170050821,170059081,170061259,170058427,170075667,170059074,170064231,170086587,170056543,170063251,170065736,170082607,170073696,170060392,170073897,170073158,170075668,170075109,170066942,170065083,170058580,170056538,170069451,170068274,170054065,170071232,170075107,170073695,170058644,170058578,170050814,170073563,170066091,170085001,170079186,170068593,170073159,170068669,170049218,170080616,170080407,170054064,170060395,170082605,170060630,170060625,170050268,170063695,170079189,170069083,170057820,170074392,170058576,170057810,170083421,170071983,170058336,170057516,170067897,170068590,170060629,170050269,170062537,170061261,170066943,170064229,170086588,170080633,170057514,170076379,170074810,170079813,170055898,170056683,170062691,170066084,170073332,170069082,170079817,170058643,170054062,170075104,170074390,170054792,170075284,170072710,170076382,170082609,170076657,170073156,170080405,170061264,170060390,170051384,170059705,170063687,170053929,170078797,170060393,170080615,170074391,170060398,170062531,170071241,170079184,170050271,170076384,170080623,170078250,170050817,170061794,170082604,170073334,170063696,170060285,170063042,170082610,170050816,170065465,170062038,170059706,170055624,170060397,170054066,170059082,170080631,170057821,170058575,170067896,170055221,170050265,170058337,170071984,170067901,170061272,170079197,170064248,170069440,170051677,170062695,170077024,170073567,170064233,170058421,170074396,170056542,170055275,170064246,170063041,170069993,170055904,170077521,170078254,170071231,170051393,170057220,170064255,170082193,170075991,170053919,170083723,170065464,170069439,170079816,170080625,170055909,170053922,170081263,170074389,170057822,170058577,170056544,170080626,170066086,170053921,170048528,170081259,170056549,170055625,170057811,170078253,170076656,170060389,170069753,170062529,170055219,170064245,170057809,170075281,170050808,170061265,170075983,170064840,170065462,170069749,170080635,170054793,170085002,170067898,170050272,170053930,170057160,170069443,170079194,170061266,170068670,170051388,170076383,170084846,170071238,170063693,170075279,170062036,170055899,170064251,170071242,170048530,170055910,170048526,170060286,170062693,170064247,170063692,170057520,170066937,170060400,170066936,170077728,170069087,170056547,170081264,170080636,170079612,170075993,170065738,170063253,170060282,170062532,170054796,170049216,170063694,170073901,170079815,170061803,170050820,170069754,170053933,170072715,170064234,170067491,170065079,170059708,170080620,170060396,170060635,170076658,170060633,170058647,170064252,170054795,170057818,170075424,170050270,170058422,170079806,170061802,170065463,170086583,170068592,170061270,170052059,170052486,170065737,170058579,170071236,170079805,170086590,170073566,170085004,170063045,170060997,170075429,170073335,170066087,170050819,170058426,170072712,170083423,170075285,170075987,170061801,170080618,170050818,170056700,170053931,170080619,170075985,170066945,170072714,170061269,170064843,170073896,170068668,170066085,170055916,170073898,170050815,170084330,170056550,170058646,170063691,170068667,170064254,170057164,170069752,170057816,170051387,170057517,170073564,170061800,170079195,170052482,170086586,170069444,170069085,170074394,170062538,170077027,170052485,170063044,170080634,170079611,170073565,170048525,170056682,170055895,170064242,170081262,170048523,170064842,170077026,170056701,170073899,170063697,170061799,170075989,170072713,170060391,170061267,170069452,170073694,170073157,170059713,170086592,170076380,170055908,170057814,170086589,170060284,170064232,170061798,170078252,170052488,170050811,170061268,170079187,170067895,170057163,170058430,170069084,170075427,170057513,170064239,170073894,170079810,170050267,170050809,170071235,170060996,170065735,170083724,170058429,170074811,170061277,170075988,170057515,170056540,170077726,170075106,170079814,170055893,170075670,170063690,170063250,170048520,170075425,170086580,170063248,170048522,170069750,170075990,170058645,170085003,170063688,170059709,170075426,170048524,170060399,170069751,170069745,170078798,170060626,170071233,170061796,170083422,170077723,170075669,170076655,170063249,170076381,170060287,170064253,170081261,170063043,170050813,170084717,170072711,170053926,170084844,170071240,170071234,170057812,170050266,170051385,170060283,170060627,170079185,170066932,170071239,170075428,170077727,170079188,170069445,170059083,170064845,170077029,170066935,170051389,170075992,170060628,170053928,170086581,170078671,170078603,170078670,170078604,170061789,170067240,170061790,170066403,170067241,170066398) 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,107373420,828,159032779,3138320,685,3308890,27722768,159032776,690,5177115,167341712,86558852,68181750,158652367,660,797,90722560,674,114793025,576,523,159032782,19373191,155235885,167893195,29833136,28701456,730,575,137006144,806,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'