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 (168879928,168899104,168906045,168897290,168879366,168908956,168886116,168893684,168892635,168881636,168889921,168880301,168894680,168880298,168890438,168896924,168890770,168887887,168873327,168886416,168879076,168908957,168886415,168874648,168882833,168893039,168879929,168887885,168891807,168879075,168873875,168881637,168875140,168895669,168877291,168886424,168899103,168873326,168879368,168875139,168888453,168885885,168885884,168886790,168895543,168880300,168894681,168894278,168886426,168890437,168876398,168906044,168877292,168899105,168870821,168894679,168880296,168897288,168880299,168874647,168880297,168893040,168874646,168887334,168896921,168893685,168870823,168904039,168889922,168885837,168879369,168888454,168886791,168905837,168885886,168884554,168890772,168870822,168887333,168887886,168873874,168882834,168876397,168904038,168897289,168891296,168892636,168885836,168879367,168884553,168878221,168886425,168895544,168892637,168893683,168884446,168893038,168875138,168896923,168879927,168889920,168904037,168876396,168891295,168885835,168884552,168906047,168886414,168890769,168873607,168888452,168882835,168886117,168873873,168873608,168908955,168890771,168873325) 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'