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-01-04' and '2025-01-08'
and t.termin_id in (169127054,169145865,169127055,169147425,169144909,169150798,169091438,169134676,169149337,169146465,169138836,169135686,169145536,169113981,169133184,169115019,169112000,169136208,169140498,169127533,169067415,169142219,169150855,169132351,169141949,169127029,169114813,169150771,169148000,169118829,169147997,169129953,169140049,169142631,169123402,169123149,169126997,169123145,169128479,169148220,169128264,169130110,169141950,169140047,169133195,169141095,169135362,169134680,169149012,169148642,169113651,169112008,169137646,169137094,169152034,169119205,169123403,169119196,169118833,169145956,169127539,169143569,169149346,169091433,169136527,169144069,169111534,169118694,169067419,169150776,169112427,169146466,169150859,169134683,169137652,169114819,169139619,169133792,169140058,169120206,169136209,169144612,169114329,169135925,169107101,169134891,169151777,169148494,169127218,169129809,169151780,169111992,169114583,169148639,169133204,169145484,169132137,169129840,169137312,169149588,169149886,169141096,169142632,169144609,169141808,169137304,169139318,169136827,169133201,169128201,169141258,169135366,169131252,169140499,169128168,169113015,169112019,169150870,169147056,169111300,169107102,169133597,169135695,169115041,169119195,169119194,169131449,169141941,169136201,169139309,169134682,169118693,169130474,169131571,169091426,169111527,169113297,169113969,169143740,169144611,169140508,169149355,169128923,169120170,169150775,169143564,169149005,169149011,169128478,169131251,169147426,169134901,169140292,169147636,169133203,169141272,169123154,169111304,169149579,169144910,169127734,169146730,169148634,169136526,169118832,169137729,169148229,169149014,169151600,169125865,169127538,169132349,169151367,169142630,169148644,169111998,169151763,169147045,169148219,169148628,169134887,169132348,169136525,169136535,169119193,169123401,169126646,169152033,169119204,169146524,169113644,169123147,169138570,169135698,169127537,169145966,169134681,169151605,169149354,169127027,169130473,169135923,169111986,169151380,169148495,169139624,169113971,169118831,169112426,169138837,169067417,169091432,169113631,169144610,169143281,169144272,169111528,169129811,169137303,169151776,169114582,169131576,169120380,169132347,169120661,169111317,169147638,169146729,169139317,169143739,169124222,169128922,169140507,169133202,169151186,169128200,169113273,169149891,169141806,169128263,169137650,169140291,169135364,169131250,169140497,169139617,169141266,169136826,169150865,169148650,169107100,169133596,169113004,169142228,169112726,169136524,169128483,169118445,169119192,169137649,169113272,169130472,169135936,169127221,169149344,169120169,169141093,169112728,169141947,169147414,169132346,169133545,169140055,169128921,169148635,169143749,169129978,169138561,169137092,169147413,169143562,169131249,169127026,169091425,169134890,169111526,169145662,169130108,169139315,169123157,169131993,169115025,169149013,169107099,169141256,169114818,169111985,169149587,169139616,169144908,169135363,169111999,169136206,169145959,169123396,169132785,169136825,169148218,169136521,169146728,169151373,169136523,169151599,169135924,169150773,169119191,169125863,169127536,169067532,169151185,169145972,169133796,169147043,169150866,169148638,169143557,169149343,169148627,169148217,169148643,169115044,169112435,169148640,169112006,169119203,169113649,169126645,169123399,169119190,169152032,169136824,169145955,169135694,169127544,169126999,169123146,169138560,169118444,169067531,169143561,169149342,169091431,169118691,169115034,169113630,169124217,169136522,169136205,169143279,169113986,169114327,169148493,169133777,169144608,169120204,169133200,169134889,169145314,169143748,169147989,169139615,169120379,169111316,169114581,169147652,169128920,169136534,169112425,169141946,169132784,169151774,169149885,169149586,169142628,169148216,169141092,169140054,169130013,169141804,169131248,169149004,169141254,169131452,169137733,169147042,169113305,169137301,169112018,169150864,169151613,169107098,169128262,169128476,169113003,169140495,169127220,169134678,169113013,169119189,169124213,169113967,169143568,169114587,169130470,169137647,169131569,169067530,169144607,169118690,169132355,169146840,169131247,169141945,169149353,169142627,169141091,169137090,169141803,169128919,169138569,169143738,169151768,169140494,169147054,169111525,169151211,169133199,169128475,169147424,169134899,169143560,169115024,169131992,169124221,169107097,169141265,169111302,169111980,169139614,169144906,169136204,169127732,169112434,169148633,169142225,169113643,169151372,169136823,169132792,169147651,169136822,169148227,169150873,169151598,169136819,169132782,169135932,169127543,169132354,169151365,169145971,169141253,169147041,169138559,169133788,169149341,169148215,169135934,169150806,169146832,169146521,169150851,169146831,169145537,169111993,169136520,169126644,169136821,169112440,169149010,169140493,169135919,169131246,169139613,169142224,169146520,169119187,169152031,169123397,169111055,169149352,169127542,169145965,169134811,169144606,169118689,169120203,169137089,169136203,169111984,169143277,169151183,169114812,169148491,169111532,169136533,169141090,169142626,169127731,169131450,169112424,169146715,169134888,169114580,169111315,169130469,169112001,169132342,169135935,169147423,169143737,169113277,169149576,169139311,169141943,169137300,169149003,169148226,169140287,169141264,169135693,169128474,169137310,169137725,169147053,169113304,169114805,169112742,169113012,169128926,169133601,169129836,169128261,169140492,169139612,169135933,169149872,169143559,169151212,169113288,169138844,169144605,169135917,169124212,169118442,169130468,169129954,169149340,169141801,169148490,169151767,169120167,169141089,169142625,169150869,169114322,169113287,169136820,169111524,169141942,169131244,169132343,169131991,169143558,169115023,169134898,169140491,169126996,169133197,169143747,169138558,169137088,169113966,169113295,169140286,169130105,169147988,169147411,169137724,169148214,169136202,169136519,169140050,169111979,169107095,169149585,169123153,169112433,169147650,169127722,169142222,169118826,169151596,169145970,169128925,169120306,169128473,169125860,169150833,169123405,169141251,169151364,169133196,169147039,169147987,169149871,169138557,169148213,169151241,169146725,169146519,169148625,169146829,169151760,169144064,169125859,169137298,169135930,169112725,169123394,169113648,169135916,169140490,169112738,169112004,169148003,169111536,169149009,169112439,169120202,169143736,169131990,169147649,169138556,169147052,169113974,169151384,169151770,169145534,169132795,169151608,169127721,169131451,169127733,169150867,169130251,169139610,169111983,169144903,169142221,169126643,169123395,169152030,169119184,169112732,169135692,169127534,169111054,169120658,169138843,169123144,169151377,169126995,169118441,169131572,169128472,169114804,169137722,169148225,169115032,169135915,169111531,169148489,169113628,169131448,169151603,169131989,169150772,169114579,169130467,169131566,169132341,169138555,169113276,169128918,169149584,169132781,169137644,169140285,169107094,169128198,169139308,169142624,169141088,169141800,169127720,169131242,169136532,169141250,169133595,169113001,169136200,169151773,169143746,169137723,169142220,169135931,169143274,169131988,169143555,169115040,169134675,169130466,169112445,169119183,169114591,169144603,169118686,169113286,169138835,169131241,169128197,169146838,169132340,169137086,169128917,169128471,169133194,169091422,169111523,169139307,169151766,169151195,169148488,169141799,169147051,169143735,169113965,169113294,169149878,169141263,169134897,169140488,169115022,169148631,169136817,169144901,169113641,169138567,169145961,169149575,169151370,169127730,169133640,169112432,169135358,169146723,169118824,169151595,169067413,169119182,169132339,169145969,169148211,169123404,169151362,169133193,169111996,169149870,169091418,169140052,169133794,169148624,169146826,169151759,169112007,169138562,169144911,169123148,169138847,169118448,169111057,169120662,169144065,169146830,169141252,169131567,169128199,169132136,169144066,169145664,169130109,169138838,169113289,169142230,169125861,169091430,169141944,169139312,169130107,169145660,169112727,169123398,169131570,169137091,169134679,169151184,169125869,169111056,169146523,169142227,169141094,169137093,169113303,169141805,169115035,169139313,169132350,169149879,169111308,169127724,169112011,169137643,169130471,169144118,169137302,169140288,169150857,169148641,169127222,169133787,169112021,169151220,169118687,169149338,169136199,169140284,169130104,169131575,169151604,169129956,169140051,169107093,169119186,169140293,169148651,169139618,169147654,169141954,169135920,169144067,169151761,169140505,169132344,169139611,169111307,169145313,169125864,169144068,169149578,169112423,169148212,169113011,169145658,169147990,169114325,169140489,169113982,169148649,169144063,169150850,169145535,169111303,169151775,169149873,169136536,169146833,169114817,169133790,169120201,169124211,169137299,169126998,169111305,169126648,169133641,169120166,169137730,169135914,169144904,169151371,169111978,169139316,169148647,169151196,169112447,169141948,169138846,169148497,169113968,169120660,169147421,169148496,169148648,169115026,169151597,169136517,169113629,169119202,169147044,169151363,169133797,169140504,169147420,169135359,169137726,169113980,169123156,169133198,169143280,169151390,169148626,169151381,169135360,169111997,169135937,169138845,169139608,169127535,169131453,169151769,169149002,169124218,169091437,169132356,169119201,169144907,169120305,169150849,169091429,169136518,169067414,169111991,169145533,169067412,169136490,169111301,169132794,169144905,169131568,169135361,169118830,169120307,169139609,169142229,169113645,169123400,169147998,169147410,169150862,169150868,169111533,169146839,169135918,169145962,169113281,169149339,169118825,169145521,169145348,169150797,169140506,169147991,169150863,169143750,169067418,169120659,169133602,169140057,169147055,169113014,169139310,169112436,169148632,169120205,169143275,169124216,169131245,169137095,169146716,169118440,169148228,169118446,169143565,169150858,169112736,169151606,169125866,169115036,169113632,169130475,169120381,169147655,169128924,169113279,169131454,169113016,169127725,169149006,169113970,169114808,169147046,169114589,169118447,169137651,169112729,169133546,169141807,169131995,169141267,169149880,169127028,169138571,169143282,169135365,169145963,169151374,169135687,169145973,169141257,169149345,169113650,169112735,169140064,169143563,169140056,169118692,169136207,169114328,169145315,169134900,169131994,169147999,169133799,169132793,169137311,169137728,169114807,169114588,169135922,169142629,169140290,169149874,169150774,169140496,169150874,169147653,169137727,169128477,169132345,169151366,169141255,169151762,169150856,169146522,169112734,169151379,169151784,169137648,169130106,169147412,169146727,169113278,169127723,169140289,169139314,169135921,169129810,169114806,169142226,169151079,169112446,169133544,169120168,169148492,169113296,169143278,169129955,169091424,169140053,169149577,169146726,169118828,169119188,169125862,169091419,169112005,169115043,169139623,169112733,169130265,169127219,169138568,169118827,169151378,169118443,169114326,169115033,169147637,169149890,169132791,169141802,169107096,169113002,169142223,169067416,169134677,169114592,169147040,169143276,169091423,169137645,169118688,169132783,169113642,169145958,169119185,169133795,169126647,169147422,169146828,169150854,169113006,169131243,169145954,169130247,169146827,169144604,169144902,169143556,169147986,169111314,169146724,169147648,169151612,169149884,169151389,169140048,169141940,169137087,169128260,169137309,169147038,169136818,169114321,169149351,169141939,169142623,169141087,169129952,169147996,169123152,169132790,169147647,169120304,169125858,169147037,169147985) 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,167893195,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'