$skills = $SQL->query('SELECT name,online,value,level,vocation,promotion,account_id,world_id,vocation,lookfeet,lookhead,looklegs,lookbody,looktype,lookaddons FROM players,player_skills WHERE '.$qurt.$sqlqurtvoc.' players.deleted = 0 AND players.group_id < '.$config['site']['players_group_id_block'].' AND players.id = player_skills.player_id AND player_skills.skillid = '.$id.' AND name != "Rook Sample" AND name != "Sorcerer Sample" AND name != "Druid Sample" AND name != "Paladin Sample" AND name != "Knight Sample" ORDER BY value DESC, count DESC LIMIT 101 OFFSET '.$offset);
elseif($list == "magic")
$skills = $SQL->query('SELECT name,online,maglevel,level,vocation,promotion,account_id,world_id,vocation,lookfeet,lookhead,looklegs,lookbody,looktype,lookaddons FROM players WHERE '.$qurt.$sqlqurtvoc.' players.deleted = 0 AND players.group_id < '.$config['site']['players_group_id_block'].' AND name != "Account Manager" AND name != "Rook Sample" AND name != "Sorcerer Sample" AND name != "Druid Sample" AND name != "Paladin Sample" AND name != "Knight Sample" ORDER BY maglevel DESC, manaspent DESC LIMIT 101 OFFSET '.$offset);
elseif($list == "experience")
$skills = $SQL->query('SELECT name,online,level,experience,vocation,promotion,account_id,world_id,vocation,lookfeet,lookhead,looklegs,lookbody,looktype,lookaddons FROM players WHERE '.$qurt.$sqlqurtvoc.' players.deleted = 0 AND players.group_id < '.$config['site']['players_group_id_block'].' AND name != "Account Manager" AND name != "Rook Sample" AND name != "Sorcerer Sample" AND name != "Druid Sample" AND name != "Paladin Sample" AND name != "Knight Sample" ORDER BY level DESC, experience DESC LIMIT 101 OFFSET '.$offset);