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-05-30' and '2024-06-05'
and t.termin_id in (167629842,167626184,167607782,167625999,167618568,167606950,167624338,167604867,167619987,167622515,167627841,167607787,167620064,167607280,167619150,167601415,167629849,167619988,167602464,167619304,167606952,167602496,167608803,167614242,167611489,167607780,167619153,167621839,167433250,167618565,167617430,167592883,167627839,167604863,167625504,167601981,167604779,167619309,167627444,167606412,167607779,167627561,167624961,167606408,167607781,167605816,167595331,167601983,167621837,167622519,167594099,167627441,167611464,167591760,167612089,167591561,167605808,167607777,167629677,167392642,167619985,167606947,167594104,167619466,167624816,167595368,167624811,167606411,167620343,167626185,167592869,167610615,167621920,167620622,167592594,167627560,167624971,167626181,167611138,167617428,167599721,167624341,167611148,167592870,167611078,167616257,167620659,167592722,167603755,167608731,167627222,167615718,167619984,167602467,167627840,167605807,167627553,167621917,167595333,167624650,167613870,167620665,167608801,167627846,167621840,167620065,167625508,167628704,167629303,167624655,167606941,167624337,167619146,167621834,167616262,167624962,167599729,167615719,167625506,167614247,167609555,167611077,167621832,167594856,167620336,167617015,167591554,167610547,167628503,167602495,167618010,167629850,167606409,167624968,167612523,167594930,167619990,167606946,167627556,167610549,167601980,167611140,167630217,167594106,167591562,167602491,167392641,167610550,167592595,167603759,167616259,167625507,167620333,167607785,167625996,167592881,167607778,167624806,167611076,167601982,167599730,167599723,167624342,167601416,167629138,167630238,167611017,167597980,167611146,167611142,167621914,167606942,167617427,167627552,167620337,167604865,167619307,167597812,167611021,167622522,167617998,167604780,167626180,167619980,167603752,167603756,167625509,167592593,167629852,167625712,167624957,167620661,167607282,167629844,167591553,167620340,167608727,167620344,167607277,167619452,167594871,167615720,167607788,167613879,167618000,167606414,167611241,167617005,167622516,167611143,167629843,167613874,167601412,167608726,167624798,167612525,167617008,167612080,167614239,167624651,167617426,167630218,167597811,167592719,167628703,167625781,167604868,167624815,167608792,167594855,167597813,167592889,167620656,167628701,167629133,167618561,167611018,167597808,167620660,167608797,167619152,167601411,167594932,167594101,167619161,167611488,167597977,167625783,167624800,167594872,167591759,167630220,167595336,167616256,167619975,167629678,167624652,167624644,167433251,167618009,167619983,167609428,167626190,167612085,167616258,167612495,167624804,167592893,167606405,167627440,167629132,167607784,167618012,167608746,167609554,167619468,167608729,167611015,167595143,167597810,167597978,167594105,167619162,167624966,167609469,167627221,167609559,167625993,167624799,167624960,167603751,167621842,167601985,167620666,167629131,167625994,167618014,167626179,167617429,167629839,167614244,167606945,167625779,167629135,167625995,167611466,167624817,167617010,167597975,167618571,167594102,167625510,167433248,167609468,167609557,167612088,167594931,167624970,167392643,167627223,167629851,167618401,167629130,167626188,167597979,167614240,167606944,167630223,167627225,167624339,167620066,167620063,167619464,167619145,167614248,167592882,167620621,167618400,167611016,167624350,167609560,167595332,167609427,167433249,167627555,167604864,167611462,167606951,167628501,167625775,167626236,167610546,167622514,167611139,167612090,167608796,167619982,167620334,167595142,167618564,167603762,167601410,167625776,167602466,167618562,167607288,167618572,167610548,167618402,167611141,167595147,167611463,167629681,167603754,167613871,167611244,167619147,167601984,167620662,167618403,167608730,167611013,167619986,167620339,167628702,167613875,167624345,167605811,167624347,167604900,167597985,167627558,167592884,167620669,167629286,167618004,167616260,167627439,167613869,167594927,167607284,167629846,167615717,167612081,167621915,167595149,167624654,167629284,167620335,167620658,167597814,167628496,167602463,167617016,167607281,167617009,167607279,167613878,167628705,167625503,167595146,167629145,167624647,167612092,167628502,167619154,167611438,167594098,167618404,167608732,167629137,167619465,167621831,167629841,167617007,167617014,167607283,167625778,167619155,167599726,167609610,167627842,167594934,167483175,167604785,167608723,167627559,167622513,167603753,167592890,167612093,167627563,167628497,167619463,167602465,167613872,167625511,167607783,167613877,167592892,167601409,167606407,167617006,167595167,167620062,167592720,167611019,167624802,167624814,167592717,167627438,167604778,167592592,167626189,167609553,167628706,167594107,167624959,167626182,167608804,167591763,167604866,167599733,167624797,167624801,167595141,167629679,167611059,167611145,167605817,167599731,167619160,167614238,167622512,167624796,167627557,167608798,167621833,167611490,167609470,167625777,167594928,167610616,167599724,167625505,167624346,167627451,167592887,167620663,167591764,167595334,167630237,167619165,167606943,167627845,167607786,167621830,167618002,167620667,167608805,167608724,167605805,167592591,167605803,167611242,167591560,167592725,167617019,167609472,167606953,167597987,167605813,167624348,167614250,167609467,167601987,167611060,167599728,167595339,167607290,167625780,167619976,167601404,167611245,167603763,167592871,167629285,167629848,167618405,167629139,167624807,167627220,167629675,167627565,167611014,167603765,167620068,167612087,167599727,167620668,167627445,167594103,167624340,167602468,167604784,167624803,167618566,167617020,167594926,167612079,167603761,167592590,167605806,167614249,167627564,167624645,167607289,167615722,167603764,167609558,167618563,167624349,167619166,167622521,167621841,167617999,167605818,167624656,167605812,167627224,167615716,167605804,167604783,167591558,167609609,167611147,167615721,167611289,167606413,167618008,167611020,167602462,167614237,167606406,167626183,167619467,167608808,167603770,167625774,167602490,167622520,167620342,167619989,167608793,167628495,167620657,167618567,167627219,167624963,167629840,167624972,167607278,167597976,167597809,167619157,167591557,167609471,167620067,167592724,167612492,167617997,167619311,167610545,167592598,167619149,167616261,167603769,167611240,167629136,167621919,167607287,167612095,167611012,167601979,167592888,167627562,167620341,167618003,167592886,167629676,167608802,167621836,167597984,167614245,167617424,167630219,167624969,167606949,167601414,167605810,167591555,167604782,167591556,167609608,167624813,167612524,167627443,167611439,167612094,167613876,167591802,167603772,167614241,167603757,167621838,167630222,167597990,167611243,167629146,167607286,167627838,167599722,167619151,167385976,167592885,167612096,167615848,167599725,167619310,167618408,167625997,167620664,167619148,167621923,167595144,167607285,167619144,167624643,167629847,167601413,167617013,167617012,167612494,167603760,167612082,167624646,167603771,167597983,167619164,167591563,167392644,167601407,167597982,167629845,167611144,167608794,167621829,167612078,167624812,167611465,167606410,167622518,167609562,167619979,167618007,167629680,167592891,167614236,167620331,167606948,167592599,167624958,167601977,167618011,167629128,167611260,167624795,167604781,167591559,167597981,167613867,167607776,167605809,167609556,167601403,167625502,167611137,167595338,167627437,167614246,167611437,167595337,167612493,167625512,167597817,167625501,167603768,167609552,167601978,167617011,167608800,167594933,167619981,167602492,167621918,167629134,167624642,167385977,167607789,167612091,167621828,167618001,167630216,167625784,167603758,167592718,167613873,167621835,167627442,167614243,167619306,167594100,167610544,167608799,167594929,167625782,167591761,167604899,167619163,167624967,167627218,167621916,167625998,167617425,167601408,167601986,167595148,167602494,167592723,167627452,167602493,167591762,167595335,167630221,167592721,167609561,167608728,167611075,167591765,167627554,167608795,167620332,167629287,167613868,167612086,167629129,167604777,167613880,167612098,167628498,167611079,167619156,167624653,167618013,167617694,167601402,167619308,167620338,167599732,167622517,167624810,167624641,167597986,167608725,167612097,167624805) 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,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'