mysql> select count(p.nid) as open_issues, pis.name FROM project_issues p INNER JOIN project_issue_state pis ON p.sid = pis.sid WHERE p.pid = 3060 AND p.sid IN (1,8,13,14,15,2,4) GROUP BY p.sid ORDER BY open_issues DESC;
+-------------+-------------------------------+
| open_issues | name |
+-------------+-------------------------------+
| 2025 | active |
| 494 | patch (code needs work) |
| 428 | patch (code needs review) |
| 53 | fixed |
| 44 | patch (ready to be committed) |
| 43 | postponed |
| 4 | patch (to be ported) |
+-------------+-------------------------------+
7 rows in set (1.95 sec)