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 '2026-07-13' and '2026-07-15'
and t.termin_id in (172831701,172827693,172835593,172843151,172857871,172850326,172830796,172842057,172844057,172856134,172851083,172858180,172827848,172848103,172858186,172836141,172855921,172831597,172833703,172839426,172851905,172832293,172847501,172835384,172838413,172842817,172841399,172832865,172829641,172840913,172848609,172850325,172856030,172838018,172846304,172840269,172855916,172844926,172858179,172837170,172854527,172835592,172854181,172834594,172856372,172841100,172828239,172838414,172857120,172837702,172841400,172835383,172838007,172828240,172831603,172859380,172842819,172851794,172855918,172844927,172859381,172847497,172829532,172845808,172847496,172844928,172855920,172845806,172828357,172832286,172838553,172839643,172854824,172850324,172832284,172847660,172846381,172853134,172833315,172842421,172831596,172833316,172838020,172852808,172833307,172838412,172835073,172848101,172834593,172849546,172852806,172838405,172857056,172854825,172857057,172820535,172856373,172857610,172836145,172852807,172858459,172839949,172831602,172851907,172841099,172840914,172841101,172842422,172848608,172832424,172827027,172854528,172838552,172848879,172827029,172831282,172838021,172847661,172858181,172836531,172837162,172825822,172828842,172854828,172832423,172858458,172837169,172851712,172826481,172838417,172831283,172829709,172842818,172844609,172849828,172829708,172831284,172845807,172834028,172831699,172835074,172834026,172857119,172842058,172856135,172834027,172833317,172848607,172851082,172856031,172852310,172825854,172832870,172832871,172854182,172836144,172838407,172855220,172829640,172839948,172858182,172857612,172826480,172854529,172850226,172827694,172854183,172836143,172847662,172832425,172828844,172841401,172832292,172842423,172829710,172840271,172859382,172857121,172831604,172846328,172855919,172826482,172830794,172853895,172833702,172848904,172843876,172851711,172848102,172827847,172829531,172857611,172836142,172851906,172838406,172839425,172832285,172836530,172857438,172840270,172838019,172833306,172830795,172827028,172831700,172855917,172856371,172846327,172852289,172854823,172833701,172837701,172851710,172838551,172855219,172836140,172853133,172825821,172834102,172857738,172835591,172832291,172844056,172856133,172828238,172835382,172842056,172839947,172850225,172838017,172851084,172834103,172835075,172839287,172853896,172833305,172856029,172851795,172828843,172853894,172829530,172836529) 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,600,531,640,4418517,518,158756075,120495740,43655193,120903995,138298993,120898947,120904850,573,561,616,4059065,65755259,831,610,613,617,26245648,703,794,594,506,817,595,507,139115800,563,614,727,930379,588,107373420,828,159032779,3138320,685,3308890,158652363,27722768,159032776,690,5177115,167341712,86558852,68181750,158652367,660,797,90722560,674,114793025,576,523,159032782,19373191,155235885,167893195,137006144,29833136,28701456,730,575,806,37791196,662,555,557,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,612,560,731,69826983,136560904,29686640,135037060,598,569,5652079,709)
and t.status='aktiv'