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 '2026-04-20' and '2026-04-22'
and t.termin_id in (172331421,172302917,172306468,172315773,172305483,172304443,172328358,172321602,172309583,172329055,172305486,172322107,172334416,172306849,172322110,172312686,172304437,172334414,172313715,172305059,172308325,172320668,172326042,172317369,172320669,172319020,172302919,172327336,172314212,172309804,172321275,172329335,172328568,172303376,172319845,172305472,172326241,172327899,172305467,172305481,172319133,172303687,172318736,172324374,172320286,172306441,172322582,172317379,172312689,172322984,172303369,172328200,172304452,172337875,172315091,172311118,172323117,172305853,172306841,172321273,172311574,172345732,172302579,172334413,172316764,172303688,172319851,172316307,172328543,172323123,172303377,172316775,172317366,172317378,172317846,172302578,172303689,172327898,172314213,172319843,172328359,172321606,172319844,172321270,172323603,172320665,172323604,172313716,172309579,172335671,172317867,172317847,172317849,172317006,172305863,172317009,172317850,172305480,172328403,172302920,172322108,172316766,172307871,172307041,172329057,172315331,172318523,172317005,172305051,172319493,172313713,172303368,172317365,172308669,172317859,172323605,172328556,172318527,172320442,172320288,172307858,172314330,172309163,172314821,172319842,172316068,172321274,172304080,172303375,172328564,172309594,172319016,172317368,172307505,172324370,172326180,172302916,172319502,172334415,172328199,172337878,172319840,172308668,172311575,172319489,172316067,172306848,172316306,172318524,172318525,172312379,172313458,172316069,172318737,172326041,172306850,172320443,172319019,172322121,172319017,172309596,172328562,172320289,172304056,172311792,172312685,172327156,172322122,172322105,172306443,172345731,172311576,172307845,172305843,172307851,172329336,172331423,172326240,172305838,172308670,172317380,172317367,172317364,172307856,172322585,172318735,172309169,172304070,172328555,172324371,172319134,172309180,172302534,172307850,172305058,172316308,172308671,172335672,172304438,172323614,172329337,172313717,172319492,172324373,172328453,172328544,172319027,172317007,172313714,172305858,172309183,172312688,172303370,172309595,172304451,172324376,172324372,172327337,172311116,172309182,172307503,172308308,172322106,172327157,172309164,172318733,172307049,172302560,172331422,172345730,172317845,172326179,172327158,172318526,172302562,172314331,172331424,172322596,172322991,172309170,172319021,172314081,172312381,172302536,172305482,172323118,172314823,172326514,172305053,172306444,172327338,172305060,172316765,172334418,172309597,172322109,172334417,172315333,172315087,172321605,172318734,172304081,172307857,172318732,172312380,172328557,172314080,172322584,172306463,172314822,172302535,172320667,172306442,172319132,172317008,172317860,172345740,172323116,172313457,172337882,172329056,172323441,172315332,172323613,172322595,172305468,172311117,172317848,172313698,172302918,172305844,172312687,172320666,172319131,172305052,172319491,172321603,172321272,172319018,172304450,172308666,172307504,172307862,172304059,172307044,172323445,172327897,172311791,172313456,172322583,172322983,172319130,172303678,172304069,172306839,172335670,172304060,172323612,172328198,172337877,172319490,172319841,172320441,172321271,172307863,172323115,172307855,172315767,172302915,172303686,172313712,172328542,172311793,172316774,172304055,172320287,172303679,172319129,172323442,172318528,172302561,172306840,172308667,172321604,172309162,172317851,172328563) 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'