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)