Cannot browse projects

When I try to view the relevant projects by date or by name, I receive the following SQL error:

Not unique table/alias: 'prn' query:
SELECT   DISTINCT (n.nid), 
                  n.title, 
                  n.sticky, 
                  n.TYPE, 
                  nr.teaser, 
                  nr.FORMAT, 
                  pip.issues, 
                  Max(prn.file_date) AS changed, 
                  prn.file_path, 
                  prn.version, 
                  Count(* )          AS release_count 
FROM     node n 
         INNER JOIN node_revisions nr 
           ON n.vid = nr.vid 
         INNER JOIN project_projects p 
           ON n.nid = p.nid 
         LEFT JOIN term_node r 
           ON n.nid = r.nid 
         INNER JOIN project_issue_projects pip 
           ON n.nid = pip.nid 
         INNER JOIN project_release_nodes prn 
           ON n.nid = prn.nid 
         INNER JOIN project_release_projects prp 
           ON n.nid = prp.nid 
         INNER JOIN project_release_nodes prn 
           ON n.nid = prn.pid 
         INNER JOIN term_node tr 
           ON tr.nid = prn.nid 
         INNER JOIN node rn 
           ON rn.nid = prn.nid 
         INNER JOIN project_release_supported_versions prsv 
           ON prsv.nid = p.nid 
              AND prsv.tid = tr.tid 
WHERE    n.status = 1 
         AND r.tid = 19 
         AND prp.releases = 1 
         AND rn.status = 1 
         AND tr.tid = 0 
         AND prsv.supported = 1 
GROUP BY n.nid 
ORDER BY changed DESC, 
         n.sticky DESC, 
         n.title ASC
LIMIT 0, 30 in /home/opentkne/public_html/includes/database.mysql.inc on line 174.

I understand that development is focused on the 6.x version right now, but not being able to browse any projects is a pretty serious issue.

It is obvious that this part is wrong:

         INNER JOIN project_issue_projects pip 
           ON n.nid = pip.nid 
         INNER JOIN project_release_nodes prn 
           ON n.nid = prn.nid 
         INNER JOIN project_release_projects prp 
           ON n.nid = prp.nid 
         INNER JOIN project_release_nodes prn

Anyone have any idea why this query is generated and how to fix it?

This issue also exists on a fresh installation of the current 6.x-dev version. I have set up a site that reproduces this issues at http://www.entreri.net.

This site has the following project types:
core
libraries
applications
- editor
- game

I have created two projects, one in "core", the other in "applications/game", enabled the project listing view and granted the necessary permissions. The projects are accessible individually, but the project listing view stays empty.

I can provide you with admin access to this site for debugging.

http://drupal.org/node/193496

This is not a duplicate after all. I cannot browse projects even if I create a 2-tier hierarchy.

Can some *please* help?

A screenshot of the problem. Note that I have clicked on Project -> Libraries -> Audio, the counter indicates that such a library exists, but it is not listed anywhere.