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 (169143110,169125087,169123490,169124092,169152276,169125522,169151999,169125921,169118320,169143391,169133148,169124098,169134056,169125523,169121171,169067483,169125057,169118346,169131502,169146545,169111078,169122981,169125930,169123681,169134153,169128577,169114345,169150515,169133105,169125561,169120352,169139936,169122305,169128404,169131819,169146452,169150438,169126634,169125928,169135347,169127456,169123947,169151204,169121162,169138518,169132696,169122965,169126271,169143390,169131818,169127455,169127607,169122634,169132330,169120715,169135663,169077644,169151995,169130737,169067482,169125056,169146368,169122980,169146564,169130414,169138521,169143111,169124097,169134155,169122573,169131086,169128576,169114344,169136329,169144781,169122303,169123951,169135342,169131501,169152277,169143389,169129465,169135662,169126487,169126640,169127454,169120714,169150531,169134080,169121161,169131478,169132709,169123948,169136481,169150435,169133147,169122964,169122302,169127599,169143388,169127453,169127605,169132329,169122633,169111604,169127604,169121169,169132450,169122979,169138510,169143115,169129470,169118318,169130413,169123679,169114355,169122572,169122301,169128575,169136321,169126274,169120350,169131081,169143396,169133146,169117892,169120713,169128399,169127452,169124101,169135346,169151203,169121160,169138516,169122954,169143109,169135661,169127451,169135660,169135343,169127603,169115558,169132328,169122632,169140897,169121168,169151993,169123801,169127602,169129462,169138520,169111079,169118317,169125054,169146544,169132719,169146367,169122978,169143108,169130426,169128574,169122299,169123678,169124096,169115557,169150673,169120349,169126273,169126633,169131846,169135350,169136328,169122953,169132542,169127450,169138333,169114341,169132449,169138515,169130736,169117891,169121159,169134158,169150530,169151202,169135344,169143386,169133103,169133145,169143107,169122298,169119701,169127449,169127601,169122631,169126485,169129464,169122991,169126638,169140896,169143385,169067480,169150434,169144783,169123802,169151994,169125053,169127600,169151201,169121167,169117890,169123799,169146351,169122977,169125927,169124095,169132706,169129469,169128573,169118316,169138519,169111074,169123677,169122570,169135349,169120348,169144778,169136327,169143384,169128398,169132541,169137779,169150672,169115556,169121158,169134157,169077638,169114352,169134054,169150514,169130735,169138514,169123949,169143105,169122952,169121170,169133144,169122296,169120347,169143383,169127447,169135658,169132326,169122630,169140895,169120712,169131088,169125929,169125525,169138316,169150436,169146563,169133104,169118319,169127606,169125926,169122304,169126272,169132564,169132707,169123800,169150691,169117893,169151992,169138332,169132448,169143106,169122297,169126246,169143112,169144782,169137782,169111603,169131087,169132327,169126484,169152278,169132708,169077645,169122571,169134055,169138334,169136322,169122574,169132452,169067544,169133102,169125086,169118345,169150675,169146453,169111070,169131500,169150437,169120711,169150667,169129466,169128403,169138517,169126247,169126248,169111605,169151996,169146352,169138511,169123950,169140898,169151274,169132451,169125529,169123680,169120351,169128400,169125528,169125055,169125527,169132563,169144780,169126486,169111071,169150674,169137781,169126639,169134159,169125526,169143387,169122300,169144779,169114349,169067481,169137780,169134079,169125524,169146468,169130422,169131477,169135659,169111602,169131476,169146562,169130425,169114348,169131817,169127448,169126637,169111077,169152275) 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'