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 '2024-04-27' and '2024-05-01'
and t.termin_id in (167380238,167363759,167349670,167373872,167377679,167349910,167363220,167379603,167375263,167378984,167135421,167366064,167343181,167342819,167372941,167135424,167351990,167378983,167205116,167378432,167363926,167377683,167368971,167363266,167377681,167379606,167368970,167378672,167349911,167370494,167380235,167368025,167370537,167380562,167363964,167370533,167349909,167379505,167364243,167376879,167378671,167363959,167359556,167378230,167379507,167378231,167378745,167135422,167380793,167370132,167358206,167381084,167370496,167144603,167363927,167378744,167379502,167379506,167363758,167359357,167366062,167363761,167378985,167363046,167372091,167364267,167372801,167342818,167368026,167363048,167365195,167370130,167363006,167364032,167363135,167343075,167289644,167205225,167350337,167366052,167377682,167369102,167366054,167363005,167366063,167358207,167363930,167350926,167373048,167363670,167373051,167364213,167351898,167363960,167380237,167344211,167372800,167364036,167364030,167373871,167363931,167359842,167289648,167363162,167363223,167363965,167359359,167372940,167378233,167359358,167368969,167363963,167364211,167362215,167365192,167370347,167364210,167372937,167375580,167363262,167359554,167351385,167380794,167378742,167369103,167350478,167363668,167379602,167144604,167372092,167378986,167381085,167135423,167359356,167378589,167205223,167350336,167381482,167363760,167363827,167370133,167378743,167364035,167342821,167363165,167378673,167363049,167363263,167358208,167366058,167344212,167366051,167364034,167289646,167381483,167366057,167343074,167363671,167358210,167363669,167370131,167352920,167365478,167378430,167349673,167366050,167370134,167373876,167363219,167343068,167374279,167380561,167369105,167205226,167343071,167378827,167363050,167375582,167368972,167358214,167350481,167378234,167378591,167366061,167289647,167380563,167205224,167342820,167372942,167359360,167363164,167378987,167363966,167379605,167370346,167351386,167363265,167363929,167376880,167370536,167349669,167364212,167352922,167343070,167378433,167373881,167349672,167343183,167358212,167365479,167372351,167351988,167372939,167366060,167205117,167362217,167350480,167373880,167373443,167363047,167368027,167363222,167379504,167350928,167349671,167358211,167370535,167378431,167343069,167378434,167373879,167372090,167372799,167362216,167365194,167375581,167342822,167380236,167363163,167363264,167363961,167378826,167378740,167369101,167363221,167364033,167363826,167350479,167351899,167379503,167369104,167373442,167343076,167373878,167372088,167352921,167366056,167350927,167379604,167363962,167378741,167379501,167370534,167366055,167350477,167374278,167358209,167370495,167372938,167372089,167365193,167379500,167359843,167364029,167378590,167367104,167364031,167377680,167289645,167373877,167366053,167365477,167358213,167366059,167366432,167359555,167373052,167343182,167378232,167362218,167363928) 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,86558852,68181750,158652367,660,797,90722560,674,114793025,576,523,159032782,155235885,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'