2 things: 1) Excluded CVS Commits forum from recent postings. The package_id 3061 was hardcoded, so I hardcoded this as well figuring this page was slated as a one-off.
2) Removed the limit form the subquery (fm) and added it to the overall query. This was because the subquery would select messages that were later excluded by the where clauses. There was no messages returned from the query when CVS commits was excluded.
A general question - why was the subquery used as opposed to a straightforward join. If it was for general efficiency, moving the limit probably destroyed that. However, is the straightforward join really that expensive?