public function getActiveReports()
{
return $this->fetchAllKeyed('
SELECT report.*,
user.*,
assigned.username AS assigned_username
FROM xf_report AS report
LEFT JOIN xf_user AS assigned ON (assigned.user_id = report.assigned_user_id)
LEFT JOIN xf_user AS user ON (user.user_id = report.content_user_id)
WHERE report.report_state IN (\'open\', \'assigned\')
ORDER BY report.last_modified_date DESC
', 'report_id');
}