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

Unknown column 'rank' in 'order clause'