Feature database performance

When doing some development this morning I noticed some of the pages were requesting the same information multiple times (duplicate queries). In addition, some of the queries were near-identical but had different parameters (eg, different competition IDs).

These changes alter the most heavily hit pages to only fetch the details once as required and make use of database joins to reduce round trips to the database server.