Last Minute
Pitch
Dank voor je hulp.
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`='12685'SELECT ID, titel FROM film WHERE originelefilmID='12685'SELECT ID,url,onderschrift,verhouding,lokale_url,update_tijd,width,height,type FROM image WHERE ID='8929' AND width>0 AND height>0SELECT * FROM mening WHERE filmID='12685' ORDER BY tijd DESCselect * from filmrecensie where filmID = '12685' order by urlSELECT n.*,l.main,l.filmID AS linkedID FROM nieuws_film AS l,nieuws AS n WHERE l.filmID='12685' 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='12685' AND tv.TVchannelID=ch.ID SELECT s.ID,s.naam AS stad, s.landID FROM filmvoorstelling AS a, stad AS s WHERE (a.filmID='12685') 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 * FROM site_film WHERE siteID=159 AND filmID='12685'SELECT * FROM site_film WHERE siteID='241' AND filmID='12685'SELECT * FROM film_filmstreamservice WHERE `filmstreamserviceID`=7 AND filmID='12685'SELECT * FROM film_filmstreamservice WHERE `filmstreamserviceID`=4 AND filmID='12685' AND (till='0000-00-00' OR till>=now())SELECT * FROM film_filmstreamservice WHERE `filmstreamserviceID`=1 AND filmID='12685' AND (till='0000-00-00' OR till>=now())SELECT * FROM film_filmstreamservice WHERE `filmstreamserviceID`=5 AND filmID='12685' AND (till='0000-00-00' OR till>=now())SELECT * FROM film_filmstreamservice WHERE `filmstreamserviceID`=2 AND filmID='12685' AND (till='0000-00-00' OR till>=now())UPDATE film SET buyOutput='
Twee schoonmaaksters vinden een geboeide man in een bezemkast van een Duits vliegveld. hij beweert Koerdisch politiek vluchteling te zijn. De vrouwen komen in gewetensnood: helpen ze hem, of leveren ze hem uit?
\n