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`='27375'SELECT ID, titel FROM film WHERE originelefilmID='27375'SELECT * FROM mening WHERE filmID='27375' 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 = '27375' 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 = '27375' 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 = '27375' order by urlSELECT n.*,l.main,l.filmID AS linkedID FROM nieuws_film AS l,nieuws AS n WHERE l.filmID='27375' 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='27375' AND tv.TVchannelID=ch.ID SELECT s.ID,s.naam AS stad, s.landID FROM filmvoorstelling AS a, stad AS s WHERE (a.filmID='27375') 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='27375' AND tv.TVchannelID=ch.ID SELECT n.*,nf.filmID FROM nieuws AS n, nieuws_film AS nf WHERE (nf.filmID='27375') 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='27375') 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 = '27375' 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='14552'SELECT f.still6ID AS ID,f.ID AS filmID FROM film AS f, still_image_persoon AS sip WHERE sip.persoonID='14552' AND sip.still_imageID=f.still6ID AND f.ID='27375'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='14552' 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 = '27375' 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='25661'SELECT f.still6ID AS ID,f.ID AS filmID FROM film AS f, still_image_persoon AS sip WHERE sip.persoonID='25661' AND sip.still_imageID=f.still6ID AND f.ID='27375'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='25661' 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='16894'SELECT f.still6ID AS ID,f.ID AS filmID FROM film AS f, still_image_persoon AS sip WHERE sip.persoonID='16894' AND sip.still_imageID=f.still6ID AND f.ID='27375'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='16894' 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='45256'SELECT f.still6ID AS ID,f.ID AS filmID FROM film AS f, still_image_persoon AS sip WHERE sip.persoonID='45256' AND sip.still_imageID=f.still6ID AND f.ID='27375'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='45256' 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='14559'SELECT f.still6ID AS ID,f.ID AS filmID FROM film AS f, still_image_persoon AS sip WHERE sip.persoonID='14559' AND sip.still_imageID=f.still6ID AND f.ID='27375'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='14559' 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='103111'SELECT f.still6ID AS ID,f.ID AS filmID FROM film AS f, still_image_persoon AS sip WHERE sip.persoonID='103111' AND sip.still_imageID=f.still6ID AND f.ID='27375'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='103111' 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='103106'SELECT f.still6ID AS ID,f.ID AS filmID FROM film AS f, still_image_persoon AS sip WHERE sip.persoonID='103106' AND sip.still_imageID=f.still6ID AND f.ID='27375'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='103106' 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='103113'SELECT f.still6ID AS ID,f.ID AS filmID FROM film AS f, still_image_persoon AS sip WHERE sip.persoonID='103113' AND sip.still_imageID=f.still6ID AND f.ID='27375'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='103113' 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='123890'SELECT f.still6ID AS ID,f.ID AS filmID FROM film AS f, still_image_persoon AS sip WHERE sip.persoonID='123890' AND sip.still_imageID=f.still6ID AND f.ID='27375'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='123890' 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='102630'SELECT f.still6ID AS ID,f.ID AS filmID FROM film AS f, still_image_persoon AS sip WHERE sip.persoonID='102630' AND sip.still_imageID=f.still6ID AND f.ID='27375'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='102630' 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='204709'SELECT f.still6ID AS ID,f.ID AS filmID FROM film AS f, still_image_persoon AS sip WHERE sip.persoonID='204709' AND sip.still_imageID=f.still6ID AND f.ID='27375'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='204709' 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='191821'SELECT f.still6ID AS ID,f.ID AS filmID FROM film AS f, still_image_persoon AS sip WHERE sip.persoonID='191821' AND sip.still_imageID=f.still6ID AND f.ID='27375'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='191821' 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='204714'SELECT f.still6ID AS ID,f.ID AS filmID FROM film AS f, still_image_persoon AS sip WHERE sip.persoonID='204714' AND sip.still_imageID=f.still6ID AND f.ID='27375'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='204714' 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 = '27375' 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 * FROM ban_theA WHERE ban_table='persoon' AND banID='204728'SELECT f.still6ID AS ID,f.ID AS filmID FROM film AS f, still_image_persoon AS sip WHERE sip.persoonID='204728' AND sip.still_imageID=f.still6ID AND f.ID='27375'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='204728' 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 = '27375' 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='204720'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='204704'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='204713'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='204708'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='204718'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='204705'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='204721'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='204703'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='204710'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='204724'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='204716'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='204711'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='204719'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='204715'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='204706'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='204712'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='204723'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='204717'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='204725'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='204722'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='45263'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='204707'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 = '27375' 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 = '27375' 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='14553'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 = '27375' 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='3771'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='204726'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 = '27375' 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='204727'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='14555'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 = '27375' 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 persoon.*,film_medewerker.isLeading, film_medewerker.role from film_medewerker,filmfunctie,persoon LEFT JOIN personRating ON persoon.ID=personRating.personID where film_medewerker.filmID = '27375' 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 persoon.*,film_medewerker.isLeading, film_medewerker.role from film_medewerker,filmfunctie,persoon LEFT JOIN personRating ON persoon.ID=personRating.personID where film_medewerker.filmID = '27375' 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='14554'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 = '27375' 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 persoon.*,film_medewerker.isLeading, film_medewerker.role from film_medewerker,filmfunctie,persoon LEFT JOIN personRating ON persoon.ID=personRating.personID where film_medewerker.filmID = '27375' 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 = '27375' 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 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 = '27375' 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 = '27375' 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='25661' AND sip.still_imageID=f.still6ID AND f.ID='27375'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='25661' 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='16894' AND sip.still_imageID=f.still6ID AND f.ID='27375'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='16894' 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='45256' AND sip.still_imageID=f.still6ID AND f.ID='27375'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='45256' 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='14559' AND sip.still_imageID=f.still6ID AND f.ID='27375'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='14559' 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='103111' AND sip.still_imageID=f.still6ID AND f.ID='27375'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='103111' 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 = '27375' 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='14552' AND sip.still_imageID=f.still6ID AND f.ID='27375'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='14552' 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 = '27375' 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='14553' AND sip.still_imageID=f.still6ID AND f.ID='27375'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='14553' 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='14552' AND sip.still_imageID=f.still6ID AND f.ID='27375'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='14552' 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 = '27375' 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='14554' AND sip.still_imageID=f.still6ID AND f.ID='27375'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='14554' AND sip.still_imageID=f.still6ID ORDER BY f.premieredatum DESC, f.ID DESC LIMIT 1SELECT 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