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='83347'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='83347'select filmfunctie.omschrijving from film_medewerker,filmfunctie
where film_medewerker.persoonID = '83347' 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='83347' 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 * FROM `film` WHERE `ID`='15454'SELECT ID, titel FROM film WHERE originelefilmID='15454'SELECT ID,url,onderschrift,verhouding,lokale_url,update_tijd,width,height,type FROM image WHERE ID='87770' AND width>0 AND height>0SELECT ff.omschrijving AS function FROM filmfunctie AS ff, film_medewerker AS fm
WHERE fm.persoonID='83347' AND (fm.filmID='15454') AND ff.ID=fm.functieID
GROUP BY ff.ID ORDER BY ff.omschrijvingselect persoon.*,film_medewerker.isLeading, film_medewerker.role from film_medewerker,filmfunctie,persoon LEFT JOIN personRating ON persoon.ID=personRating.personID
where film_medewerker.filmID = '15454' and
filmfunctie.taak = 'acteur' and
film_medewerker.functieID = filmfunctie.ID and
film_medewerker.persoonID = persoon.ID
GROUP BY persoon.ID order by film_medewerker.isLeading, personRating.rating DESC, persoon.achternaam LIMIT 0,3select persoon.*,film_medewerker.isLeading, film_medewerker.role from film_medewerker,filmfunctie,persoon LEFT JOIN personRating ON persoon.ID=personRating.personID
where film_medewerker.filmID = '15454' and
filmfunctie.taak = 'stemmen' and
film_medewerker.functieID = filmfunctie.ID and
film_medewerker.persoonID = persoon.ID
GROUP BY persoon.ID order by film_medewerker.isLeading, personRating.rating DESC, persoon.achternaam LIMIT 0,3SELECT f.ID,f.titel, fm.role, fm.isLeading,f.originelefilmID FROM film AS f, film_medewerker AS fm WHERE
fm.persoonID='83347' 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`='42175'SELECT ID, titel FROM film WHERE originelefilmID='42175'SELECT ff.omschrijving AS function FROM filmfunctie AS ff, film_medewerker AS fm
WHERE fm.persoonID='83347' AND (fm.filmID='42175') AND ff.ID=fm.functieID
GROUP BY ff.ID ORDER BY ff.omschrijvingSELECT * FROM `film` WHERE `ID`='34979'SELECT ID, titel FROM film WHERE originelefilmID='34979'SELECT ID,url,onderschrift,verhouding,lokale_url,update_tijd,width,height,type FROM image WHERE ID='26814' AND width>0 AND height>0SELECT ff.omschrijving AS function FROM filmfunctie AS ff, film_medewerker AS fm
WHERE fm.persoonID='83347' AND (fm.filmID='34979') AND ff.ID=fm.functieID
GROUP BY ff.ID ORDER BY ff.omschrijvingSELECT * FROM `film` WHERE `ID`='30636'SELECT ID, titel FROM film WHERE originelefilmID='30636'SELECT ID,url,onderschrift,verhouding,lokale_url,update_tijd,width,height,type FROM image WHERE ID='22218' AND width>0 AND height>0SELECT ff.omschrijving AS function FROM filmfunctie AS ff, film_medewerker AS fm
WHERE fm.persoonID='83347' AND (fm.filmID='30636') AND ff.ID=fm.functieID
GROUP BY ff.ID ORDER BY ff.omschrijvingSELECT * FROM `film` WHERE `ID`='29501'SELECT ID, titel FROM film WHERE originelefilmID='29501'SELECT ff.omschrijving AS function FROM filmfunctie AS ff, film_medewerker AS fm
WHERE fm.persoonID='83347' AND (fm.filmID='29501') AND ff.ID=fm.functieID
GROUP BY ff.ID ORDER BY ff.omschrijvingSELECT * FROM `film` WHERE `ID`='24069'SELECT ID, titel FROM film WHERE originelefilmID='24069'SELECT ff.omschrijving AS function FROM filmfunctie AS ff, film_medewerker AS fm
WHERE fm.persoonID='83347' AND (fm.filmID='24069') AND ff.ID=fm.functieID
GROUP BY ff.ID ORDER BY ff.omschrijvingSELECT * FROM `film` WHERE `ID`='22953'SELECT ID, titel FROM film WHERE originelefilmID='22953'SELECT ID,url,onderschrift,verhouding,lokale_url,update_tijd,width,height,type FROM image WHERE ID='17718' AND width>0 AND height>0SELECT ff.omschrijving AS function FROM filmfunctie AS ff, film_medewerker AS fm
WHERE fm.persoonID='83347' AND (fm.filmID='22953') AND ff.ID=fm.functieID
GROUP BY ff.ID ORDER BY ff.omschrijvingSELECT * FROM `film` WHERE `ID`='21550'SELECT ID, titel FROM film WHERE originelefilmID='21550'SELECT ID,url,onderschrift,verhouding,lokale_url,update_tijd,width,height,type FROM image WHERE ID='16201' AND width>0 AND height>0SELECT ff.omschrijving AS function FROM filmfunctie AS ff, film_medewerker AS fm
WHERE fm.persoonID='83347' AND (fm.filmID='21550') AND ff.ID=fm.functieID
GROUP BY ff.ID ORDER BY ff.omschrijvingSELECT ff.omschrijving AS function FROM filmfunctie AS ff, film_medewerker AS fm
WHERE fm.persoonID='83347' AND (fm.filmID='15454') AND ff.ID=fm.functieID
GROUP BY ff.ID ORDER BY ff.omschrijvingSELECT 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='83347' 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='83347' AND sip.still_imageID=f.still6ID
ORDER BY f.premieredatum DESC, f.ID DESC LIMIT 1SELECT * FROM persoon WHERE ID='83347'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='83347'select filmfunctie.omschrijving from film_medewerker,filmfunctie
where film_medewerker.persoonID = '83347' 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='83347' OR
intro LIKE '%"Marc-Antoine Robert"%' OR beschrijving LIKE '%"Marc-Antoine Robert"%') 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,7
Stem van: Catherine Deneuve, Chiara Mastroianni, Simon Abkarian
Als de achtjarige Marjane de islamitische revolutie meemaakt in Iran, droomt ze erover om revolutionair te worden. Haar instelling brengt haar in problemen en haar ouders sturen haar naar Wenen. Daar ervaart Marjane haar eigen revolutie in de vorm van vrijheid, liefde maar ook eenzaamheid.