MySQL error when running on 4.7.1

After installing urllist.module on drupal 4.7.1 I get a MySQL error report every time the urllist page is requested. Message reads:

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 '(node.nid), n.type, n.status, n.promote, n.changed, u.dst FROM query: SELECT n.DISTINCT(node.nid), n.type, n.status, n.promote, n.changed, u.dst FROM node n LEFT JOIN url_alias u ON u.src=CONCAT('node/',n.nid) in .... /database.mysql.inc on line 120

Perhap the security fix in 4.7.1 is causing the urllist.module to break?