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-06-15' and '2024-06-19'
and t.termin_id in (167711989,167693725,167694938,167688158,167709470,167690961,167701321,167688425,167698261,167707698,167713035,167694150,167701056,167704387,167704659,167715945,167711735,167709227,167705416,167711987,167708981,167690967,167706691,167715683,167694932,167689109,167700459,167699850,167699849,167705214,167690723,167713033,167708979,167690965,167703801,167711645,167718958,167688669,167694154,167689330,167697931,167712659,167687594,167687615,167704856,167688510,167704386,167699856,167688915,167701953,167694151,167693469,167715682,167697923,167700838,167713034,167701956,167699854,167700841,167713571,167711101,167696104,167692617,167698262,167703038,167717997,167708982,167690968,167703804,167704853,167703575,167706952,167712203,167700461,167688503,167702211,167697925,167694940,167701059,167699610,167704851,167702216,167707155,167689730,167700451,167688166,167704260,167697924,167706689,167637243,167691626,167694375,167689111,167694157,167713031,167697332,167695796,167711982,167705929,167690064,167705934,167693212,167690066,167706686,167637582,167684698,167690725,167701055,167702424,167691625,167700135,167713572,167696101,167694933,167689741,167701323,167689742,167688919,167703043,167688163,167705222,167712658,167698264,167694152,167719684,167699428,167699426,167702213,167705414,167701955,167697318,167710349,167689329,167700457,167708624,167704850,167692620,167699427,167699611,167715944,167697932,167691631,167694939,167694930,167702620,167712846,167690431,167700137,167700463,167709795,167704663,167694934,167705225,167704662,167708990,167711981,167694153,167693726,167694376,167688670,167711104,167703041,167718961,167689731,167719685,167688673,167697514,167697916,167637241,167697919,167716424,167690059,167702215,167701319,167697314,167704661,167699852,167694149,167712849,167691619,167703805,167707415,167703044,167703039,167708625,167696100,167695557,167709791,167708417,167689389,167701730,167697516,167706685,167689740,167699851,167700453,167701528,167694374,167700837,167688165,167703276,167689729,167689390,167689297,167704029,167692616,167693727,167693210,167701525,167679126,167704652,167698260,167701320,167702426,167718959,167696103,167693209,167697330,167711988,167703277,167711644,167700455,167695439,167719683,167686814,167693202,167704657,167711985,167699846,167699609,167712850,167697517,167690067,167707158,167694156,167679125,167704653,167703576,167699429,167708986,167689107,167703799,167697331,167708978,167690964,167714703,167698256,167701957,167700452,167701526,167712475,167704385,167709788,167707697,167695795,167702217,167686818,167705933,167715939,167692393,167701954,167712473,167689733,167691223,167697922,167704030,167718954,167699425,167695789,167702621,167718960,167702212,167704855,167717980,167697327,167706687,167697513,167697322,167697914,167691219,167718955,167709794,167637242,167718952,167711990,167711643,167706688,167700836,167700454,167708988,167718953,167702619,167699613,167707157,167705931,167703803,167713565,167700458,167709225,167701729,167712657,167704655,167697324,167697917,167704654,167697333,167686817,167691222,167690724,167689300,167708627,167703037,167697312,167697328,167697918,167688427,167713566,167697317,167704858,167701733,167705927,167701057,167709228,167704259,167713569,167701322,167688671,167715684,167718951,167712474,167692686,167710347,167711646,167699848,167706684,167686813,167698263,167712847,167693468,167705939,167695790,167702425,167706690,167701731,167691220,167712848,167701058,167713564,167692127,167704389,167708402,167713568,167700460,167692685,167710348,167697913,167693213,167697928,167692687,167705928,167687595,167694941,167709792,167707735,167697326,167689108,167700840,167705223,167704658,167703042,167708983,167692150,167700462,167704656,167703800,167687641,167694931,167703256,167707822,167700132,167701060,167702423,167695794,167707416,167691221,167698257,167700134,167708980,167690966,167705221,167711647,167698255,167703802,167701732,167711983,167704849,167700839,167690726,167715940,167715946,167705216,167691628,167703045,167705417,167701529,167688167,167699431,167688506,167703806,167705935,167699430,167701527,167711105,167694942,167712660,167697325,167689331,167709471,167707417,167705215,167697313,167700136,167688672,167705932,167697515,167704031,167689732,167708626,167702427,167688918,167704388,167686816,167699612,167690062,167705224,167712204,167693211,167704660,167699847,167712476,167708989,167694155,167699853,167688504,167704258,167693203,167689739,167705938,167483260,167711986,167691627,167688917,167696102,167713570,167705415,167697930,167712477,167704857,167689299,167702214,167686815,167704854,167711103,167689738,167704032,167704852,167711102,167703040,167714674,167715943,167697929,167688426,167692827,167700133,167688916,167713032,167707823,167708628,167700456,167688505,167708987,167713567,167697323,167697329,167705930,167690430,167698254,167699855,167700842,167715685,167697319,167689110,167690065,167711984,167707156,167709226,167689298) 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'