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

Unknown column 'ranking' in 'order clause'