Movie reviews

user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY m.rating ASC LIMIT 0, 20' at line 1 query: SELECT DISTINCT(n.nid), n.title, m.movietitle, m.cover, m.director, m.genre, m.releaseyear, m.runtime, m.rating, m.imdb, m.price FROM drupal_reviews m INNER JOIN drupal_node n ON m.nid = n.nid WHERE n.status = 1 ORDER BY m.nid DESC ORDER BY m.rating ASC LIMIT 0, 20 in /var/www/vhosts/dreadcentral.com/httpdocs/includes/database.mysql.inc on line 172.