Ranking gęsior

[Nerkoerko]

$skills = $SQL->query('SELECT name,online,value,level,experience,vocation,promotion FROM players,player_skills WHERE players.world_id = '.$world_id.' AND players.deleted = 0 AND players.group_id < '.$config['site']['players_group_id_block'].' [COLOR="#FF0000"]AND name != "Rook Sample" AND name != "Knight Sample" AND name != "Sorcerer Sample" AND name != "Paladin Sample" AND name != "Druid Sample"[/COLOR] AND players.id = player_skills.player_id AND player_skills.skillid = '.$id.' ORDER BY value DESC, count DESC LIMIT 101 OFFSET '.$offset);

Zablokowałem już sample ale nie wiem jak zrobić zeby w rankingu nie pokazywało graczy bez profesji wie ktoś co dodać?

Chciałbym oddzielić ranking na roku i na mainie ;p

 

[Be A Mafia]

And vocation = 0

 

[Nerkoerko]

Dzięki

AND vocation != "0"

 

[Be A Mafia]

Dzięki

AND vocation != "0"

! nie potrzebne