mysql> select count(p.nid) as open_issues, p.pid, n.title from project_issues p INNER JOIN node n ON p.pid = n.nid WHERE p.sid IN (1,8,13,14,15,2,4) GROUP BY p.pid ORDER BY open_issues DESC LIMIT 20;
+-------------+-------+--------------------------------+
| open_issues | pid   | title                          |
+-------------+-------+--------------------------------+
|        3091 |  3060 | Drupal                         |
|         443 |  5841 | E-Commerce                     |
|         276 |  3256 | Image                          |
|         271 | 39683 | Category                       |
|         271 | 38878 | Views                          |
|         265 |  3238 | Event                          |
|         265 | 48429 | Content Construction Kit (CCK) |
|         235 |  5737 | Flexinode                      |
|         205 | 18753 | Documentation                  |
|         192 |  3281 | Project                        |
|         185 | 33591 | GMap Module                    |
|         177 | 18723 | location (API, module)         |
|         173 | 13446 | Organic groups                 |
|         163 |  3202 | Drupal.org webmasters          |
|         158 | 18803 | TinyMCE WYSIWYG Editor         |
|         158 | 57285 | Javascript Tools               |
|         155 | 69435 | Bibliography Module            |
|         138 |  3213 | User experience                |
|         126 | 24719 | Links Package                  |
|         125 |  8404 | captcha                        |
+-------------+-------+--------------------------------+
20 rows in set (1.58 sec)