Allentown Jits players by salary

[ sql error ! (SELECT COUNT(*) AS count FROM players LEFT JOIN domains ON domains.domain_id = players.domain_id LEFT JOIN lan .. ) : Unknown column 'salary' in 'order clause' ]