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-09-03' and '2025-09-10'
and t.termin_id in (170850769,170850768,170791895,170603315,170823938,170849027,170827569,170852005,170850810,170879130,170877687,170872894,170874771,170852002,170873698,170824533,170822878,170840365,170879772,170840367,170874707,170825160,170852004,170786962,170792273,170873699,170850437,170850436,170852007,170875603,170802706,170877440,170840368,170850811,170850820,170871198,170850808,170879771,170874706,170603104,170852029,170879770,170869770,170789872,170877475,170879135,170840370,170850821,170852006,170852003,170872895,170840369,170850494,170830070,170879131,170879134,170877474,170872893,170850809,170874889,170850493,170879133,170840366,170870845,170820980,170791231,170802723,170824542,170705614,170879773,170850438,170829119,170804587,170800967,170792301,170802963,170872892,170829857,170872891,170879132,170826116,170840364,170874818,170880380,170874821,170850860,170876249,170862977,170875140,170880378,170876251,170850858,170865529,170869164,170865531,170875747,170863989,170875560,170840272,170863988,170875974,170876248,170868474,170879694,170877996,170865533,170865528,170876252,170880381,170868473,170879695,170865532,170874562,170874820,170880379,170875557,170863986,170826172,170840277,170875556,170875555,170863983,170847485,170865527,170840271,170862974,170877995,170878605,170875973,170850857,170875559,170874565,170875750,170876795,170787160,170877999,170866277,170875749,170863984,170840274,170863985,170840276,170876253,170879696,170877998,170880383,170880382,170875976,170875977,170868472,170875558,170847499,170840275,170875748,170874564,170863987,170874819,170878835,170865530,170876250,170869166,170875141,170874817,170877997,170875975,170862975,170866276,170869165,170874563,170862976,170850859,170840273,170847500,170876247,170817083,170875982,170860049,170844732,170856568,170862758,170853644,170859297,170873865,170864784,170864775,170857252,170875573,170841840,170872999,170854575,170864783,170870059,170857253,170872996,170873004,170873861,170845913,170798559,170847456,170873005,170819917,170853648,170880683,170873860,170800040,170869474,170880684,170868122,170846345,170880686,170869475,170847457,170868124,170863908,170821205,170856119,170853372,170873001,170857658,170871260,170874686,170868128,170877436,170866310,170870063,170868123,170813387,170873452,170875983,170873451,170862195,170880688,170809599,170860693,170869819,170849343,170850278,170801612,170853637,170848579,170875985,170875523,170827014,170845737,170874811,170797291,170856881,170853630,170849333,170876557,170849338,170845740,170877432,170866315,170877583,170876558,170849334,170868349,170856889,170848344,170863218,170849336,170820461,170873448,170864785,170860694,170879982,170799392,170853369,170853631,170872997,170866308,170875984,170800583,170874810,170873011,170874812,170880437,170844734,170845173,170821926,170853634,170849335,170874808,170853370,170875524,170845915,170870061,170853635,170844731,170859121,170842202,170857255,170851268,170864773,170848342,170853641,170851267,170854875,170848578,170848338,170797290,170856574,170862196,170873862,170852196,170856571,170853647,170864791,170864770,170869473,170877579,170846923,170859123,170805284,170859611,170854577,170873002,170843326,170822950,170854876,170845734,170856566,170853642,170808927,170856565,170850281,170869472,170862192,170856575,170875981,170854289,170866314,170849347,170856115,170879557,170847455,170861000,170873443,170873446,170880414,170847459,170856886,170860050,170873000,170856887,170871048,170858142,170852145,170872995,170848337,170853638,170857660,170841850,170845168,170871046,170806605,170791249,170808119,170879558,170856118,170856570,170824253,170824252,170877433,170856567,170853643,170847458,170880417,170859120,170874685,170872994,170848343,170842844,170873854,170859614,170869822,170879983,170856884,170846919,170843325,170854574,170875519,170849339,170803083,170859124,170844012,170856569,170841191,170801638,170816919,170880689,170841852,170842843,170856880,170868394,170878102,170841837,170864777,170842572,170868125,170873851,170798547,170841849,170845166,170875571,170830866,170844736,170856573,170849337,170871045,170869818,170844016,170878100,170873866,170875520,170855294,170873852,170815595,170817388,170873007,170857659,170842839,170801611,170873454,170866321,170841190,170866320,170854291,170873450,170841194,170844735,170864771,170873009,170846920,170873853,170877578,170878099,170863364,170841843,170843324,170869471,170823611,170877431,170862397,170862392,170858438,170855290,170849032,170875522,170845739,170848583,170873855,170872993,170841841,170796097,170874809,170859119,170821778,170842571,170873447,170861001,170843322,170851266,170841188,170866317,170873445,170847461,170862199,170844008,170856114,170860047,170871044,170875986,170812037,170864789,170880435,170870058,170857250,170858137,170873012,170841848,170826088,170876118,170853368,170844015,170853629,170854288,170855288,170859608,170873858,170843323,170845736,170849332,170853632,170876120,170875570,170873444,170845172,170847454,170869816,170868120,170841847,170870064,170856577,170853633,170869476,170856890,170876560,170863914,170873463,170863221,170845738,170873003,170877584,170873462,170842842,170858139,170863909,170856117,170873457,170864788,170873460,170859610,170862393,170846346,170871262,170878103,170853649,170856576,170866311,170859609,170863363,170876564,170857664,170855291,170854294,170874814,170842204,170848585,170814204,170874687,170849346,170859125,170854580,170875575,170864786,170847462,170841842,170879987,170849342,170875980,170875518,170827445,170805797,170855867,170877434,170795080,170810425,170812705,170846344,170857251,170827303,170873010,170873461,170795616,170814581,170871047,170879561,170866313,170812704,170855295,170858435,170849345,170866319,170864778,170844011,170869821,170857254,170856888,170871049,170845169,170857663,170851714,170876123,170859613,170864787,170854293,170873864,170841836,170873449,170855296,170880687,170818796,170848580,170866318,170874813,170849344,170864790,170854579,170875574,170880685,170860051,170873008,170873459,170859300,170810001,170862396,170873863,170808674,170864779,170844010,170857662,170858437,170873458,170873006,170877437,170869815,170879556,170876559,170841189,170846922,170856882,170863219,170863912,170862763,170862194,170844730,170879560,170869820,170877582,170842841,170841839,170876122,170851713,170858138,170868127,170853374,170854292,170842573,170853636,170848584,170866316,170873456,170854578,170877435,170847460,170841838,170879986,170862395,170864772,170855866,170816435,170879985,170864776,170873455,170807514,170876563,170816915,170805294,170868126,170801637,170813859,170798954,170810738,170856572,170826015,170804355,170825299,170800989,170802442,170799649,170814203,170849340,170863911,170862760,170863365,170862200,170797679,170844009,170818572,170845735,170868348,170856885,170819224,170806860,170879559,170814868,170832162,170818797,170877581,170813858,170795083,170796907,170808110,170824481,170880436,170848341,170853373,170878101,170801195,170858436,170857661,170831612,170801636,170793246,170853375,170864774,170859122,170875572,170829965,170873453,170830452,170871261,170821830,170862394,170868121,170825298,170792765,170816027,170845914,170796508,170879984,170854877,170863362,170866309,170852197,170796498,170849030,170842203,170862759,170845167,170860048,170848340,170851712,170800988,170859299,170846924,170854576,170810733,170849031,170842840,170877580,170863910,170862193,170868395,170856883,170856116,170869817,170824480,170880415,170870060,170824251,170853371,170855289,170846925,170853645,170848339,170854290,170873857,170866312,170852144,170859612,170873856,170872998,170798965,170876119,170846921,170853376,170853646,170875521,170798949,170792766,170876121,170841851,170848336,170868347,170864780,170876124,170863913,170863220,170844733,170870062,170880416,170849341,170810259,170873859,170879562,170880682,170871050,170859298,170863217,170825297,170791250,170819928,170825356,170873119,170865283,170873467,170873468,170801028,170824270,170873469,170877387,170865277,170874835,170873120,170869832,170873472,170873116,170873471,170847513,170826121,170865545,170873117,170873466,170865278,170839249,170873470,170873122,170865282,170873118,170847514,170873121,170865280,170874833,170877388,170874834,170865279,170865281) 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'