Bu örnek işini görecektir.
 $sqlCmd = "SELECT player.id,player.name,player.level,player.exp,player.job,player.playtime,player_index.empire,guild.name AS guild_name   
  FROM player.player   
  LEFT JOIN player.player_index   
  ON player_index.id=player.account_id   
  LEFT JOIN player.guild_member   
  ON guild_member.pid=player.id   
  LEFT JOIN player.guild   
  ON guild.id=guild_member.guild_id  
  INNER JOIN account.account  
  ON account.id=player.account_id 
  WHERE player.name NOT LIKE '[%]%' AND account.status!='BLOCK'  
  ORDER BY player.level DESC, player.exp DESC   
  LIMIT ".$cSeite[1].",".$CPSeite;