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`='11869'SELECT ID, titel FROM film WHERE originelefilmID='11869'SELECT ID,url,onderschrift,verhouding,lokale_url,update_tijd,width,height,type FROM image WHERE ID='8427' AND width>0 AND height>0SELECT * FROM mening WHERE filmID='11869' ORDER BY tijd DESCselect ID,titel from film where titel like 'Gattaca' order by LENGTH(titel) ascselect ID,titel from film where titel like 'S1m0ne' order by LENGTH(titel) ascselect ID,titel from film where titel like 'The Terminal' order by LENGTH(titel) ascselect ID,titel from film where titel like 'The Truman Show' order by LENGTH(titel) ascSELECT p.* FROM still_image_persoon AS si, persoon AS p WHERE si.still_imageID='2088' AND p.ID=si.persoonID ORDER BY si.place,p.achternaamSELECT p.* FROM still_image_persoon AS si, persoon AS p WHERE si.still_imageID='2088' AND p.ID=si.persoonID ORDER BY si.place,p.achternaamSELECT p.* FROM still_image_persoon AS si, persoon AS p WHERE si.still_imageID='2089' AND p.ID=si.persoonID ORDER BY si.place,p.achternaamSELECT p.* FROM still_image_persoon AS si, persoon AS p WHERE si.still_imageID='2089' AND p.ID=si.persoonID ORDER BY si.place,p.achternaamSELECT p.* FROM still_image_persoon AS si, persoon AS p WHERE si.still_imageID='2090' AND p.ID=si.persoonID ORDER BY si.place,p.achternaamSELECT `role` FROM film_medewerker WHERE filmID='11869' AND persoonID='467' AND `role`!=''SELECT `role` FROM film_medewerker WHERE filmID='11869' AND persoonID='1859' AND `role`!=''SELECT p.* FROM still_image_persoon AS si, persoon AS p WHERE si.still_imageID='2090' AND p.ID=si.persoonID ORDER BY si.place,p.achternaamSELECT `role` FROM film_medewerker WHERE filmID='11869' AND persoonID='467' AND `role`!=''SELECT `role` FROM film_medewerker WHERE filmID='11869' AND persoonID='1859' AND `role`!=''SELECT p.* FROM still_image_persoon AS si, persoon AS p WHERE si.still_imageID='2091' AND p.ID=si.persoonID ORDER BY si.place,p.achternaamSELECT p.* FROM still_image_persoon AS si, persoon AS p WHERE si.still_imageID='2091' AND p.ID=si.persoonID ORDER BY si.place,p.achternaamselect * from filmrecensie where filmID = '11869' order by urlSELECT n.*,l.main,l.filmID AS linkedID FROM nieuws_film AS l,nieuws AS n WHERE l.filmID='11869' 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='11869' AND tv.TVchannelID=ch.ID SELECT s.ID,s.naam AS stad, s.landID FROM filmvoorstelling AS a, stad AS s WHERE (a.filmID='11869') 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='11869' AND tv.TVchannelID=ch.ID SELECT n.*,nf.filmID FROM nieuws AS n, nieuws_film AS nf WHERE (nf.filmID='11869') 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='11869') AND l.main='Y' AND n.ID=l.nieuwsID AND n.nieuws_typeID=4 AND n.embargodatum<=now() ORDER BY n.embargodatum DESCselect * from filmrecensie where filmID = '11869' order by urlSELECT tv.*, ch.title AS channel FROM tvagenda AS tv, tvchannel AS ch WHERE tv.`date`>=CURRENT_DATE() AND tv.filmID='11869' AND tv.TVchannelID=ch.ID 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 = '11869' 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='9368'SELECT f.still6ID AS ID,f.ID AS filmID FROM film AS f, still_image_persoon AS sip WHERE sip.persoonID='9368' AND sip.still_imageID=f.still6ID AND f.ID='11869'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='9368' 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 = '11869' 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='467'SELECT i.ID,i.title,i.type,i.width,i.height,i.credits,i.description,i.URL FROM image_link AS l,the_image AS i WHERE l.elementID='4161' AND l.element_table='person' AND l.medium='PC' AND i.ID=l.imageID AND i.copyrightChecked=1 AND i.width>0 AND i.height>0 ORDER BY i.updated DESCSELECT f.still6ID AS ID,f.ID AS filmID FROM film AS f, still_image_persoon AS sip WHERE sip.persoonID='467' AND sip.still_imageID=f.still6ID AND f.ID='11869'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='467' 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='7071'SELECT i.ID,i.title,i.type,i.width,i.height,i.credits,i.description,i.URL FROM image_link AS l,the_image AS i WHERE l.elementID='15313' AND l.element_table='person' AND l.medium='PC' AND i.ID=l.imageID AND i.copyrightChecked=1 AND i.width>0 AND i.height>0 ORDER BY i.updated DESCSELECT f.still6ID AS ID,f.ID AS filmID FROM film AS f, still_image_persoon AS sip WHERE sip.persoonID='7071' AND sip.still_imageID=f.still6ID AND f.ID='11869'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='7071' 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='1465'SELECT i.ID,i.title,i.type,i.width,i.height,i.credits,i.description,i.URL FROM image_link AS l,the_image AS i WHERE l.elementID='8921' AND l.element_table='person' AND l.medium='PC' AND i.ID=l.imageID AND i.copyrightChecked=1 AND i.width>0 AND i.height>0 ORDER BY i.updated DESCSELECT f.still6ID AS ID,f.ID AS filmID FROM film AS f, still_image_persoon AS sip WHERE sip.persoonID='1465' AND sip.still_imageID=f.still6ID AND f.ID='11869'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='1465' 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='1859'SELECT i.ID,i.title,i.type,i.width,i.height,i.credits,i.description,i.URL FROM image_link AS l,the_image AS i WHERE l.elementID='5576' AND l.element_table='person' AND l.medium='PC' AND i.ID=l.imageID AND i.copyrightChecked=1 AND i.width>0 AND i.height>0 ORDER BY i.updated DESCSELECT f.still6ID AS ID,f.ID AS filmID FROM film AS f, still_image_persoon AS sip WHERE sip.persoonID='1859' AND sip.still_imageID=f.still6ID AND f.ID='11869'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='1859' 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='13729'SELECT f.still6ID AS ID,f.ID AS filmID FROM film AS f, still_image_persoon AS sip WHERE sip.persoonID='13729' AND sip.still_imageID=f.still6ID AND f.ID='11869'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='13729' 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='3690'SELECT f.still6ID AS ID,f.ID AS filmID FROM film AS f, still_image_persoon AS sip WHERE sip.persoonID='3690' AND sip.still_imageID=f.still6ID AND f.ID='11869'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='3690' 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='66221'SELECT f.still6ID AS ID,f.ID AS filmID FROM film AS f, still_image_persoon AS sip WHERE sip.persoonID='66221' AND sip.still_imageID=f.still6ID AND f.ID='11869'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='66221' 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='66222'SELECT f.still6ID AS ID,f.ID AS filmID FROM film AS f, still_image_persoon AS sip WHERE sip.persoonID='66222' AND sip.still_imageID=f.still6ID AND f.ID='11869'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='66222' 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 = '11869' 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 = '11869' 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 persoon.*,film_medewerker.isLeading, film_medewerker.role from film_medewerker,filmfunctie,persoon LEFT JOIN personRating ON persoon.ID=personRating.personID where film_medewerker.filmID = '11869' 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 = '11869' 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 persoon.*,film_medewerker.isLeading, film_medewerker.role from film_medewerker,filmfunctie,persoon LEFT JOIN personRating ON persoon.ID=personRating.personID where film_medewerker.filmID = '11869' 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='53447'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 = '11869' 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='3011'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 = '11869' 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='32019'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 = '11869' 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='22664'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 = '11869' 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='36794'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 = '11869' 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 = '11869' 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 = '11869' 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='66223'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='66224'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='66225'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='66226'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 = '11869' 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 = '11869' 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='467' AND sip.still_imageID=f.still6ID AND f.ID='11869'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='467' 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='7071' AND sip.still_imageID=f.still6ID AND f.ID='11869'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='7071' 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='1465' AND sip.still_imageID=f.still6ID AND f.ID='11869'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='1465' 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='1859' AND sip.still_imageID=f.still6ID AND f.ID='11869'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='1859' 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='13729' AND sip.still_imageID=f.still6ID AND f.ID='11869'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='13729' 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 = '11869' 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='9368' AND sip.still_imageID=f.still6ID AND f.ID='11869'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='9368' 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 = '11869' 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='9368' AND sip.still_imageID=f.still6ID AND f.ID='11869'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='9368' 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 = '11869' 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='36794' AND sip.still_imageID=f.still6ID AND f.ID='11869'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='36794' 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 Lord of War (2005) ǀ Bioscoopagenda
compleet & ongebonden sinds 1995
WEEK 22 29-5 t/m 4-6
Film van de week!
MENU

Lord of War

***1/20
Waardering: 3.8/5
Mogelijk schadelijk tot 16 jaarGeweldSeksGrof taalgebruikDiscriminatie

Pitch van Lord of War

Nicholas Cage als de wapenhandelaar Yuri Orlov

Nicholas Cage als de wapenhandelaar Yuri Orlov

Delen op facebook
Lord of War
Nederlandse première: 3-11-2005
Verenigde Staten, 2005, 122 min,

Wapenhandelaar Yuri Orlov wordt achterna gezeten door Interpolagent Jack Valentine. Orlov wordt geconfronteerd met de a-morele kanten van zijn werk.

bijzonderheden

Er werd met echte wapenhandelaars samengewerkt voor de totstandkoming van de film. De tanks uit de film werden later doorverkocht aan een ander land. De stapel échte AK-47's was goedkoper dan een stapel nep-geweren.

We hebben na 25 jaar helaas je hulp nodig!

Dank voor je hulp.

Aanloop

Andrew Niccol regisseerde eerder Gattaca (1997) en S1m0ne (2002). Hij schreef de scripts van The Terminal (2004) en The Truman Show (1998).

Lord of War - Bioscopen, Tijden & Tickets

Lord of War in de bioscoop

Wil je Lord of War zien? Koop of huur de film hier:


videoland NETFLIX Amazon Prime Video

Wapenhandelaar Yuri Orlov wordt achterna gezeten door Interpolagent Jack Valentine. Orlov wordt geconfronteerd met de a-morele kanten van zijn werk.



Meer films online, op DVD / BR


Disney+

Amazon Prime Video

Films en seriesFilms en series

Cast & Regisseur

Nicolas Cage

Yuri Orlov
Ethan Hawke

Jack Valentine
Ian Holm

Simeon Weisz
Jared Leto

Vitaly Orlov
Bridget Moynahan

Ava Fontaine Orlov
Andrew Niccol

Regisseur