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 * FROM `film` WHERE `ID`='35787'SELECT ID, titel FROM film WHERE originelefilmID='35787'SELECT ID,url,onderschrift,verhouding,lokale_url,update_tijd,width,height,type FROM image WHERE ID='28498' AND width>0 AND height>0SELECT * FROM mening WHERE filmID='35787' ORDER BY tijd DESCselect persoon.*,film_medewerker.isLeading, film_medewerker.role from film_medewerker,filmfunctie,persoon LEFT JOIN personRating ON persoon.ID=personRating.personID where film_medewerker.filmID = '35787' 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,4select persoon.*,film_medewerker.isLeading, film_medewerker.role from film_medewerker,filmfunctie,persoon LEFT JOIN personRating ON persoon.ID=personRating.personID where film_medewerker.filmID = '35787' and filmfunctie.taak = 'regie' 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,2select * from filmrecensie where filmID = '35787' order by urlSELECT n.*,l.main,l.filmID AS linkedID FROM nieuws_film AS l,nieuws AS n WHERE l.filmID='35787' AND n.ID=l.nieuwsID AND l.main='Y' AND n.nieuws_typeID='4' AND n.embargodatum<=now() GROUP BY n.ID ORDER BY n.embargodatum DESCSELECT tv.*, ch.title AS channel FROM tvagenda AS tv, tvchannel AS ch WHERE tv.`date`>=CURRENT_DATE() AND tv.filmID='35787' AND tv.TVchannelID=ch.ID SELECT s.ID,s.naam AS stad, s.landID FROM filmvoorstelling AS a, stad AS s WHERE (a.filmID='35787') AND a.tijdstip > (now() - INTERVAL 2 HOUR) AND a.tijdstip <= (now() + INTERVAL 180 DAY) AND a.stadID=s.ID GROUP BY a.stadID ORDER BY s.naamSELECT tv.*, ch.title AS channel FROM tvagenda AS tv, tvchannel AS ch WHERE tv.`date`>=CURRENT_DATE() AND tv.filmID='35787' AND tv.TVchannelID=ch.ID SELECT n.*,nf.filmID FROM nieuws AS n, nieuws_film AS nf WHERE (nf.filmID='35787') AND n.ID = nf.nieuwsID AND n.embargodatum <= now() GROUP BY n.ID ORDER BY n.embargodatum DESC LIMIT 10SELECT n.* FROM nieuws_film AS l, nieuws AS n WHERE (l.filmID='35787') AND l.main='Y' AND n.ID=l.nieuwsID AND n.nieuws_typeID=4 AND n.embargodatum<=now() ORDER BY n.embargodatum DESCselect persoon.*,film_medewerker.isLeading, film_medewerker.role from film_medewerker,filmfunctie,persoon LEFT JOIN personRating ON persoon.ID=personRating.personID where film_medewerker.filmID = '35787' and filmfunctie.taak = 'regie' 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 SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='8140'SELECT f.still6ID AS ID,f.ID AS filmID FROM film AS f, still_image_persoon AS sip WHERE sip.persoonID='8140' AND sip.still_imageID=f.still6ID AND f.ID='35787'SELECT f.still6ID AS ID,f.ID AS filmID,f.titel AS film FROM film AS f, still_image_persoon AS sip WHERE sip.persoonID='8140' AND sip.still_imageID=f.still6ID ORDER BY f.premieredatum DESC, f.ID DESC LIMIT 1select persoon.*,film_medewerker.isLeading, film_medewerker.role from film_medewerker,filmfunctie,persoon LEFT JOIN personRating ON persoon.ID=personRating.personID where film_medewerker.filmID = '35787' 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,12SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='4085'SELECT f.still6ID AS ID,f.ID AS filmID FROM film AS f, still_image_persoon AS sip WHERE sip.persoonID='4085' AND sip.still_imageID=f.still6ID AND f.ID='35787'SELECT f.still6ID AS ID,f.ID AS filmID,f.titel AS film FROM film AS f, still_image_persoon AS sip WHERE sip.persoonID='4085' AND sip.still_imageID=f.still6ID ORDER BY f.premieredatum DESC, f.ID DESC LIMIT 1SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='74621'SELECT f.still6ID AS ID,f.ID AS filmID FROM film AS f, still_image_persoon AS sip WHERE sip.persoonID='74621' AND sip.still_imageID=f.still6ID AND f.ID='35787'SELECT f.still6ID AS ID,f.ID AS filmID,f.titel AS film FROM film AS f, still_image_persoon AS sip WHERE sip.persoonID='74621' AND sip.still_imageID=f.still6ID ORDER BY f.premieredatum DESC, f.ID DESC LIMIT 1SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='5519'SELECT f.still6ID AS ID,f.ID AS filmID FROM film AS f, still_image_persoon AS sip WHERE sip.persoonID='5519' AND sip.still_imageID=f.still6ID AND f.ID='35787'SELECT f.still6ID AS ID,f.ID AS filmID,f.titel AS film FROM film AS f, still_image_persoon AS sip WHERE sip.persoonID='5519' AND sip.still_imageID=f.still6ID ORDER BY f.premieredatum DESC, f.ID DESC LIMIT 1SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='46495'SELECT f.still6ID AS ID,f.ID AS filmID FROM film AS f, still_image_persoon AS sip WHERE sip.persoonID='46495' AND sip.still_imageID=f.still6ID AND f.ID='35787'SELECT f.still6ID AS ID,f.ID AS filmID,f.titel AS film FROM film AS f, still_image_persoon AS sip WHERE sip.persoonID='46495' AND sip.still_imageID=f.still6ID ORDER BY f.premieredatum DESC, f.ID DESC LIMIT 1SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='31509'SELECT f.still6ID AS ID,f.ID AS filmID FROM film AS f, still_image_persoon AS sip WHERE sip.persoonID='31509' AND sip.still_imageID=f.still6ID AND f.ID='35787'SELECT f.still6ID AS ID,f.ID AS filmID,f.titel AS film FROM film AS f, still_image_persoon AS sip WHERE sip.persoonID='31509' AND sip.still_imageID=f.still6ID ORDER BY f.premieredatum DESC, f.ID DESC LIMIT 1SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='66314'SELECT f.still6ID AS ID,f.ID AS filmID FROM film AS f, still_image_persoon AS sip WHERE sip.persoonID='66314' AND sip.still_imageID=f.still6ID AND f.ID='35787'SELECT f.still6ID AS ID,f.ID AS filmID,f.titel AS film FROM film AS f, still_image_persoon AS sip WHERE sip.persoonID='66314' AND sip.still_imageID=f.still6ID ORDER BY f.premieredatum DESC, f.ID DESC LIMIT 1SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='53225'SELECT f.still6ID AS ID,f.ID AS filmID FROM film AS f, still_image_persoon AS sip WHERE sip.persoonID='53225' AND sip.still_imageID=f.still6ID AND f.ID='35787'SELECT f.still6ID AS ID,f.ID AS filmID,f.titel AS film FROM film AS f, still_image_persoon AS sip WHERE sip.persoonID='53225' AND sip.still_imageID=f.still6ID ORDER BY f.premieredatum DESC, f.ID DESC LIMIT 1SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='48189'SELECT f.still6ID AS ID,f.ID AS filmID FROM film AS f, still_image_persoon AS sip WHERE sip.persoonID='48189' AND sip.still_imageID=f.still6ID AND f.ID='35787'SELECT f.still6ID AS ID,f.ID AS filmID,f.titel AS film FROM film AS f, still_image_persoon AS sip WHERE sip.persoonID='48189' AND sip.still_imageID=f.still6ID ORDER BY f.premieredatum DESC, f.ID DESC LIMIT 1SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='36196'SELECT f.still6ID AS ID,f.ID AS filmID FROM film AS f, still_image_persoon AS sip WHERE sip.persoonID='36196' AND sip.still_imageID=f.still6ID AND f.ID='35787'SELECT f.still6ID AS ID,f.ID AS filmID,f.titel AS film FROM film AS f, still_image_persoon AS sip WHERE sip.persoonID='36196' AND sip.still_imageID=f.still6ID ORDER BY f.premieredatum DESC, f.ID DESC LIMIT 1SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='59295'SELECT f.still6ID AS ID,f.ID AS filmID FROM film AS f, still_image_persoon AS sip WHERE sip.persoonID='59295' AND sip.still_imageID=f.still6ID AND f.ID='35787'SELECT f.still6ID AS ID,f.ID AS filmID,f.titel AS film FROM film AS f, still_image_persoon AS sip WHERE sip.persoonID='59295' AND sip.still_imageID=f.still6ID ORDER BY f.premieredatum DESC, f.ID DESC LIMIT 1SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='136022'SELECT f.still6ID AS ID,f.ID AS filmID FROM film AS f, still_image_persoon AS sip WHERE sip.persoonID='136022' AND sip.still_imageID=f.still6ID AND f.ID='35787'SELECT f.still6ID AS ID,f.ID AS filmID,f.titel AS film FROM film AS f, still_image_persoon AS sip WHERE sip.persoonID='136022' AND sip.still_imageID=f.still6ID ORDER BY f.premieredatum DESC, f.ID DESC LIMIT 1SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='67815'SELECT f.still6ID AS ID,f.ID AS filmID FROM film AS f, still_image_persoon AS sip WHERE sip.persoonID='67815' AND sip.still_imageID=f.still6ID AND f.ID='35787'SELECT f.still6ID AS ID,f.ID AS filmID,f.titel AS film FROM film AS f, still_image_persoon AS sip WHERE sip.persoonID='67815' AND sip.still_imageID=f.still6ID ORDER BY f.premieredatum DESC, f.ID DESC LIMIT 1select persoon.*,film_medewerker.isLeading, film_medewerker.role from film_medewerker,filmfunctie,persoon LEFT JOIN personRating ON persoon.ID=personRating.personID where film_medewerker.filmID = '35787' 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,12select persoon.*,film_medewerker.isLeading, film_medewerker.role from film_medewerker,filmfunctie,persoon LEFT JOIN personRating ON persoon.ID=personRating.personID where film_medewerker.filmID = '35787' 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 12,100SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='147996'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='237986'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='301216'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='301220'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='301213'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='254237'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='301219'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='301221'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='156726'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='301218'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='301217'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='226739'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='211418'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='301214'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='301215'select persoon.*,film_medewerker.isLeading, film_medewerker.role from film_medewerker,filmfunctie,persoon LEFT JOIN personRating ON persoon.ID=personRating.personID where film_medewerker.filmID = '35787' 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 12,100select persoon.*,film_medewerker.isLeading, film_medewerker.role from film_medewerker,filmfunctie,persoon LEFT JOIN personRating ON persoon.ID=personRating.personID where film_medewerker.filmID = '35787' and filmfunctie.taak = 'scenario' 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 SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='259875'select persoon.*,film_medewerker.isLeading, film_medewerker.role from film_medewerker,filmfunctie,persoon LEFT JOIN personRating ON persoon.ID=personRating.personID where film_medewerker.filmID = '35787' and filmfunctie.taak = 'camera' 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 SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='14535'select persoon.*,film_medewerker.isLeading, film_medewerker.role from film_medewerker,filmfunctie,persoon LEFT JOIN personRating ON persoon.ID=personRating.personID where film_medewerker.filmID = '35787' and filmfunctie.taak = 'montage' 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 SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='4099'select persoon.*,film_medewerker.isLeading, film_medewerker.role from film_medewerker,filmfunctie,persoon LEFT JOIN personRating ON persoon.ID=personRating.personID where film_medewerker.filmID = '35787' and filmfunctie.taak = 'enscenering' 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 SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='23197'select persoon.*,film_medewerker.isLeading, film_medewerker.role from film_medewerker,filmfunctie,persoon LEFT JOIN personRating ON persoon.ID=personRating.personID where film_medewerker.filmID = '35787' and filmfunctie.taak = 'kostuums' 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 SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='65043'select persoon.*,film_medewerker.isLeading, film_medewerker.role from film_medewerker,filmfunctie,persoon LEFT JOIN personRating ON persoon.ID=personRating.personID where film_medewerker.filmID = '35787' and filmfunctie.taak = 'muziek' 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 SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='301222'select persoon.*,film_medewerker.isLeading, film_medewerker.role from film_medewerker,filmfunctie,persoon LEFT JOIN personRating ON persoon.ID=personRating.personID where film_medewerker.filmID = '35787' and filmfunctie.taak = 'geluid' 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 SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='80831'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='15308'select persoon.*,film_medewerker.isLeading, film_medewerker.role from film_medewerker,filmfunctie,persoon LEFT JOIN personRating ON persoon.ID=personRating.personID where film_medewerker.filmID = '35787' and filmfunctie.taak = 'geluidseffecten' 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 select persoon.*,film_medewerker.isLeading, film_medewerker.role from film_medewerker,filmfunctie,persoon LEFT JOIN personRating ON persoon.ID=personRating.personID where film_medewerker.filmID = '35787' and filmfunctie.taak = 'productie' 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 SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='213491'select persoon.*, film_medewerker.role, filmfunctie.ID AS functieID from film_medewerker,filmfunctie,persoon LEFT JOIN personRating ON persoon.ID=personRating.personID where film_medewerker.filmID = '35787' and film_medewerker.persoonID = persoon.ID and film_medewerker.isLeading = 'Y' GROUP BY persoon.ID order by personRating.rating DESC, persoon.achternaam select persoon.*,film_medewerker.isLeading, film_medewerker.role from film_medewerker,filmfunctie,persoon LEFT JOIN personRating ON persoon.ID=personRating.personID where film_medewerker.filmID = '35787' 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,5SELECT f.still6ID AS ID,f.ID AS filmID FROM film AS f, still_image_persoon AS sip WHERE sip.persoonID='4085' AND sip.still_imageID=f.still6ID AND f.ID='35787'SELECT f.still6ID AS ID,f.ID AS filmID,f.titel AS film FROM film AS f, still_image_persoon AS sip WHERE sip.persoonID='4085' AND sip.still_imageID=f.still6ID ORDER BY f.premieredatum DESC, f.ID DESC LIMIT 1SELECT f.still6ID AS ID,f.ID AS filmID FROM film AS f, still_image_persoon AS sip WHERE sip.persoonID='74621' AND sip.still_imageID=f.still6ID AND f.ID='35787'SELECT f.still6ID AS ID,f.ID AS filmID,f.titel AS film FROM film AS f, still_image_persoon AS sip WHERE sip.persoonID='74621' AND sip.still_imageID=f.still6ID ORDER BY f.premieredatum DESC, f.ID DESC LIMIT 1SELECT f.still6ID AS ID,f.ID AS filmID FROM film AS f, still_image_persoon AS sip WHERE sip.persoonID='5519' AND sip.still_imageID=f.still6ID AND f.ID='35787'SELECT f.still6ID AS ID,f.ID AS filmID,f.titel AS film FROM film AS f, still_image_persoon AS sip WHERE sip.persoonID='5519' AND sip.still_imageID=f.still6ID ORDER BY f.premieredatum DESC, f.ID DESC LIMIT 1SELECT f.still6ID AS ID,f.ID AS filmID FROM film AS f, still_image_persoon AS sip WHERE sip.persoonID='46495' AND sip.still_imageID=f.still6ID AND f.ID='35787'SELECT f.still6ID AS ID,f.ID AS filmID,f.titel AS film FROM film AS f, still_image_persoon AS sip WHERE sip.persoonID='46495' AND sip.still_imageID=f.still6ID ORDER BY f.premieredatum DESC, f.ID DESC LIMIT 1SELECT f.still6ID AS ID,f.ID AS filmID FROM film AS f, still_image_persoon AS sip WHERE sip.persoonID='31509' AND sip.still_imageID=f.still6ID AND f.ID='35787'SELECT f.still6ID AS ID,f.ID AS filmID,f.titel AS film FROM film AS f, still_image_persoon AS sip WHERE sip.persoonID='31509' AND sip.still_imageID=f.still6ID ORDER BY f.premieredatum DESC, f.ID DESC LIMIT 1select persoon.*,film_medewerker.isLeading, film_medewerker.role from film_medewerker,filmfunctie,persoon LEFT JOIN personRating ON persoon.ID=personRating.personID where film_medewerker.filmID = '35787' and filmfunctie.taak = 'regie' 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,2SELECT f.still6ID AS ID,f.ID AS filmID FROM film AS f, still_image_persoon AS sip WHERE sip.persoonID='8140' AND sip.still_imageID=f.still6ID AND f.ID='35787'SELECT f.still6ID AS ID,f.ID AS filmID,f.titel AS film FROM film AS f, still_image_persoon AS sip WHERE sip.persoonID='8140' AND sip.still_imageID=f.still6ID ORDER BY f.premieredatum DESC, f.ID DESC LIMIT 1select persoon.*,film_medewerker.isLeading, film_medewerker.role from film_medewerker,filmfunctie,persoon LEFT JOIN personRating ON persoon.ID=personRating.personID where film_medewerker.filmID = '35787' and filmfunctie.taak = 'scenario' 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,2SELECT f.still6ID AS ID,f.ID AS filmID FROM film AS f, still_image_persoon AS sip WHERE sip.persoonID='8140' AND sip.still_imageID=f.still6ID AND f.ID='35787'SELECT f.still6ID AS ID,f.ID AS filmID,f.titel AS film FROM film AS f, still_image_persoon AS sip WHERE sip.persoonID='8140' AND sip.still_imageID=f.still6ID ORDER BY f.premieredatum DESC, f.ID DESC LIMIT 1SELECT f.still6ID AS ID,f.ID AS filmID FROM film AS f, still_image_persoon AS sip WHERE sip.persoonID='259875' AND sip.still_imageID=f.still6ID AND f.ID='35787'SELECT f.still6ID AS ID,f.ID AS filmID,f.titel AS film FROM film AS f, still_image_persoon AS sip WHERE sip.persoonID='259875' AND sip.still_imageID=f.still6ID ORDER BY f.premieredatum DESC, f.ID DESC LIMIT 1select persoon.*,film_medewerker.isLeading, film_medewerker.role from film_medewerker,filmfunctie,persoon LEFT JOIN personRating ON persoon.ID=personRating.personID where film_medewerker.filmID = '35787' and filmfunctie.taak = 'muziek' 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,2SELECT f.still6ID AS ID,f.ID AS filmID FROM film AS f, still_image_persoon AS sip WHERE sip.persoonID='301222' AND sip.still_imageID=f.still6ID AND f.ID='35787'SELECT f.still6ID AS ID,f.ID AS filmID,f.titel AS film FROM film AS f, still_image_persoon AS sip WHERE sip.persoonID='301222' AND sip.still_imageID=f.still6ID ORDER BY f.premieredatum DESC, f.ID DESC LIMIT 1SELECT * FROM site_film WHERE siteID=159 AND filmID='35787'SELECT * FROM site_film WHERE siteID='241' AND filmID='35787'SELECT * FROM film_filmstreamservice WHERE `filmstreamserviceID`=7 AND filmID='35787'SELECT * FROM film_filmstreamservice WHERE `filmstreamserviceID`=1 AND filmID='35787' AND (till='0000-00-00' OR till>=now())SELECT * FROM film_filmstreamservice WHERE `filmstreamserviceID`=4 AND filmID='35787' AND (till='0000-00-00' OR till>=now())SELECT * FROM film_filmstreamservice WHERE `filmstreamserviceID`=5 AND filmID='35787' AND (till='0000-00-00' OR till>=now())SELECT * FROM film_filmstreamservice WHERE `filmstreamserviceID`=2 AND filmID='35787' AND (till='0000-00-00' OR till>=now())SELECT 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 n.* FROM nieuws AS n WHERE n.nieuws_typeID='2' AND n.embargodatum <= now() ORDER BY n.embargodatum DESC, update_tijd DESC LIMIT 0,9SELECT * FROM `nieuws` WHERE `ID`='9892'SELECT * from nieuws_type WHERE ID = '2'SELECT * FROM `nieuws` WHERE `ID`='9890'SELECT * from nieuws_type WHERE ID = '2'select ID,titel from film where titel like 'VERLIEFD OP CURA%%AO' order by LENGTH(titel) ascSELECT * FROM `nieuws` WHERE `ID`='9886'SELECT * from nieuws_type WHERE ID = '2'select ID,titel from film where titel like 'Final Destination Bloodlines' order by LENGTH(titel) ascselect ID,titel from film where titel like 'Thunderbolts%' order by LENGTH(titel) asc