Selam

  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
  WHERE player.name NOT LIKE '[%]%' AND account.status!='BLOCK'
  ORDER BY player.level DESC, player.exp DESC";

Bu şekilde Account status BLOCK Olanları ekrana yazmasını engeliyorum fakat

  $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
  WHERE player.name NOT LIKE '[%]%' AND account.status!='BLOCK'
  ORDER BY player.level DESC, player.exp DESC 
  LIMIT ".$cSeite[1].",".$CPSeite;
  //echo $sqlCmd;
  $sqlQry = mysql_query($sqlCmd,$sqlServ);
  $x=$cSeite[1]+1;
  while($getPlayers = mysql_fetch_object($sqlQry)) {
    $zF = ($x%2==0) ? "thell" : "tdunkel";
    if(checkInt($markierteZeile) && $markierteZeile==$x) { $zF = "tmarkiert"; }
	
	echo"<tr class='even' height='25px' align='center'>";
	echo"<td>".$x."</td>";
	echo"<td><a href='index.php?sayfa=detay&char=".$getPlayers->id."'>$getPlayers->name</a></td>";
	echo"<td><img height='15' src='template/m2wars/img/job_thub/".$getPlayers->job.".jpg' /></td>";
	echo"<td>".$getPlayers->exp."</td>	";
	echo"<td>".$getPlayers->level."</td>";
	echo"<td>".$getPlayers->playtime." dk.</td>";
	echo"</tr>";
    
    $x++;

Bu şekilde ekrana sorguyu yazdıramıyorum eksik nerededir Teşşekür eder hayırlı geceler dilerim.