Logged In: YES 
user_id=6405

Followed your instructions (though instead of searching, I just 
used the "Show All" link which I modified to include the nosy 
filter parameter - effectively the same, but the URL is easier to 
edit ;) 
 
I was unable to reproduce the error either with the latest CVS 
maint-0-7 branch code. Please try checking out this branch (see 
the developers doc for info how to do this) and test against it. 
 
I am not currently able to upgrade to posgresql 7.4.3, as no RPM 
is available. 
 
The SQL generated by this version of the code is (I hope this 
comes out readable): 
 
select distinct(_issue.id),_priority._order,_issue._activity 
 from issue_nosy,_issue 
 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.id=issue_nosy.nodeid 
  and issue_nosy.linkid in ('1') 
  and _issue.__retired__ <> 1 
 order by _priority._order,_issue._activity desc