Mysql Filter with ORDER BY

Question

I have a line to filter some values:

Level Exp Kills playtime

if (
  $cron_6 = mysqli_query(server_player(),
    "SELECT 
       player.id,
       player.name,
       player.level, 
       player.job,
       player_index.empire,
       player.exp,
     IF NULL(player.quantidade,0) 
       as 
         kills, 
         player.quantidade 
     FROM 
         player 
     LEFT JOIN 
         player_index 
     ON 
         player_index.id = player.account_id 
     LEFT JOIN 
         kill_system 
     ON 
         player.id = kill_system.id 
     WHERE 
         player.name 
           NOT LIKE 
             '[%]%' 
           OR 
             player.name 
           LIKE 
             '%[VIP]%' 
     ORDER BY 
         player.level 
           DESC, 
         quantidade 
           DESC, 
         player.playtime 
           DESC, 
         player.exp 
           DESC
      ;"
    )
  );

In case the value would be (ranking):

top Kill (who has more Kill)

top level (who has more level)

top Exp (who has the most Exp)

top playtime (who has more time)

My site with the ranking: https://sowmt2.org/site/ranking/players

In case who has +Kill should stay first.

Answer 1

Only add Kills to order by. SQL ORDER BY Keyword

The way you wrote it, it would look like this:

ORDER BY kills DESC, player.level DESC, player.exp DESC