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`='18122'SELECT ID, titel FROM film WHERE originelefilmID='18122'SELECT ID,url,onderschrift,verhouding,lokale_url,update_tijd,width,height,type FROM image WHERE ID='16578' AND width>0 AND height>0SELECT * FROM mening WHERE filmID='18122' OR filmID='22204' ORDER BY tijd DESCselect ID,titel from film where titel like 'Ryan Reynolds' order by LENGTH(titel) ascselect ID,voornaam,achternaam from persoon where TRIM(CONCAT(voornaam,' ',achternaam)) like 'Ryan Reynolds' ORDER BY ID descselect ID,titel from film where titel like 'Van Wilder' order by LENGTH(titel) ascselect ID,titel from film where titel like 'Buried' order by LENGTH(titel) ascselect ID,titel from film where titel like 'The Green Hornet' order by LENGTH(titel) ascSELECT p.* FROM still_image_persoon AS si, persoon AS p WHERE si.still_imageID='9698' AND p.ID=si.persoonID ORDER BY si.place,p.achternaamSELECT `role` FROM film_medewerker WHERE filmID='18122' AND persoonID='65230' AND `role`!=''SELECT `role` FROM film_medewerker WHERE filmID='18122' AND persoonID='26435' AND `role`!=''SELECT p.* FROM still_image_persoon AS si, persoon AS p WHERE si.still_imageID='9698' AND p.ID=si.persoonID ORDER BY si.place,p.achternaamSELECT `role` FROM film_medewerker WHERE filmID='18122' AND persoonID='65230' AND `role`!=''SELECT `role` FROM film_medewerker WHERE filmID='18122' AND persoonID='26435' AND `role`!=''SELECT p.* FROM still_image_persoon AS si, persoon AS p WHERE si.still_imageID='9699' AND p.ID=si.persoonID ORDER BY si.place,p.achternaamSELECT `role` FROM film_medewerker WHERE filmID='18122' AND persoonID='65230' AND `role`!=''SELECT p.* FROM still_image_persoon AS si, persoon AS p WHERE si.still_imageID='9699' AND p.ID=si.persoonID ORDER BY si.place,p.achternaamSELECT `role` FROM film_medewerker WHERE filmID='18122' AND persoonID='65230' AND `role`!=''SELECT p.* FROM still_image_persoon AS si, persoon AS p WHERE si.still_imageID='9700' AND p.ID=si.persoonID ORDER BY si.place,p.achternaamSELECT `role` FROM film_medewerker WHERE filmID='18122' AND persoonID='26435' AND `role`!=''SELECT `role` FROM film_medewerker WHERE filmID='18122' AND persoonID='65230' AND `role`!=''SELECT p.* FROM still_image_persoon AS si, persoon AS p WHERE si.still_imageID='9700' AND p.ID=si.persoonID ORDER BY si.place,p.achternaamSELECT `role` FROM film_medewerker WHERE filmID='18122' AND persoonID='26435' AND `role`!=''SELECT `role` FROM film_medewerker WHERE filmID='18122' AND persoonID='65230' AND `role`!=''SELECT p.* FROM still_image_persoon AS si, persoon AS p WHERE si.still_imageID='9701' AND p.ID=si.persoonID ORDER BY si.place,p.achternaamSELECT `role` FROM film_medewerker WHERE filmID='18122' AND persoonID='26435' AND `role`!=''SELECT p.* FROM still_image_persoon AS si, persoon AS p WHERE si.still_imageID='9701' AND p.ID=si.persoonID ORDER BY si.place,p.achternaamSELECT `role` FROM film_medewerker WHERE filmID='18122' AND persoonID='26435' AND `role`!=''select * from filmrecensie where filmID = '18122' order by urlSELECT n.*,l.main,l.filmID AS linkedID FROM nieuws_film AS l,nieuws AS n WHERE l.filmID='18122' 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 n.*,l.main,l.filmID AS linkedID FROM nieuws_film AS l,nieuws AS n WHERE l.filmID='22204' 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='18122' AND tv.TVchannelID=ch.ID SELECT s.ID,s.naam AS stad, s.landID FROM filmvoorstelling AS a, stad AS s WHERE (a.filmID='18122' OR a.filmID='22204') 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='18122' AND tv.TVchannelID=ch.ID SELECT n.*,nf.filmID FROM nieuws AS n, nieuws_film AS nf WHERE (nf.filmID='18122' OR nf.filmID='22204') 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='18122' OR l.filmID='22204') 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 = '18122' order by urlSELECT tv.*, ch.title AS channel FROM tvagenda AS tv, tvchannel AS ch WHERE tv.`date`>=CURRENT_DATE() AND tv.filmID='18122' AND tv.TVchannelID=ch.ID SELECT * FROM film_filmstreamservice WHERE `filmstreamserviceID`=7 AND filmID='18122'SELECT * FROM site_film WHERE siteID=159 AND filmID='18122'SELECT * FROM site_film WHERE siteID='241' AND filmID='18122'SELECT * FROM film_filmstreamservice WHERE `filmstreamserviceID`=6 AND filmID='18122' AND (till='0000-00-00' OR till>=now())SELECT * FROM film_filmstreamservice WHERE `filmstreamserviceID`=4 AND filmID='18122' AND (till='0000-00-00' OR till>=now())SELECT * FROM film_filmstreamservice WHERE `filmstreamserviceID`=1 AND filmID='18122' AND (till='0000-00-00' OR till>=now())SELECT * FROM film_filmstreamservice WHERE `filmstreamserviceID`=5 AND filmID='18122' AND (till='0000-00-00' OR till>=now())SELECT * FROM film_filmstreamservice WHERE `filmstreamserviceID`=2 AND filmID='18122' AND (till='0000-00-00' OR till>=now())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 = '18122' 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='485'SELECT f.still6ID AS ID,f.ID AS filmID FROM film AS f, still_image_persoon AS sip WHERE sip.persoonID='485' AND sip.still_imageID=f.still6ID AND f.ID='18122'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='485' 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 = '18122' 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='26435'SELECT f.still6ID AS ID,f.ID AS filmID FROM film AS f, still_image_persoon AS sip WHERE sip.persoonID='26435' AND sip.still_imageID=f.still6ID AND f.ID='18122'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='26435' 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='5591'SELECT f.still6ID AS ID,f.ID AS filmID FROM film AS f, still_image_persoon AS sip WHERE sip.persoonID='5591' AND sip.still_imageID=f.still6ID AND f.ID='18122'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='5591' 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='65230'SELECT f.still6ID AS ID,f.ID AS filmID FROM film AS f, still_image_persoon AS sip WHERE sip.persoonID='65230' AND sip.still_imageID=f.still6ID AND f.ID='18122'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='65230' 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='11620'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='11812' 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='11620' AND sip.still_imageID=f.still6ID AND f.ID='18122'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='11620' 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='69511'SELECT f.still6ID AS ID,f.ID AS filmID FROM film AS f, still_image_persoon AS sip WHERE sip.persoonID='69511' AND sip.still_imageID=f.still6ID AND f.ID='18122'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='69511' 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='2682'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='5100' 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='2682' AND sip.still_imageID=f.still6ID AND f.ID='18122'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='2682' 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='142147'SELECT f.still6ID AS ID,f.ID AS filmID FROM film AS f, still_image_persoon AS sip WHERE sip.persoonID='142147' AND sip.still_imageID=f.still6ID AND f.ID='18122'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='142147' 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='214'SELECT f.still6ID AS ID,f.ID AS filmID FROM film AS f, still_image_persoon AS sip WHERE sip.persoonID='214' AND sip.still_imageID=f.still6ID AND f.ID='18122'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='214' 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='149765'SELECT f.still6ID AS ID,f.ID AS filmID FROM film AS f, still_image_persoon AS sip WHERE sip.persoonID='149765' AND sip.still_imageID=f.still6ID AND f.ID='18122'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='149765' 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='104020'SELECT f.still6ID AS ID,f.ID AS filmID FROM film AS f, still_image_persoon AS sip WHERE sip.persoonID='104020' AND sip.still_imageID=f.still6ID AND f.ID='18122'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='104020' 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='128365'SELECT f.still6ID AS ID,f.ID AS filmID FROM film AS f, still_image_persoon AS sip WHERE sip.persoonID='128365' AND sip.still_imageID=f.still6ID AND f.ID='18122'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='128365' 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='74291'SELECT f.still6ID AS ID,f.ID AS filmID FROM film AS f, still_image_persoon AS sip WHERE sip.persoonID='74291' AND sip.still_imageID=f.still6ID AND f.ID='18122'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='74291' 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 = '18122' 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='2747'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='5570' 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='2747' AND sip.still_imageID=f.still6ID AND f.ID='18122'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='2747' 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='6106'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='7351' 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='6106' AND sip.still_imageID=f.still6ID AND f.ID='18122'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='6106' 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='150155'SELECT f.still6ID AS ID,f.ID AS filmID FROM film AS f, still_image_persoon AS sip WHERE sip.persoonID='150155' AND sip.still_imageID=f.still6ID AND f.ID='18122'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='150155' 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 = '18122' 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='80764'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='15577' 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 * FROM ban_theA WHERE ban_table='persoon' AND banID='120941'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='150137'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='115426'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='137701'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='2229'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='4611'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='96630'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='135389'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='113327'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='105996'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='142143'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='91681'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='20359'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='84886'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='140127'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='140128'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='76638'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='149758'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='84691'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='140673'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='105995'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='150148'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='150142'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='150134'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='150144'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='142141'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='150143'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='150141'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='150145'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='150147'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='150149'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='94269'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='128357'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='130116'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='150136'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='150135'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='150151'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='150138'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='150133'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='150139'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='150150'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='150146'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='150140'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='150152'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 = '18122' 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 = '18122' 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='63413'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='1207'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='89018'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='150154'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 = '18122' 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='7249'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 = '18122' 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='161'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 = '18122' 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='14853'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 = '18122' 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='16549'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 = '18122' 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='51386'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 = '18122' 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='16533'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='6547'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='4404'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='150153'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 = '18122' 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 = '18122' 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='15092'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 = '18122' and film_medewerker.persoonID = persoon.ID and film_medewerker.isLeading = 'Y' GROUP BY persoon.ID order by personRating.rating DESC, persoon.achternaam SELECT f.still6ID AS ID,f.ID AS filmID FROM film AS f, still_image_persoon AS sip WHERE sip.persoonID='26435' AND sip.still_imageID=f.still6ID AND f.ID='18122'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='26435' 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='5591' AND sip.still_imageID=f.still6ID AND f.ID='18122'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='5591' 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='65230' AND sip.still_imageID=f.still6ID AND f.ID='18122'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='65230' 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 = '18122' 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='11620' AND sip.still_imageID=f.still6ID AND f.ID='18122'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='11620' 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='69511' AND sip.still_imageID=f.still6ID AND f.ID='18122'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='69511' 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 = '18122' 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='485' AND sip.still_imageID=f.still6ID AND f.ID='18122'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='485' 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 = '18122' 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='63413' AND sip.still_imageID=f.still6ID AND f.ID='18122'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='63413' 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='1207' AND sip.still_imageID=f.still6ID AND f.ID='18122'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='1207' 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 = '18122' 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='51386' AND sip.still_imageID=f.still6ID AND f.ID='18122'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='51386' 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 p.* FROM still_image_persoon AS si, persoon AS p WHERE si.still_imageID='9697' AND p.ID=si.persoonID ORDER BY si.place,p.achternaamSELECT `role` FROM film_medewerker WHERE filmID='18122' AND persoonID='26435' AND `role`!=''SELECT 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 Green Lantern (2011) ǀ Bioscoopagenda
compleet & ongebonden sinds 1995
WEEK 22 29-5 t/m 4-6
Film van de week!
MENU

Green Lantern

***00
Waardering: 3/5
Mogelijk schadelijk tot 12 jaarGeweld

Pitch van Green Lantern

Blake Lively (Carol Ferris) en Ryan Reynolds (Hal Jordan / Green Lantern)

Blake Lively (Carol Ferris) en Ryan Reynolds (Hal Jordan / Green Lantern)

Delen op facebook
Green Lantern
Nederlandse première: 4-8-2011
Verenigde Staten, 2011, 114 min,

Hal Jordan wordt de superheld Green Lantern en wordt daarmee onderdeel van het intergalactische collectief the Green Lantern Corps, dat het opneemt tegen het kwaad in het universum. Hij moet het opnemen tegen Parallax

Bekijk bij:

meJaneAmazon Prime Video

Green Lantern trailer en bijzonderheden

De Green Lantern wordt nog wel eens verward met The Green Hornet. Dit is echter een andere superheld. Ook hij kreeg onlangs zijn eigen film.

Trailer van Green LanternBekijk de trailer en de beste filmstills van de film Green Lanternhttps://i1.ytimg.com/vi/rs2sZgO3OMk/hqdefault.jpg2011-08-04
We hebben na 25 jaar helaas je hulp nodig!

Dank voor je hulp.

Aanloop

Ryan Reynolds is eerder bekend als komisch acteur zoals in de film Van Wilder. Toch zagen we hem in laatst ook in Buried.

Recensies van Green Lantern

Subtop
Als superheld zal Green Lantern zal Spidey en Batman niet van de troon stoten, maar hij verdient zeker een plaats in de superhelden-subtop. En als je tijdens de aftiteling nog even blijft zitten, dan zul je zien dat de eerste voorzet voor een sequel al gegeven wordt.
Waardering: ***1/20 7.5/10
Onevenwichtig
Green Lantern is een tweederangs tussendoortje op weg naar hét Superheldenjaar 2012, waarin Spider-Man, Superman, Batman én alle Avengers in actie komen.
Waardering: **000 4.0/10

Green Lantern - Bioscopen, Tijden & Tickets

Green Lantern in de bioscoop

Wil je Green Lantern zien? Koop of huur de film hier:


meJane Amazon Prime Video

Hal Jordan (Ryan Reynolds) wordt de superheld Green Lantern en wordt daarmee onderdeel van het intergalactische collectief the Green Lantern Corps. Hij moet het opnemen tegen Parallax.



Meer films online, op DVD / BR


Disney+

Amazon Prime Video

Films en seriesFilms en series

Synopsis distributeur

Productiemaatschappij: DC Entertainment, De Line Pictures, Village Films, Warner Bros., Warner Bros. Entertainment, Warner Bros. Pictures

Cast & Regisseur

Ryan Reynolds

Hal Jordan / Green Lantern
Peter Sarsgaard

Hector Hammond
Blake Lively

Carol Ferris
Mark Strong

Sinestro
Elton LeBlanc

College Custodian / Limo Driver / Pedestrian (uncredited)
Martin Campbell

Regisseur
+ LEES MEER
James Newton Howard

Muziek
Green Lantern poster