SELECT * FROM dvdone_movie WHERE copies != 0 AND format = 3 AND (id = '10076' OR id = '11916' OR id = '17096') AND price = '0' AND (dvdone_movie.id_imdb != '' AND dvdone_movie.id_imdb IS NOT NULL) GROUP BY dvdone_movie.id_imdb ORDER BY dvdone_movie.availability > 0 DESC, ( (100-5*(YEAR(CURDATE()) - dvdone_movie.year_imdb))/100 * (rented+1) / GREATEST((rented_12weeks+1) / 12, copies+1) / ((to_days(curdate()) - to_days(date))+1) ) DESC, price DESC, dvdone_movie.id_movie DESC LIMIT 0,11187
Eric Schaeffer - DVD Verleih online (Schweiz)
