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-02' and '2025-05-07'
and t.termin_id in (170005167,170023426,170013158,170027900,170005661,170027628,170000218,170006758,170037631,170037702,170021292,170024255,170013154,170037633,170008582,170029558,170013152,170018267,170015738,170012409,170032311,170033716,170022964,170015211,170010759,170027631,170005507,170029559,170008584,170000223,170017526,170012012,170005511,170023425,170007985,170032307,170003465,170000221,170007990,170013153,170023417,170021560,170032965,170023413,170014784,170027632,170026004,170000215,170016848,170010598,170031750,170035734,170022969,170005171,170030488,170013978,170022220,170021291,170025278,170026471,170034452,170001465,170023422,170006753,170018283,170038106,170004137,170020148,170003025,170006764,170017522,170008130,170014350,170022205,170030487,170005161,170022678,170022219,170027894,170010755,170015744,170018278,170018929,170030485,170014783,170037630,170035470,170005512,170013155,170009308,170015215,170014515,170005168,170007662,170016031,170005514,170010594,170016033,170004139,170027635,170007975,170010592,170031748,170024259,170012408,170011666,170010763,170039114,170022682,170024258,170006752,170004630,170025558,170020144,170022208,170019292,170023416,170037226,170027687,170003016,170033718,170033603,170007987,170023835,170005659,170024256,170005760,170037893,170007650,170033713,170011667,170031438,170014344,170025276,170010206,170003462,170036781,169998575,170007663,170026850,170005740,170005162,170004135,170005158,170027899,170031749,170016038,170027629,169998580,170004138,170013964,170000229,170030484,170024561,170022966,170015213,170007642,170027430,170011149,170035731,170005662,170007651,170000212,170006757,170022681,170022210,170007986,170000227,170010596,170012306,170038105,170017898,170017524,170023834,170031878,170010761,170037230,170010762,170005508,170012310,170007982,170016293,170026470,170000214,170012005,170001461,170027895,170031877,170003469,170006759,170026003,170022967,170021294,170028209,170022965,170013151,170031128,170007980,170005746,170035472,170024557,170030489,170033709,170024556,170007658,170037632,170004633,169998573,170011672,170004136,170025556,170005747,169998581,170007974,170012004,170025277,170037892,170031126,170039111,170037227,170020794,170008583,170013965,170013979,170025554,170031396,170005510,170007988,170000216,170009310,170023421,170020143,170024560,170026466,170035475,170024564,170022221,170036784,170011669,170005749,170028206,170030486,170029093,170014516,170022204,170003470,170012002,170030482,170010207,170016288,170005748,170014590,170013975,170025557,170007989,170022202,170034451,170026852,170026006,170014349,170037225,170012011,170016849,170023428,170022212,170003464,170018268,170027431,170010211,170007976,169998574,170008132,170033720,170015214,170026008,170005163,170004631,170013157,170006762,170028208,170015369,170025273,170007641,170005752,170005658,170038108,170025559,170035735,170016294,170027634,169998578,170016847,170024562,170014352,170027633,170032308,170031125,170037234,170031875,170031751,170000232,170016039,170012410,170020147,170000211,170007659,170007971,170008422,170029555,170031747,170010764,170021561,170017895,170010209,170026007,170025555,170020795,170039110,170021295,170002763,170008588,170009309,170027429,170005762,170011156,170023427,170031754,170038103,170025272,170020798,170014785,170008127,170020142,170008585,170002759,170001463,170037228,170009311,170013156,170002757,170012009,170024261,170003463,170016289,170005751,170017894,170011152,170014588,170033721,170029096,170010754,170023414,170019291,170017523,170033702,170023833,170013976,170012010,170038107,170005742,170033715,170027897,170005744,169998579,170029092,170008131,170014351,170005750,170025274,170035474,170011668,170015222,170031397,170039112,170024563,170022683,170023420,170016035,170011147,170010595,170007644,170032306,170007655,170033719,170000231,170026851,170024260,170016034,170006760,170029554,170002762,170003024,170037742,170017281,170010213,170005761,170015372,170029095,170026465,170014505,170001464,170031753,170018281,170005759,170028212,170037231,170008586,170026469,170007984,170013977,170033602,170023424,170033708,170010597,170017525,170018270,170006761,170037232,170031127,170012309,170026467,170000219,170036782,169998577,170018269,170012008,170020797,170008587,170035473,170035733,169998576,170037224,170000228,170025275,170015743,170011146,170011150,170007649,170023423,170028202,170033717,170000230,170032310,170020402,170002761,170014517,170022209,170029551,170003023,170010210,170017280,170016292,170018930,170003020,170016453,170018280,170027630,170012694,170012007,170015371,170033710,170032309,170018277,170029094,170020403,170007979,170016954,170022218,170001466,170014589,170007983,170017899,170023418,170002760,170015742,170035730,170031752,170036783,170005758,170004140,170010208,170007973,170008129,170005160,170019086,170013150,170005745,170031437,170035732,170016291,170015370,170037233,170027688,170005506,170026468,170018289,170014348,170000220,170010593,170006755,170003021,170021557,170026849,170027898,170008420,170029553,170024559,170012308,170008421,170007657,170003022,170021559,170017279,170021290,170037223,170021293,170022203,169998571,170023419,170000213,170034453,170033714,170007981,170003461,170015745,170028203,170022207,170016452,170021558,170022680,170033703,170011673,170016290,170024257,170022206,170026005,170024558,170027428,170015741,170036780,170038547,170006763,170006756,170028205,170008128,170039113,170003468,170039109,170010753,170014587,170032964,170007972,170038104,170016030,170011665,170005743,170028204,170031124,170014346,170029552,170039108,170031876,170026848,170027896,170012307,170007656,170022968,170033712,170037222,170015740,169998572,170010760,170006754,170012003,170011148,170016287,170033711,170022211,170033601,170014345,170034454,170010756,170021555,170007643,170003460,170008126,170010752,170014662,170020141,170026464,170026847,170027427,170003015,170012693,170010212,170021556,170022679,170005757,170014504,170030483,170011151,170023415,170022217,170016029,170015739,170002758,170019293,170007661,170029091,170036779,170003467,170032963,170007640,170013149,170005741,170004632,170016028,170010591,170008125,170018928,170016953,170005159,170024555,170008581,170009305,170037221,170005756,170016846,170010602,170018275,170013148,170012001,170022216,170009307,170006751,170007645,170016032,170028207,170000222,170020796,170015212,170011664,170035471,170010757,170031436,170005660,170001462,170012006,170014347,170017278,170022684,169998737,170013663,170011997,170031013,170011998,170022504,170031014,169998741,170014274,169998730,170019138,170019139,170033548,170030283,170037056,169998738,169998731,169993687,169993686,170033549,170031015,169998740,170022505,169998736,169998735,169998733,170031016,169998739,169998732,170030282,170036980,169998734) 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'