Logged In: YES 
user_id=8719

i guess the sql statement should look like this:

select distinct(_issue.id),_priority._order,_issue._activity 
 from _issue INNER JOIN issue_nosy ON
_issue.id=issue_nosy.nodeid 
 LEFT OUTER JOIN _priority on _issue._priority=_priority.id 
 where (_issue._status is NULL or 
               (_issue._status in
('1','2','3','4','5','6','7')))
  and issue_nosy.linkid in ('1') 
  and _issue.__retired__ <> 1 
 order by _priority._order,_issue._activity desc 

"where" and "join on" are two different syntaxes for table
joins, and i am not sure if they can be combined.  (perhaps
not, if we get this error.)