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='6896'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='6896'select filmfunctie.omschrijving from film_medewerker,filmfunctie where film_medewerker.persoonID = '6896' 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='6896' 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='6896' 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`='27802'SELECT ID, titel FROM film WHERE originelefilmID='27802'SELECT ff.omschrijving AS function FROM filmfunctie AS ff, film_medewerker AS fm WHERE fm.persoonID='6896' AND (fm.filmID='27802') AND ff.ID=fm.functieID GROUP BY ff.ID ORDER BY ff.omschrijvingSELECT * FROM `film` WHERE `ID`='24099'SELECT ID, titel FROM film WHERE originelefilmID='24099'SELECT * FROM `film` WHERE `ID`='23363'SELECT ID, titel FROM film WHERE originelefilmID='23363'SELECT * FROM `film` WHERE `ID`='26627'SELECT ID, titel FROM film WHERE originelefilmID='26627'SELECT * FROM `film` WHERE `ID`='16808'SELECT ID, titel FROM film WHERE originelefilmID='16808'SELECT ID,url,onderschrift,verhouding,lokale_url,update_tijd,width,height,type FROM image WHERE ID='12000' AND width>0 AND height>0SELECT * FROM `film` WHERE `ID`='18397'SELECT ID, titel FROM film WHERE originelefilmID='18397'SELECT ID,url,onderschrift,verhouding,lokale_url,update_tijd,width,height,type FROM image WHERE ID='13697' AND width>0 AND height>0SELECT * FROM `film` WHERE `ID`='10358'SELECT ID, titel FROM film WHERE originelefilmID='10358'SELECT ID,url,onderschrift,verhouding,lokale_url,update_tijd,width,height,type FROM image WHERE ID='7536' AND width>0 AND height>0SELECT * FROM `film` WHERE `ID`='7468'SELECT ID, titel FROM film WHERE originelefilmID='7468'SELECT ID,url,onderschrift,verhouding,lokale_url,update_tijd,width,height,type FROM image WHERE ID='5152' AND width>0 AND height>0SELECT * FROM `film` WHERE `ID`='4668'SELECT ID, titel FROM film WHERE originelefilmID='4668'SELECT ID,url,onderschrift,verhouding,lokale_url,update_tijd,width,height,type FROM image WHERE ID='3401' AND width>0 AND height>0SELECT * FROM `film` WHERE `ID`='8938'SELECT * FROM `film` WHERE `ID`='4668'SELECT ID, titel FROM film WHERE originelefilmID='4668'SELECT ID,url,onderschrift,verhouding,lokale_url,update_tijd,width,height,type FROM image WHERE ID='3401' AND width>0 AND height>0SELECT ID, titel FROM film WHERE originelefilmID='8938' OR originelefilmID='4668'SELECT ID,url,onderschrift,verhouding,lokale_url,update_tijd,width,height,type FROM image WHERE ID='6288' AND width>0 AND height>0SELECT * FROM `film` WHERE `ID`='6321'SELECT ID, titel FROM film WHERE originelefilmID='6321'SELECT ID,url,onderschrift,verhouding,lokale_url,update_tijd,width,height,type FROM image WHERE ID='4357' AND width>0 AND height>0SELECT * FROM `film` WHERE `ID`='4801'SELECT ID, titel FROM film WHERE originelefilmID='4801'SELECT ID,url,onderschrift,verhouding,lokale_url,update_tijd,width,height,type FROM image WHERE ID='3068' AND width>0 AND height>0SELECT * FROM `film` WHERE `ID`='1265'SELECT ID, titel FROM film WHERE originelefilmID='1265'SELECT ID,url,onderschrift,verhouding,lokale_url,update_tijd,width,height,type FROM image WHERE ID='640' AND width>0 AND height>0SELECT * FROM `film` WHERE `ID`='4575'SELECT ID, titel FROM film WHERE originelefilmID='4575'SELECT ID,url,onderschrift,verhouding,lokale_url,update_tijd,width,height,type FROM image WHERE ID='2881' AND width>0 AND height>0SELECT * FROM `film` WHERE `ID`='26074'SELECT ID, titel FROM film WHERE originelefilmID='26074'SELECT * FROM `film` WHERE `ID`='1869'SELECT ID, titel FROM film WHERE originelefilmID='1869'SELECT ID,url,onderschrift,verhouding,lokale_url,update_tijd,width,height,type FROM image WHERE ID='58374' 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='6896' 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 p.* FROM still_image_persoon AS si, persoon AS p WHERE si.still_imageID='34927' AND p.ID=si.persoonID ORDER BY si.place,p.achternaamSELECT f.still6ID AS ID,f.ID AS filmID,f.titel AS film FROM film AS f, still_image_persoon AS sip WHERE sip.persoonID='6896' AND sip.still_imageID=f.still6ID ORDER BY f.premieredatum DESC, f.ID DESC LIMIT 1SELECT * FROM persoon WHERE ID='6896'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='6896'select filmfunctie.omschrijving from film_medewerker,filmfunctie where film_medewerker.persoonID = '6896' 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='6896' OR intro LIKE '%"Samuel Le Bihan"%' OR beschrijving LIKE '%"Samuel Le Bihan"%') 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 COUNT(*) AS hits FROM `filmvoorstelling` WHERE date(tijdstip)=current_date() AND stadID = '130'