select * from specialevent where embargodatum < now() AND event_end >= CURDATE() ORDER BY RAND() LIMIT 0,1SELECT f.ID, f.titel, of.ID AS oID, of.titel AS oTitle FROM film AS f LEFT JOIN film AS of ON of.ID = f.originelefilmID, filmvoorstelling AS fv WHERE fv.filmID = f.ID AND fv.tijdstip >= '2025-05-29' AND fv.tijdstip < ('2025-05-29' + INTERVAL 28 DAY) GROUP BY f.ID ORDER BY COUNT(fv.bioscoopID) DESC, f.premieredatum desc, f.waardering desc, f.titel LIMIT 0,7SELECT f.ID,f.titel FROM film AS f, topfilm AS t WHERE t.filmID = f.ID AND t.landID=145 GROUP BY f.ID ORDER BY t.nr, f.titelSELECT begindatum FROM topfilm_by_week WHERE landID=145 ORDER BY begindatum DESC LIMIT 0,1SELECT f.ID,f.titel FROM film AS f, topfilm_by_week AS t WHERE t.filmID = f.ID AND t.landID=145 AND begindatum = '2025-05-08' GROUP BY f.ID ORDER BY t.nr, f.titelSELECT f.ID,f.titel FROM film AS f WHERE f.premieredatum > ('2025-05-29' + INTERVAL 3 DAY) AND f.premieredatum < ('2025-05-29' + INTERVAL 62 DAY) ORDER BY f.premieredatum asc, f.jaar desc, f.waardering desc, f.titelSELECT f.ID,f.titel,f.originelefilmID,w.still FROM film AS f, film_of_the_week AS w WHERE w.filmID = f.ID AND w.begindatum <= '2025-05-29' AND w.begindatum > ('2025-05-29' - INTERVAL 5 DAY) GROUP BY f.ID ORDER BY w.begindatum DESC, f.titel LIMIT 1SELECT * FROM persoon WHERE ID='296400'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='296400'select filmfunctie.omschrijving from film_medewerker,filmfunctie where film_medewerker.persoonID = '296400' and filmfunctie.ID = film_medewerker.functieID group by filmfunctie.ID order by filmfunctie.omschrijvingSELECT f.ID,f.titel,COUNT(fv.bioscoopID) AS cinemas, fm.role, fm.isLeading,f.originelefilmID FROM film AS f LEFT JOIN film AS of ON of.originelefilmID=f.ID, film_medewerker AS fm, filmvoorstelling AS fv WHERE fm.persoonID='296400' AND fm.filmID=f.ID AND (fv.filmID=f.ID OR fv.filmID=f.originelefilmID OR fv.filmID=of.ID) AND fv.tijdstip > now() AND fv.tijdstip < (now() + INTERVAL 8 DAY) GROUP BY f.ID ORDER BY cinemas DESC, f.jaar DESC, f.titel, fm.role DESC, fm.isLeading ASCSELECT f.ID,f.titel, fm.role, fm.isLeading,f.originelefilmID FROM film AS f, film_medewerker AS fm WHERE fm.persoonID='296400' AND fm.filmID=f.ID GROUP BY f.ID ORDER BY f.jaar DESC, f.titel, fm.role DESC, fm.isLeading ASCSELECT * FROM `film` WHERE `ID`='38618'SELECT ID, titel FROM film WHERE originelefilmID='38618'SELECT ID,url,onderschrift,verhouding,lokale_url,update_tijd,width,height,type FROM image WHERE ID='45537' AND width>0 AND height>0SELECT * FROM `film` WHERE `ID`='35409'SELECT ID, titel FROM film WHERE originelefilmID='35409'SELECT ID,url,onderschrift,verhouding,lokale_url,update_tijd,width,height,type FROM image WHERE ID='28100' AND width>0 AND height>0SELECT i.ID, i.width, i.height, f.ID AS filmID, f.titel AS film FROM still_image_persoon AS sip, still_image AS i, film AS f WHERE sip.persoonID='296400' AND i.ID=sip.still_imageID AND (f.still1ID=i.ID OR f.still2ID=i.ID OR f.still3ID=i.ID OR f.still4ID=i.ID) ORDER BY f.premieredatum DESC, f.jaar DESC, f.titelSELECT f.still6ID AS ID,f.ID AS filmID,f.titel AS film FROM film AS f, still_image_persoon AS sip WHERE sip.persoonID='296400' AND sip.still_imageID=f.still6ID ORDER BY f.premieredatum DESC, f.ID DESC LIMIT 1SELECT * FROM persoon WHERE ID='296400'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='296400'select filmfunctie.omschrijving from film_medewerker,filmfunctie where film_medewerker.persoonID = '296400' and filmfunctie.ID = film_medewerker.functieID group by filmfunctie.ID order by filmfunctie.omschrijvingSELECT n.ID FROM nieuws AS n LEFT JOIN nieuws_persoon AS np ON np.nieuwsID=n.ID WHERE (np.persoonID='296400' OR intro LIKE '%"Sharmila Devar"%' OR beschrijving LIKE '%"Sharmila Devar"%') AND embargodatum < now() GROUP by n.ID ORDER BY embargodatum DESC, update_tijd DESCSELECT ID FROM hyperleap.prijsvraag WHERE start < now() AND `end` > now() AND winners='N' ORDER BY start DESC LIMIT 0,7SELECT n.* FROM nieuws AS n WHERE (n.nieuws_typeID='1' OR n.nieuws_typeID='3' OR n.nieuws_typeID='4' OR n.nieuws_typeID='5' OR n.nieuws_typeID='6' OR n.nieuws_typeID='7' OR n.nieuws_typeID='8' OR n.nieuws_typeID='9' OR n.nieuws_typeID='10' OR n.nieuws_typeID='11') AND n.embargodatum <= now() ORDER BY n.embargodatum DESC, update_tijd DESC LIMIT 0,7SELECT * FROM `nieuws` WHERE `ID`='9891'SELECT * from nieuws_type WHERE ID = '1'SELECT ID,url,onderschrift,verhouding,lokale_url,update_tijd,width,height,type FROM image WHERE ID='87873' AND width>0 AND height>0SELECT * FROM `nieuws` WHERE `ID`='9888'SELECT * from nieuws_type WHERE ID = '1'SELECT ID,url,onderschrift,verhouding,lokale_url,update_tijd,width,height,type FROM image WHERE ID='87816' AND width>0 AND height>0SELECT * FROM `nieuws` WHERE `ID`='9887'SELECT * from nieuws_type WHERE ID = '1'SELECT ID,url,onderschrift,verhouding,lokale_url,update_tijd,width,height,type FROM image WHERE ID='87815' AND width>0 AND height>0SELECT * FROM `nieuws` WHERE `ID`='9889'SELECT * from nieuws_type WHERE ID = '11'SELECT ID,url,onderschrift,verhouding,lokale_url,update_tijd,width,height,type FROM image WHERE ID='87844' AND width>0 AND height>0SELECT * FROM `nieuws` WHERE `ID`='9885'SELECT * from nieuws_type WHERE ID = '5'SELECT ID,url,onderschrift,verhouding,lokale_url,update_tijd,width,height,type FROM image WHERE ID='87665' AND width>0 AND height>0SELECT * FROM `nieuws` WHERE `ID`='9880'SELECT * from nieuws_type WHERE ID = '11'SELECT ID,url,onderschrift,verhouding,lokale_url,update_tijd,width,height,type FROM image WHERE ID='87655' AND width>0 AND height>0SELECT * FROM `nieuws` WHERE `ID`='9879'SELECT * from nieuws_type WHERE ID = '1'SELECT ID,url,onderschrift,verhouding,lokale_url,update_tijd,width,height,type FROM image WHERE ID='87650' AND width>0 AND height>0SELECT s.ID, s.naam, COUNT(DISTINCT f.filmID) AS films FROM stad AS s, filmagenda AS f WHERE s.ID=f.stadID AND f.begindatum='2025-05-29' GROUP BY s.ID ORDER BY films DESC, s.naam LIMIT 0,7SELECT * FROM `filmvoorstelling` WHERE date(tijdstip)=current_date() AND stadID = '47' ORDER BY tijdstip DESC LIMIT 0,1