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 `nieuws` WHERE `ID`='8347'SELECT * from nieuws_type WHERE ID = '1'SELECT d.* from nieuws_dossier AS d, nieuws_nieuws_dossier AS nnd
WHERE nnd.nieuwsID = '8347' AND d.ID=nnd.nieuws_dossierID
GROUP BY d.ID DESC
ORDER BY nnd.main DESCSELECT otherID FROM nieuws_nieuws WHERE nieuwsID='8347' AND main='Y'SELECT * FROM `nieuws` WHERE `ID`='8346'SELECT * from nieuws_type WHERE ID = '1'SELECT ID,url,onderschrift,verhouding,lokale_url,update_tijd,width,height,type FROM image WHERE ID='31422' AND width>0 AND height>0SELECT filmID FROM nieuws_film WHERE nieuwsID='8347' AND main='Y'SELECT * FROM `film` WHERE `ID`='35029'SELECT ID, titel FROM film WHERE originelefilmID='35029'SELECT ID,url,onderschrift,verhouding,lokale_url,update_tijd,width,height,type FROM image WHERE ID='30202' AND width>0 AND height>0SELECT tv.*, ch.title AS channel FROM tvagenda AS tv, tvchannel AS ch WHERE
tv.`date`>=CURRENT_DATE() AND tv.filmID='35029' 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 = '35029' 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 persoon.*,film_medewerker.isLeading, film_medewerker.role from film_medewerker,filmfunctie,persoon LEFT JOIN personRating ON persoon.ID=personRating.personID
where film_medewerker.filmID = '35029' 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,3select persoon.*,film_medewerker.isLeading, film_medewerker.role from film_medewerker,filmfunctie,persoon LEFT JOIN personRating ON persoon.ID=personRating.personID
where film_medewerker.filmID = '35029' 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,3SELECT s.ID,s.naam AS stad, s.landID
FROM filmvoorstelling AS a, stad AS s
WHERE (a.filmID='35029') 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 ID,titel from film where titel like 'Home Alone 2% Lost in New York' order by LENGTH(titel) ascselect ID,titel from film where titel like 'Happiest Season' order by LENGTH(titel) ascselect ID,titel from film where titel like 'Alles is Zoals het Zou Moeten Zijn' order by LENGTH(titel) ascselect ID,titel from film where titel like 'Alles is Zoals het Zou Moeten Zijn' order by LENGTH(titel) ascselect ID,titel from film where titel like 'Unhinged' order by LENGTH(titel) ascselect ID,titel from film where titel like 'Home Alone' order by LENGTH(titel) ascselect ID,titel from film where titel like 'Ava' order by LENGTH(titel) ascselect ID,titel from film where titel like 'Happiest Season' order by LENGTH(titel) ascselect ID,titel from film where titel like 'Home Alone 2% Lost in New York' order by LENGTH(titel) ascselect ID,titel from film where titel like 'Dreamkatcher' order by LENGTH(titel) ascselect ID,titel from film where titel like 'Ghosts of War' order by LENGTH(titel) ascselect ID,titel from film where titel like 'Captive State' order by LENGTH(titel) ascselect ID,titel from film where titel like 'Harry Potter and the Chamber of Secrets' order by LENGTH(titel) ascselect ID,titel from film where titel like 'Alles is Zoals het Zou Moeten Zijn' order by LENGTH(titel) ascselect ID,titel from film where titel like 'Unhinged' order by LENGTH(titel) ascselect ID,titel from film where titel like 'Ava' order by LENGTH(titel) ascselect ID,titel from film where titel like 'Home Alone' order by LENGTH(titel) ascselect ID,titel from film where titel like 'Happiest Season' order by LENGTH(titel) ascselect ID,titel from film where titel like 'Captive State' order by LENGTH(titel) ascselect ID,titel from film where titel like 'Long Shot' order by LENGTH(titel) ascselect ID,titel from film where titel like 'Bohemian Rhapsody' order by LENGTH(titel) ascselect ID,titel from film where titel like 'Dreamkatcher' order by LENGTH(titel) ascselect ID,titel from film where titel like 'Harry Potter and the Philosopher%%s Stone' order by LENGTH(titel) ascSELECT ID,url,onderschrift,verhouding,lokale_url,update_tijd,width,height,type FROM image WHERE ID='31460' AND width>0 AND height>0SELECT ID,url,onderschrift,verhouding,lokale_url,update_tijd,width,height,type FROM image WHERE ID='31460' AND width>0 AND height>0SELECT ID,url,onderschrift,verhouding,lokale_url,update_tijd,width,height,type FROM image WHERE ID='31460' AND width>0 AND height>0SELECT filmID FROM nieuws_film WHERE nieuwsID='8347' AND main!='Y' ORDER BY `row`SELECT persoonID FROM nieuws_persoon WHERE nieuwsID='8347' AND main='Y'SELECT persoonID FROM nieuws_persoon WHERE nieuwsID='8347' AND main!='Y'select * from nieuwslink where nieuwsID = '8347' order by row ASC, urlSELECT n.* FROM nieuws AS n WHERE n.nieuws_typeID='1' AND n.ID!=8347 AND n.embargodatum <= now()
ORDER BY n.embargodatum DESC, update_tijd DESC LIMIT 0,10SELECT * FROM `nieuws` WHERE `ID`='9891'SELECT * from nieuws_type WHERE ID = '1'SELECT * FROM `nieuws` WHERE `ID`='9888'SELECT * from nieuws_type WHERE ID = '1'SELECT * FROM `nieuws` WHERE `ID`='9887'SELECT * from nieuws_type WHERE ID = '1'SELECT * FROM `nieuws` WHERE `ID`='9879'SELECT * from nieuws_type WHERE ID = '1'SELECT * FROM `nieuws` WHERE `ID`='9877'SELECT * from nieuws_type WHERE ID = '1'SELECT * FROM `nieuws` WHERE `ID`='9875'SELECT * from nieuws_type WHERE ID = '1'SELECT * FROM `nieuws` WHERE `ID`='9873'SELECT * from nieuws_type WHERE ID = '1'SELECT * FROM `nieuws` WHERE `ID`='9871'SELECT * from nieuws_type WHERE ID = '1'SELECT * FROM `nieuws` WHERE `ID`='9870'SELECT * from nieuws_type WHERE ID = '1'SELECT * FROM `nieuws` WHERE `ID`='9868'SELECT * from nieuws_type WHERE ID = '1'SELECT 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.ID!=8347 AND n.embargodatum <= now()
ORDER BY n.embargodatum DESC, update_tijd DESC LIMIT 0,7SELECT ID,url,onderschrift,verhouding,lokale_url,update_tijd,width,height,type FROM image WHERE ID='87873' AND width>0 AND height>0SELECT ID,url,onderschrift,verhouding,lokale_url,update_tijd,width,height,type FROM image WHERE ID='87816' AND width>0 AND height>0SELECT 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 ID,url,onderschrift,verhouding,lokale_url,update_tijd,width,height,type FROM image WHERE ID='87650' AND width>0 AND height>0SELECT ID,url,onderschrift,verhouding,lokale_url,update_tijd,width,height,type FROM image WHERE ID='31460' AND width>0 AND height>0SELECT 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='4' AND n.embargodatum <= now()
ORDER BY n.embargodatum DESC, update_tijd DESC LIMIT 0,5SELECT n.* FROM nieuws AS n WHERE n.nieuws_typeID='10' AND n.ID!=8347 AND n.embargodatum <= now()
ORDER BY n.embargodatum DESC, update_tijd DESC LIMIT 0,9SELECT * FROM `nieuws` WHERE `ID`='9872'SELECT * from nieuws_type WHERE ID = '10'SELECT * FROM `nieuws` WHERE `ID`='9869'SELECT * from nieuws_type WHERE ID = '10'SELECT * FROM `nieuws` WHERE `ID`='9864'SELECT * from nieuws_type WHERE ID = '10'SELECT s.ID, s.naam, COUNT(DISTINCT f.filmID) AS films
FROM stad AS s, filmagenda AS f
WHERE s.ID=f.stadID AND f.begindatum='2025-05-29'
GROUP BY s.ID ORDER BY films DESC, s.naam LIMIT 0,7SELECT * FROM `filmvoorstelling` WHERE date(tijdstip)=current_date() AND stadID = '13' ORDER BY tijdstip DESC LIMIT 0,1SELECT n.* FROM nieuws AS n WHERE n.nieuws_typeID='2' AND n.ID!=8347 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
Trends. Home Alone 2: Lost in New York kruipt voorzichtig omhoog en Happiest Season verschijnt nu ook in de wekelijkse ranglijst. Alles is Zoals het Zou Moeten Zijn blijft de sterkste filmtitel op vod op dit moment en goede kanshebber om de kerstfilm van 2020 te worden.
14-12-2020 Door: Bioscoopagenda
We hebben na 25 jaar helaas je hulp nodig!
Dank voor je hulp.
Met Trends geven we aan hoe de markt voor huur video-on-demand (VOD) zich ontwikkelt tijdens de week in Nederland.