added ORDER BY rank to projects sql