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`='8234'SELECT ID, titel FROM film WHERE originelefilmID='8234'SELECT ID,url,onderschrift,verhouding,lokale_url,update_tijd,width,height,type FROM image WHERE ID='5686' AND width>0 AND height>0SELECT * FROM mening WHERE filmID='8234' ORDER BY tijd DESCselect ID,titel from film where titel like 'Play Misty for Me' order by LENGTH(titel) ascselect ID,titel from film where titel like 'The Outlaw Josey Wales' order by LENGTH(titel) ascselect ID,titel from film where titel like 'Bird' order by LENGTH(titel) ascselect ID,titel from film where titel like 'The Rookie' order by LENGTH(titel) ascselect ID,voornaam,achternaam from persoon where TRIM(CONCAT(voornaam,' ',achternaam)) like 'The Rookie' ORDER BY ID descselect ID,naam from bioscoop where naam like 'The Rookie' ORDER BY ID descselect ID,titel from nieuws where titel like 'The Rookie' ORDER BY ID descselect ID,naam from stad where naam like 'The Rookie' ORDER BY ID descselect ID,titel from film where titel like 'Unforgiven' order by LENGTH(titel) ascselect ID,titel from film where titel like 'Space Cowboys' order by LENGTH(titel) ascSELECT p.* FROM still_image_persoon AS si, persoon AS p WHERE si.still_imageID='47' 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='47' 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='48' 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='48' 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='49' 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='49' 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='50' 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='50' AND p.ID=si.persoonID ORDER BY si.place,p.achternaamselect * from filmrecensie where filmID = '8234' order by urlSELECT n.*,l.main,l.filmID AS linkedID FROM nieuws_film AS l,nieuws AS n
WHERE l.filmID='8234' 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='8234' AND tv.TVchannelID=ch.ID SELECT s.ID,s.naam AS stad, s.landID
FROM filmvoorstelling AS a, stad AS s
WHERE (a.filmID='8234') 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='8234' AND tv.TVchannelID=ch.ID SELECT n.*,nf.filmID FROM nieuws AS n, nieuws_film AS nf
WHERE (nf.filmID='8234') 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='8234') 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 = '8234' order by urlSELECT tv.*, ch.title AS channel FROM tvagenda AS tv, tvchannel AS ch WHERE
tv.`date`>=CURRENT_DATE() AND tv.filmID='8234' 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 = '8234' 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='927'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='8472' 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='927' AND sip.still_imageID=f.still6ID AND f.ID='8234'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='927' 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 = '8234' 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='1028'SELECT f.still6ID AS ID,f.ID AS filmID FROM film AS f, still_image_persoon AS sip WHERE
sip.persoonID='1028' AND sip.still_imageID=f.still6ID AND f.ID='8234'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='1028' 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='2449'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='7375' 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='2449' AND sip.still_imageID=f.still6ID AND f.ID='8234'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='2449' 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='1903'SELECT f.still6ID AS ID,f.ID AS filmID FROM film AS f, still_image_persoon AS sip WHERE
sip.persoonID='1903' AND sip.still_imageID=f.still6ID AND f.ID='8234'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='1903' 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='8234'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='153'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='6741' 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='153' AND sip.still_imageID=f.still6ID AND f.ID='8234'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='153' 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='47656'SELECT f.still6ID AS ID,f.ID AS filmID FROM film AS f, still_image_persoon AS sip WHERE
sip.persoonID='47656' AND sip.still_imageID=f.still6ID AND f.ID='8234'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='47656' 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='87610'SELECT f.still6ID AS ID,f.ID AS filmID FROM film AS f, still_image_persoon AS sip WHERE
sip.persoonID='87610' AND sip.still_imageID=f.still6ID AND f.ID='8234'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='87610' 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='54691'SELECT f.still6ID AS ID,f.ID AS filmID FROM film AS f, still_image_persoon AS sip WHERE
sip.persoonID='54691' AND sip.still_imageID=f.still6ID AND f.ID='8234'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='54691' 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='47657'SELECT f.still6ID AS ID,f.ID AS filmID FROM film AS f, still_image_persoon AS sip WHERE
sip.persoonID='47657' AND sip.still_imageID=f.still6ID AND f.ID='8234'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='47657' 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='161898'SELECT f.still6ID AS ID,f.ID AS filmID FROM film AS f, still_image_persoon AS sip WHERE
sip.persoonID='161898' AND sip.still_imageID=f.still6ID AND f.ID='8234'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='161898' 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='80370'SELECT f.still6ID AS ID,f.ID AS filmID FROM film AS f, still_image_persoon AS sip WHERE
sip.persoonID='80370' AND sip.still_imageID=f.still6ID AND f.ID='8234'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='80370' 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='95833'SELECT f.still6ID AS ID,f.ID AS filmID FROM film AS f, still_image_persoon AS sip WHERE
sip.persoonID='95833' AND sip.still_imageID=f.still6ID AND f.ID='8234'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='95833' 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 = '8234' 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='81348'SELECT f.still6ID AS ID,f.ID AS filmID FROM film AS f, still_image_persoon AS sip WHERE
sip.persoonID='81348' AND sip.still_imageID=f.still6ID AND f.ID='8234'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='81348' 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 = '8234' 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='161941'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='83832'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='56812'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='25565'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='47658'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='45939'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='87636'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='94016'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='101239'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='53995'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='108279'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='90707'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='121865'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='103243'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='115408'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='97679'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='112276'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='25564'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='61202'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='133272'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='108260'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='149113'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='95852'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='124683'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='94283'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='133289'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='87650'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='94014'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='131525'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='131516'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='173186'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='187654'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='187646'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='187648'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='187655'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='187660'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='187651'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='187661'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='187650'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='187662'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='187663'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='187665'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='187664'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='187647'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='187666'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='187645'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='187667'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='187668'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='187644'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='187658'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='187669'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='187670'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='187659'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='187652'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='187656'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='187649'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='187653'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='187657'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 = '8234' 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 = '8234' 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='1399'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='47661'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 = '8234' 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='33120'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 = '8234' 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='3879'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 = '8234' 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='10557'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 = '8234' 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='33121'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 = '8234' 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 persoon.*,film_medewerker.isLeading, film_medewerker.role from film_medewerker,filmfunctie,persoon LEFT JOIN personRating ON persoon.ID=personRating.personID
where film_medewerker.filmID = '8234' 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='3881'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='3607'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='88529'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='94894'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='14908'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='39265'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='131192'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='88285'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='16547'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='16174'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='15153'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='83202'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 = '8234' 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 = '8234' 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='47659'SELECT * FROM ban_theA WHERE ban_table='persoon' AND banID='47660'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 = '8234' 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 = '8234' 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='1028' AND sip.still_imageID=f.still6ID AND f.ID='8234'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='1028' 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='2449' AND sip.still_imageID=f.still6ID AND f.ID='8234'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='2449' 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='1903' AND sip.still_imageID=f.still6ID AND f.ID='8234'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='1903' 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='2682' AND sip.still_imageID=f.still6ID AND f.ID='8234'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 f.still6ID AS ID,f.ID AS filmID FROM film AS f, still_image_persoon AS sip WHERE
sip.persoonID='153' AND sip.still_imageID=f.still6ID AND f.ID='8234'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='153' 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 = '8234' 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='927' AND sip.still_imageID=f.still6ID AND f.ID='8234'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='927' 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 = '8234' 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='1399' AND sip.still_imageID=f.still6ID AND f.ID='8234'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='1399' 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='47661' AND sip.still_imageID=f.still6ID AND f.ID='8234'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='47661' 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 = '8234' 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='927' AND sip.still_imageID=f.still6ID AND f.ID='8234'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='927' 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
De jeugdvrienden Jimmy Marcus (Penn), Sean Devine en Dave Boyle komen na jaren weer samen omdat de oudste dochter van Jimmy is overleden. Jimmy zit bij de politie en is met een zaak bezig, waarbij de opgekropte woede - die hij bij zich draagt in verband met het overlijden van zijn dochter - naar boven komt.
Eastwood heeft veel tijd nodig om te laten zien hoe de drie door het noodlot een fatale confrontatie aangaan, en daardoor is de film aan de trage kant. Maar tot het einde toe blijft de dreiging voelbaar (...).
Wil je Mystic River zien? Koop of huur de film hier:
Een politieagent moet de dood van zijn dochter verwerken. Met Sean Penn, Laurence Fishburne, Kevin Bacon. Regie: Clint Eastwood.
Meer films online, op DVD / BR
Synopsis distributeur
Productiemaatschappij:Cinergia, Fox-Warner, Malpaso Productions, NPV Entertainment, Sandrew Metronome Distribution, Sandrew Metronome Distribution Sverige AB, Village Roadshow Pictures, Warner Bros.