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-03-17' and '2025-03-19'
and t.termin_id in (169674399,169675052,169664610,169672899,169655017,169658667,169651984,169675038,169663648,169648265,169662864,169668239,169666814,169650052,169660871,169652465,169662887,169630558,169646992,169677425,169661292,169656064,169668228,169671968,169680631,169652967,169651075,169673795,169649688,169669062,169664941,169663355,169656732,169652981,169654673,169664185,169671031,169661568,169672972,169668938,169677426,169654423,169652980,169680974,169661302,169676579,169665884,169664312,169658084,169669395,169671042,169656800,169674804,169665865,169665254,169649696,169653344,169673416,169658091,169677130,169648570,169680825,169674803,169652485,169660523,169658654,169666588,169663356,169672144,169648818,169682320,169640106,169658299,169652133,169667053,169651487,169658312,169666127,169646121,169682316,169658849,169671854,169654019,169653791,169650015,169674057,169679559,169681950,169645324,169630557,169671693,169655995,169656799,169659029,169649151,169658305,169661133,169647291,169645165,169668937,169645356,169674599,169664633,169665434,169674400,169680409,169651081,169655666,169662144,169665866,169648505,169680419,169667937,169662865,169649377,169645093,169662152,169650061,169671337,169647012,169665253,169651493,169665416,169677636,169650679,169651513,169640113,169663142,169666815,169647307,169652484,169676668,169660299,169649363,169663959,169670537,169665864,169665417,169647628,169645746,169664626,169664921,169665657,169677635,169675045,169655652,169650672,169674056,169651480,169654598,169648247,169653784,169681717,169649164,169648839,169673227,169648504,169645092,169662877,169648246,169667936,169663938,169662151,169677131,169681941,169663939,169679228,169651216,169646120,169662389,169681187,169660050,169674600,169662395,169679196,169655018,169664612,169655107,169661314,169648571,169664922,169652118,169663650,169648829,169661569,169682306,169668691,169675061,169660358,169678537,169672977,169660524,169669358,169667469,169650686,169654678,169652066,169672663,169666128,169663960,169650694,169672600,169675241,169648847,169673417,169664190,169648266,169669063,169658078,169653317,169665265,169650442,169666140,169661902,169665658,169666589,169663143,169667054,169671694,169661913,169675865,169672290,169647991,169672145,169659087,169671855,169664942,169662498,169679552,169678505,169649371,169655651,169660870,169645164,169651028,169646989,169664611,169671967,169663649,169653316,169662401,169653333,169680397,169651230,169667468,169661132,169654422,169650441,169647635,169651519,169679190,169661901,169664627,169673312,169659028,169671082,169655106,169665415,169654018,169674055,169653529,169653332,169665883,169651503,169677968,169665252,169653783,169648686,169671030,169658098,169658660,169665435,169673313,169646646,169672289,169664920,169675150,169677969,169655667,169663962,169680632,169673314,169652067,169649165,169675151,169680410,169655653,169665257,169659091,169666141,169640114,169653530,169682307,169662867,169667939,169653792,169671083,169666129,169667470,169647001,169672292,169665869,169663963,169665420,169652150,169662390,169658668,169668692,169650682,169671780,169674805,169675039,169659326,169666130,169672147,169670976,169675046,169661903,169660872,169661570,169660873,169648249,169652466,169647993,169654424,169662145,169663651,169665255,169677962,169668229,169651217,169658092,169658099,169656733,169648573,169670538,169661571,169668940,169648840,169667471,169651524,169640107,169656065,169660021,169671696,169646123,169655996,169671032,169659088,169652987,169663940,169648572,169672146,169662866,169655109,169667056,169662402,169677963,169647636,169661315,169669065,169675866,169663961,169665436,169663363,169651481,169664943,169648248,169659736,169658655,169666590,169651504,169658085,169664197,169665886,169677638,169660526,169680420,169645747,169652982,169656802,169650063,169652134,169667055,169651221,169655020,169654021,169655654,169658079,169663358,169671695,169679229,169662154,169673233,169666817,169679560,169662396,169661303,169676669,169665437,169660359,169646647,169630559,169649689,169655019,169666816,169649364,169652487,169645095,169664628,169652486,169665419,169677428,169664191,169651231,169664923,169675053,169654675,169662878,169650065,169648635,169653318,169677427,169649373,169680975,169650443,169674402,169673797,169674060,169645357,169665659,169674602,169652968,169671338,169671857,169672983,169658306,169645325,169680637,169663652,169677637,169671969,169663145,169650673,169648267,169674601,169646990,169651488,169649691,169681690,169663941,169677707,169651494,169674806,169648506,169681951,169682317,169654661,169673234,169664641,169679197,169648830,169661304,169657694,169678538,169647629,169677133,169666591,169659537,169672662,169673419,169661135,169681188,169653345,169678506,169674059,169645166,169651068,169663653,169650444,169665266,169663357,169661904,169680826,169671970,169665660,169668230,169661914,169664944,169673425,169645094,169649152,169675062,169647308,169658315,169667065,169676580,169679553,169673796,169648513,169674401,169654663,169677132,169651082,169682321,169673418,169659090,169671856,169667938,169651985,169650680,169653335,169680398,169672291,169647992,169648819,169672973,169661134,169646122,169665868,169675237,169679191,169671033,169663144,169662153,169664613,169665256,169681942,169654020,169653334,169674058,169665885,169665418,169665867,169653785,169669064,169658661,169656801,169648268,169664181,169653319,169647292,169668939,169660525,169660300,169672904,169663668,169669396,169668103,169655108,169664924,169681189,169681943,169667472,169648514,169681952,169655668,169652135,169640115,169664945,169682322,169674061,169664642,169652111,169655656,169664615,169680411,169680421,169651232,169675238,169671398,169672974,169672601,169679198,169655022,169662397,169645326,169645169,169671698,169646124,169654674,169656804,169674062,169654679,169664614,169672293,169653336,169653793,169651502,169666593,169672148,169671603,169667940,169668231,169658669,169650445,169650066,169658100,169660527,169674808,169673228,169662391,169662869,169651495,169665887,169664925,169651069,169649354,169653787,169677135,169659327,169650687,169647002,169661137,169652969,169682318,169665259,169671697,169677429,169648820,169671084,169664926,169648574,169649372,169668942,169677430,169658656,169662156,169647640,169680827,169662146,169674807,169671035,169661905,169630562,169668240,169680976,169654023,169663943,169675152,169660875,169645097,169646991,169664198,169658307,169654599,169645167,169654022,169652467,169649690,169663965,169652488,169669067,169648841,169682308,169677965,169671034,169663654,169677640,169671781,169651482,169675868,169653531,169672900,169654426,169661916,169653786,169654425,169659737,169660022,169655997,169656803,169650016,169674404,169666819,169673315,169656066,169645358,169663942,169651083,169662868,169648270,169679561,169652489,169658662,169651514,169679554,169651520,169680399,169663944,169663656,169658300,169671469,169665423,169660528,169630561,169670539,169664192,169677639,169672666,169656734,169673421,169667058,169662155,169640108,169648687,169661573,169658844,169671339,169674604,169647315,169658073,169648250,169665421,169666132,169666131,169664643,169658086,169648575,169665260,169655110,169679230,169671859,169675040,169667941,169674063,169648251,169669359,169664182,169666818,169650681,169677641,169653337,169667473,169664616,169651222,169668104,169647013,169664927,169649697,169652984,169658313,169672978,169651233,169661293,169657695,169651489,169660360,169678539,169672294,169665439,169665662,169668693,169659538,169663360,169648848,169671403,169653346,169669161,169659031,169649166,169646125,169671036,169665267,169666142,169675054,169665872,169650446,169648507,169646648,169671972,169663147,169662879,169647995,169675063,169661915,169672149,169659089,169647644,169647309,169664946,169680633,169676581,169663146,169673798,169645748,169674403,169678507,169674603,169655021,169650064,169655655,169661572,169660874,169677134,169673420,169671971,169663655,169671858,169653320,169661305,169668941,169676670,169645096,169649153,169665438,169669066,169662403,169647293,169661136,169665871,169667057,169651986,169647637,169665422,169645168,169679192,169663964,169663359,169665661,169675047,169666592,169650674,169659030,169665870,169665258,169652983,169648831,169653321,169658093,169658316,169669397,169648269,169647994,169652068,169665888,169675867,169677964,169662888,169682505,169662555,169655421,169657764,169653486,169652011,169658363,169664034,169657770,169664992,169654280,169655259,169653128,169674842,169652701,169678204,169653590,169664348,169676258,169651930,169658356,169658364,169652707,169653487,169664349,169682506,169662556,169657759,169655422,169655260,169651931,169653123,169654281,169652012,169658357,169664993,169674843,169678205,169653591,169676259,169657771,169674844,169659642,169653592,169653488,169664350,169682507,169652013,169654282,169655261,169655423,169662557,169676260,169678206,169658365,169657758,169651932,169664994,169657765,169653129,169658358,169657772,169652702,169658035,169649389,169667775,169660314,169675228,169652295,169653292,169649709,169647038,169661160,169666628,169651555,169646105,169650413,169663635,169652645,169667776,169680992,169648218,169674273,169674725,169663634,169675007,169658624,169648591,169652447,169654005,169674274,169647657,169652646,169669612,169671159,169666854,169662824,169675845,169669279,169651544,169664901,169665227,169678349,169679740,169671358,169645365,169672040,169662836,169659994,169680374,169664579,169677570,169660779,169672883,169648484,169647325,169646635,169664174,169650412,169655303,169672335,169663456,169665940,169665226,169650701,169674308,169674533,169662380,169674711,169669123,169665948,169664309,169647651,169654964,169654176,169657634,169651093,169676641,169675536,169662494,169673060,169655184,169663128,169645868,169661159,169677569,169666151,169653753,169670591,169674534,169664168,169658619,169650081,169660233,169681531,169674724,169659044,169667985,169652925,169682260,169645874,169648651,169682264,169664902,169679543,169650088,169664578,169670750,169674446,169647031,169647972,169679108,169672549,169649186,169654519,169674309,169662128,169677717,169667184,169681650,169657213,169663129,169654963,169674445,169658048,169673502,169654004,169655624,169675846,169670388,169681651,169669735,169649983,169670592,169655185,169655977,169669466,169653428,169669526,169655919,169680702,169658042,169646104,169646634,169669527,169651240,169658614,169670566,169649715,169648485,169673503,169647332,169657212,169667986,169669611,169658285,169667788,169653427,169673102,169668719,169657633,169681305,169652448,169670853,169676748,169663340,169667500,169654518,169648861,169675014,169650708,169645315,169656722,169654505,169652926,169662129,169680815,169655500,169648652,169676749,169661380,169651249,169667501,169666855,169665492,169672336,169677226,169668474,169669280,169656936,169661625,169681313,169666629,169660387,169672747,169649180,169660614,169679534,169652127,169660922,169679089,169669814,169677718,169666160,169648592,169678348,169668856,169655625,169659045,169677309,169653293,169671673,169676290,169661886,169651100,169663462,169667185,169651012,169679252,169647663,169668271,169662373,169678977,169658839,169654687,169654074,169676555,169677225,169681749,169655499,169660778,169668848,169668270,169671672,169673101,169647023,169677899,169669457,169649395,169661379,169668718,169652103,169652941,169672548,169665491,169658280,169661624,169680367,169648854,169663339,169650602,169663917,169671158,169658607,169649170,169673053,169649995,169664157,169673714,169671353,169648227,169660613,169680986,169658291,169673715,169681785,169654698,169653752,169680701,169663918,169654402,169678269,169654075,169650581,169651532,169657614,169652928,169663457,169663342,169680375,169672888,169654966,169662825,169652216,169679535,169650415,169674276,169659431,169676556,169680703,169662131,169666857,169680993,169668721,169645366,169663131,169648862,169647973,169669372,169659610,169677909,169682303,169660923,169663636,169649986,169673105,169672743,169652296,169662130,169648228,169652927,169656937,169646106,169661627,169673505,169666154,169675848,169646107,169661887,169663463,169662374,169680381,169658036,169674726,169673702,169647340,169670368,169651241,169652942,169646636,169663920,169645672,169677572,169667778,169665942,169668850,169648870,169672737,169647974,169648486,169645869,169670608,169659047,169670582,169657214,169670604,169657685,169682265,169676750,169664580,169662381,169650582,169661162,169650702,169666631,169663919,169654006,169673054,169667789,169667777,169680987,169672042,169672338,169664175,169655920,169653430,169661626,169675847,169648700,169655626,169655502,169661381,169666856,169678270,169668720,169658292,169653754,169676643,169681306,169645316,169669736,169648593,169668849,169660388,169652115,169669458,169677571,169679090,169677311,169653755,169655186,169671675,169678351,169654067,169651101,169679741,169671161,169660780,169663341,169660024,169648594,169673716,169681750,169654965,169647658,169681310,169655501,169668273,169678978,169650082,169659764,169646637,169670854,169666152,169651553,169647333,169674275,169651561,169672879,169676642,169664158,169665228,169667502,169649716,169658043,169652648,169679253,169673504,169655978,169657215,169665941,169661382,169671160,169672337,169648219,169671766,169667187,169657686,169662837,169651545,169674535,169650709,169654404,169660615,169647043,169651094,169647024,169681652,169674712,169680816,169680708,169648699,169664581,169669613,169658620,169674536,169670567,169649997,169670593,169669614,169658615,169660316,169649383,169669600,169677228,169648487,169654690,169650715,169682261,169665494,169649181,169660616,169667987,169664904,169667503,169649390,169665229,169673717,169652450,169674310,169653295,169647326,169675015,169676291,169660781,169675537,169651533,169673061,169657613,169647027,169651246,169658840,169681501,169679544,169654066,169677227,169656723,169649710,169672041,169675229,169660315,169653429,169668272,169671674,169666630,169659046,169677310,169663130,169654403,169659609,169664903,169677719,169654694,169661385,169678350,169669281,169675008,169658049,169652449,169658281,169650414,169680368,169665493,169661161,169650077,169654520,169668470,169666153,169670751,169674447,169649171,169658608,169667186,169679109,169673859,169649996,169671354,169653294,169648858,169652647,169663450,169658625,169675470,169654177,169645671,169674311,169645875,169674727,169647652,169674448,169655627,169674277,169647975,169655629,169682262,169652635,169678353,169658616,169674537,169650416,169667780,169654699,169677910,169663132,169675009,169677573,169654967,169648596,169648653,169673506,169654686,169655187,169680369,169665496,169660618,169657216,169650603,169660389,169652104,169679545,169653296,169677229,169680994,169670584,169669216,169677735,169661384,169666858,169670389,169649711,169665230,169665495,169660924,169675016,169671452,169662838,169681503,169669529,169646639,169666633,169681674,169656938,169652452,169668471,169652451,169659052,169671676,169671447,169658841,169676644,169673103,169648654,169649998,169669215,169668274,169659432,169668852,169665231,169650703,169647659,169674450,169648855,169666632,169654406,169669467,169678979,169674313,169654069,169654068,169675538,169663344,169675230,169659612,169647334,169661163,169673848,169655979,169677911,169649999,169652297,169658293,169666859,169667505,169663638,169673860,169672045,169677720,169662826,169675543,169649175,169653756,169655504,169656725,169663343,169681502,169649396,169669616,169661164,169669282,169647327,169667189,169649384,169660783,169658037,169645870,169645317,169647653,169657616,169674728,169677834,169662132,169669737,169647039,169672744,169651546,169649717,169663464,169652154,169655921,169667504,169645876,169647976,169667188,169674713,169673298,169673719,169664905,169668275,169661383,169680704,169662375,169661629,169670752,169659997,169653431,169663458,169667790,169665497,169679750,169672339,169679254,169660617,169672550,169671677,169656724,169674449,169658286,169651095,169654405,169664906,169669815,169672738,169665949,169680817,169653432,169645367,169661888,169669528,169669283,169663637,169681507,169674312,169657217,169658050,169654007,169670470,169672340,169669615,169677574,169650084,169658626,169676751,169654968,169666155,169648595,169677230,169658621,169652930,169671162,169671383,169664176,169674729,169655304,169651537,169648488,169651102,169681508,169666161,169652944,169649182,169679536,169667988,169649391,169646109,169680376,169650710,169673104,169672884,169672551,169669460,169675850,169678271,169653297,169663922,169677313,169647032,169650417,169665943,169659765,169662133,169670855,169648863,169676292,169664583,169673062,169657688,169675484,169663133,169651247,169648220,169671767,169650076,169662382,169679064,169651013,169664169,169646638,169655503,169668851,169657687,169658044,169681673,169660782,169647025,169659611,169677312,169668722,169678352,169681751,169657615,169652943,169675849,169648543,169655628,169654521,169646108,169661628,169663921,169682266,169667779,169658609,169673055,169651242,169681312,169670583,169671355,169680988,169664159,169648229,169652649,169673703,169663451,169652929,169654178,169664582,169650624,169653757,169674538,169658287,169673507,169673718,169652257,169675773,169674494,169679059,169676699,169670485,169673833,169674777,169681528,169654565,169652265,169681180,169677785,169657637,169670600,169648619,169673760,169660413,169676043,169665906,169662756,169657959,169677142,169657966,169665905,169646615,169663597,169659841,169674583,169672829,169681565,169640171,169657952,169654133,169658549,169673834,169660414,169646614,169670213,169673761,169656071,169674033,169648473,169652874,169654344,169673395,169665167,169669259,169676883,169663598,169582490,169654623,169671281,169655312,169656393,169674493,169648536,169640164,169670223,169665166,169664858,169680963,169668801,169664519,169681473,169678316,169664520,169668793,169663424,169668134,169654831,169676588,169654482,169673835,169681855,169649956,169658555,169678955,169676365,169652226,169660415,169679663,169676371,169672834,169663432,169674584,169682289,169654226,169653520,169677339,169669260,169654345,169673396,169680607,169679261,169640265,169682152,169667021,169678324,169667020,169682288,169654825,169648465,169675897,169662755,169652873,169654629,169664857,169654132,169680956,169674776,169649949,169645735,169668133,169648620,169669321,169676884,169676886,169674495,169654832,169682149,169640172,169669322,169654125,169673769,169677340,169675646,169652324,169673397,169640266,169665908,169670601,169654662,169658550,169673762,169660416,169664521,169664860,169673836,169670218,169674023,169646616,169652876,169652875,169679262,169681566,169656378,169663599,169663425,169676885,169674585,169657960,169681865,169673398,169667022,169671282,169677341,169660453,169652266,169654483,169657953,169648673,169648466,169645773,169679060,169654126,169657967,169582470,169654826,169659962,169665907,169665168,169678317,169648474,169664522,169681181,169670224,169676366,169664859,169668135,169654358,169658556,169645736,169652258,169648674,169677786,169672830,169640165,169682291,169662757,169674778,169654630,169679669,169654220,169669262,169675774,169654566,169657511,169665169,169678956,169672839,169668794,169662758,169646617,169677143,169654227,169674586,169677342,169654359,169674496,169667023,169680608,169680964,169676589,169649951,169676690,169663427,169673837,169676044,169675855,169653521,169654624,169669261,169668141,169674035,169680957,169649950,169678318,169656072,169682290,169681856,169658551,169663426,169681857,169652877,169673399,169667024,169665170,169652259,169640166,169673839,169671309,169674498,169678319,169654631,169674588,169674587,169673400,169649952,169668136,169654128,169654484,169640267,169652267,169670602,169682293,169681568,169648622,169646619,169672835,169677144,169679720,169679263,169673840,169657968,169678320,169668795,169645863,169676045,169677343,169679073,169673763,169676590,169654827,169648537,169678945,169659837,169655313,169665910,169582491,169674037,169676700,169654625,169677344,169677789,169681182,169657961,169649953,169673764,169669263,169657512,169664862,169656039,169664861,169664523,169676367,169656394,169681861,169675898,169665909,169680958,169652227,169680609,169662759,169663433,169653522,169657969,169675775,169668796,169680965,169660418,169670219,169654833,169669264,169662760,169677345,169675647,169664524,169654347,169652878,169667025,169681474,169682292,169676887,169660417,169646618,169654221,169648621,169674779,169663600,169654346,169658557,169670486,169648475,169670214,169654127,169657954,169673838,169656073,169645737,169681567,169674497,169682153,169654567,169662615,169654057,169678690,169668167,169672246,169681030,169679214,169656106,169654101,169657580,169673937,169654303,169673691,169640274,169674520,169657829,169670461,169653619,169650814,169666795,169666569,169641047,169647489,169654872,169676068,169673938,169638989,169678671,169654304,169674521,169662621,169657830,169681443,169672714,169537090,169653620,169638990,169668779,169668163,169654053,169654107,169678672,169548518,169638991,169676908,169657831,169673692,169673939,169655367,169656425,169681998,169657402,169674522,169654054,169656953,169654305,169653621,169650175,169679215,169641056,169662616,169659615,169675476,169668164,169671375,169654108,169657182,169680718,169645374,169645403,169670356,169656419,169679572,169670466,169679573,169645404,169645375,169645765,169670357,169645766,169679574,169645376,169657183,169645405,169669908,169678243,169629727,169680854,169655959,169680855,169677586,169677730,169677587,169656138,169677588,169677731,169655962,169645430,169658705,169658122,169655928,169677668,169645431,169647607,169658127,169655929,169658706,169658128,169655930,169679577,169658707,169645432,169680932,169673079,169681406,169478788,169673083,169673080,169478789,169658438,169658439,169658440,169665916,169665675,169665448,169666209,169429401,169640958) 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'