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 'DISTINCT(n.nid), pn.title, COUNT(n.nid) AS total FROM drupal_node n INNER JOIN d' at line 1
query: SELECT p DISTINCT(n.nid), pn.title, COUNT(n.nid) AS total FROM drupal_node n INNER JOIN drupal_project_issues p ON n.nid = p.nid INNER JOIN drupal_node pn ON p.pid = pn.nid INNER JOIN drupal_node_access na ON na.nid = n.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 1 AND na.realm = 'workflow_access') OR (na.gid = 0 AND na.realm = 'workflow_access_owner') OR (na.gid = 1 AND na.realm = 'term_access'))) AND ( n.status = 1 AND pn.status = 1 AND p.sid = 1 ) GROUP BY pn.nid, pn.title ORDER BY total DESC LIMIT 0, 15 in /var/www/fffin/includes/database.mysql.inc on line 172.
