Invalid query SELECT numstand,nom_eqp,classement.id_eqp,score,rank FROM `classement` left join equipe on classement.id_eqp = equipe.id_eqp order by rank asc, score desc