Datlist multiple sort not working on live site

Questions
2

Could it be that your local mysql version is 5.6 and the one on the servers is 5.7? If so here is the solution: Fixing MySQL 5.7 troubles