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-12-02' and '2024-12-04'
and t.termin_id in (168883328,168883327,168872037,168905596,168905393,168873812,168870906,168883500,168896545,168905391,168901218,168870771,168873813,168908057,168883326,168903899,168904995,168896604,168905394,168898653,168906832,168904585,168893169,168906865,168901270,168878669,168877855,168896543,168906544,168893168,168901983,168905598,168881542,168906833,168870907,168897819,168791528,168870901,168869996,168889016,168880767,168904994,168908140,168906545,168877854,168895485,168881722,168878668,168870902,168897000,168901901,168870900,168897407,168907717,168791529,168901271,168877537,168873811,168883279,168878670,168896161,168882982,168877790,168877789,168906864,168904583,168880871,168878022,168893167,168889450,168883738,168905390,168905392,168901077,168878761,168905599,168883501,168897533,168901078,168889449,168898654,168823035,168889647,168881723,168880768,168896544,168896765,168904584,168881917,168862818,168871162,168908188,168895410,168880872,168878021,168907168,168881916,168905597,168901076,168862817,168823033,168895207,168895484,168905389,168906863,168870905,168907167,168877608,168871161,168901272,168896999,168907718,168898652,168878762,168880873,168823034) 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'