: SELECT reportname, reportdesc, reportID FROM WHERE active = 1 ORDER BY ranking, reportname