Reduce SQL queries for global RSS feature.
Some add-ons may trigger N+1 queries where each post alerts checks the reply ban status of the thread which requires a separate DB query.
Minor code cleanup.
Remove extra queries in favour of a join for:
Viewing watched threads.
Search results by thread.