critical issue report doesn't show project names

the weekly critical issue reports (e.g. http://lists.drupal.org/archives/development/2006-08/msg00722.html) are no longer showing the name of the project in front of each category:

/ bug reports

4.7 Beta/ CVS Errors
 assigned: msameer
 age: 21 weeks 2 days
 url: http://drupal.org/node/55533

/ bug reports

Adding user to buddy list does not work
 age: 3 weeks 4 days
 url: http://drupal.org/node/75520

/ bug reports
...

the problem is the SQL query to get the info we want for the report. attached patch fixes this.

testing requires a little imagination. i just moved the call to project_mail_digest(); outside the check regarding variable_get('project_issue_digest_last', 0), and then manually running cron.php to see it happen... anyway, *i* tested and it's working fine. ;)