SELECT Slayer.`Name`, Slayer.Sex, Slayer.AdvancementGoalExp, Slayer.Rank, CASE WHEN (Slayer.BladeLevel > 50) AND (Slayer.BladeLevel > Slayer.SwordLevel) AND (Slayer.BladeLevel > Slayer.EnchantLevel) AND (Slayer.BladeLevel > Slayer.HealLevel) AND (Slayer.BladeLevel > Slayer.GunLevel) THEN Slayer.BladeLevel WHEN (Slayer.SwordLevel > 50) AND (Slayer.SwordLevel > Slayer.BladeLevel) AND (Slayer.SwordLevel > Slayer.EnchantLevel) AND (Slayer.SwordLevel > Slayer.HealLevel) AND (Slayer.SwordLevel > Slayer.GunLevel) THEN Slayer.SwordLevel WHEN (Slayer.EnchantLevel > 30) AND (Slayer.EnchantLevel > Slayer.SwordLevel) AND (Slayer.EnchantLevel > Slayer.BladeLevel) AND (Slayer.EnchantLevel > Slayer.HealLevel) AND (Slayer.EnchantLevel > Slayer.GunLevel) THEN Slayer.EnchantLevel WHEN (Slayer.HealLevel > 30) AND (Slayer.HealLevel > Slayer.SwordLevel) AND (Slayer.HealLevel > Slayer.EnchantLevel) AND (Slayer.HealLevel > Slayer.BladeLevel) AND (Slayer.HealLevel > Slayer.GunLevel) THEN Slayer.HealLevel WHEN (Slayer.GunLevel > 40) AND (Slayer.GunLevel > Slayer.SwordLevel) AND (Slayer.GunLevel > Slayer.EnchantLevel) AND (Slayer.GunLevel > Slayer.HealLevel) AND (Slayer.GunLevel > Slayer.BladeLevel) THEN Slayer.GunLevel ELSE 0 END AS Experience, CASE WHEN (Slayer.BladeLevel > 0) AND (Slayer.BladeLevel > Slayer.SwordLevel) AND (Slayer.BladeLevel > Slayer.EnchantLevel) AND (Slayer.BladeLevel > Slayer.HealLevel) AND (Slayer.BladeLevel > Slayer.GunLevel) THEN Slayer.BladeLevel + AdvancementClass WHEN (Slayer.SwordLevel > 0) AND (Slayer.SwordLevel > Slayer.BladeLevel) AND (Slayer.SwordLevel > Slayer.EnchantLevel) AND (Slayer.SwordLevel > Slayer.HealLevel) AND (Slayer.SwordLevel > Slayer.GunLevel) THEN Slayer.SwordLevel + AdvancementClass WHEN (Slayer.EnchantLevel > 0) AND (Slayer.EnchantLevel > Slayer.SwordLevel) AND (Slayer.EnchantLevel > Slayer.BladeLevel) AND (Slayer.EnchantLevel > Slayer.HealLevel) AND (Slayer.EnchantLevel > Slayer.GunLevel) THEN Slayer.EnchantLevel + AdvancementClass WHEN (Slayer.HealLevel > 0) AND (Slayer.HealLevel > Slayer.SwordLevel) AND (Slayer.HealLevel > Slayer.EnchantLevel) AND (Slayer.HealLevel > Slayer.BladeLevel) AND (Slayer.HealLevel > Slayer.GunLevel) THEN Slayer.HealLevel + AdvancementClass WHEN (Slayer.GunLevel > 0) AND (Slayer.GunLevel > Slayer.SwordLevel) AND (Slayer.GunLevel > Slayer.EnchantLevel) AND (Slayer.GunLevel > Slayer.HealLevel) AND (Slayer.GunLevel > Slayer.BladeLevel) THEN Slayer.GunLevel + AdvancementClass ELSE 0 END AS Level, CASE WHEN (Slayer.BladeLevel > 0) AND (Slayer.BladeLevel > Slayer.SwordLevel) AND (Slayer.BladeLevel > Slayer.EnchantLevel) AND (Slayer.BladeLevel > Slayer.HealLevel) AND (Slayer.BladeLevel > Slayer.GunLevel) THEN 'Blader' WHEN (Slayer.SwordLevel > 0) AND (Slayer.SwordLevel > Slayer.BladeLevel) AND (Slayer.SwordLevel > Slayer.EnchantLevel) AND (Slayer.SwordLevel > Slayer.HealLevel) AND (Slayer.SwordLevel > Slayer.GunLevel) THEN 'Sworder' WHEN (Slayer.EnchantLevel > 0) AND (Slayer.EnchantLevel > Slayer.SwordLevel) AND (Slayer.EnchantLevel > Slayer.BladeLevel) AND (Slayer.EnchantLevel > Slayer.HealLevel) AND (Slayer.EnchantLevel > Slayer.GunLevel) THEN 'Enchanter' WHEN (Slayer.HealLevel > 0) AND (Slayer.HealLevel > Slayer.SwordLevel) AND (Slayer.HealLevel > Slayer.EnchantLevel) AND (Slayer.HealLevel > Slayer.BladeLevel) AND (Slayer.HealLevel > Slayer.GunLevel) THEN 'Healer' WHEN (Slayer.GunLevel > 0) AND (Slayer.GunLevel > Slayer.SwordLevel) AND (Slayer.GunLevel > Slayer.EnchantLevel) AND (Slayer.GunLevel > Slayer.HealLevel) AND (Slayer.GunLevel > Slayer.BladeLevel) THEN 'Gunner' ELSE '' END AS Job FROM `Slayer` Slayer LEFT JOIN `Player` Player on (Player.PlayerID = Slayer.PlayerID) WHERE Slayer.Race = 'SLAYER' AND Player.LastLoginDate > '2026-04-25' AND (Slayer.BladeLevel > 1 OR Slayer.SwordLevel > 1 OR Slayer.EnchantLevel > 1 OR Slayer.HealLevel > 1 OR Slayer.GunLevel > 1) ORDER BY `Level` DESC, Slayer.AdvancementGoalExp DESC, Experience DESC LIMIT 20

Slayers

VAMPIRES

Ousters