SELECT SUM( CASE WHEN (`roster_members`.`character_level` >= 0 AND `roster_members`.`character_level` <= 10)THEN 1 ELSE 0 END) as lvl10, SUM(CASE WHEN (`roster_members`.`character_level` >= 11 AND `roster_members`.`character_level` <= 20) THEN 1 ELSE 0 END) as lvl20, SUM(CASE WHEN `roster_members`.`character_level` >= 21 AND `roster_members`.`character_level` <= 30 THEN 1 ELSE 0 END) as lvl30, SUM(CASE WHEN `roster_members`.`character_level` >= 31 AND `roster_members`.`character_level` <= 40 THEN 1 ELSE 0 END) as lvl40, SUM(CASE WHEN `roster_members`.`character_level` >= 41 AND `roster_members`.`character_level` <= 50 THEN 1 ELSE 0 END) as lvl50, SUM(CASE WHEN `roster_members`.`character_level` >= 51 AND `roster_members`.`character_level` <= 60 THEN 1 ELSE 0 END) as lvl59, SUM(CASE WHEN `roster_members`.`character_level` >= 61 AND `roster_members`.`character_level` <= 69 THEN 1 ELSE 0 END) as lvl69, SUM(CASE WHEN `roster_members`.`character_level` = 70 THEN 1 ELSE 0 END) as lvl70 FROM `roster_members` ORDER BY `roster_members`.`character_level` ASC
Name | Race | Class | Spec | Level | Rank | Professions |
---|---|---|---|---|---|---|
|
|
|
70 | 0 | ||
|
|
|
20 | 1 | ||
|
|
|
20 | 1 | ||
|
|
|
57 | 1 | ||
|
|
|
70 | 1 | ||
|
|
|
70 | 1 | ||
|
|
|
70 | 1 | ||
|
|
|
25 | 1 | ||
|
|
|
60 | 1 | ||
|
|
|
76 | 1 | ||
|
|
|
70 | 1 | ||
|
|
|
67 | 2 | ||
|
|
|
70 | 2 | ||
|
|
|
22 | 2 | ||
|
|
|
53 | 2 | ||
|
|
|
75 | 2 | ||
|
|
|
54 | 2 | ||
|
|
|
70 | 2 | ||
|
|
|
70 | 2 | ||
|
|
|
70 | 2 | ||
|
|
|
52 | 2 | ||
|
|
|
70 | 2 | ||
|
|
|
70 | 2 | ||
|
|
|
67 | 2 | ||
|
|
|
70 | 2 | ||
|
|
|
32 | 2 | ||
|
|
|
70 | 2 | ||
|
|
|
62 | 2 | ||
|
|
|
70 | 2 | ||
|
|
|
62 | 2 | ||
|
|
|
51 | 2 | ||
|
|
|
30 | 2 | ||
|
|
|
60 | 2 | ||
|
|
|
50 | 2 | ||
|
|
|
70 | 2 | ||
|
|
|
60 | 2 | ||
|
|
|
70 | 2 | ||
|
|
|
58 | 3 | ||
|
|
|
52 | 3 | ||
|
|
|
60 | 5 | ||
|
|
|
70 | 5 | ||
|
|
|
70 | 5 | ||
|
|
|
70 | 5 | ||
|
|
|
53 | 5 | ||
|
|
|
60 | 5 | ||
|
|
|
70 | 5 | ||
|
|
|
62 | 5 | ||
|
|
|
70 | 5 | ||
|
|
|
70 | 5 | ||
|
|
|
70 | 5 | ||
|
|
|
70 | 5 | ||
|
|
|
60 | 5 | ||
|
|
|
70 | 5 | ||
|
|
|
70 | 5 | ||
|
|
|
66 | 5 | ||
|
|
|
70 | 5 | ||
|
|
|
66 | 5 | ||
|
|
|
70 | 5 | ||
|
|
|
70 | 5 | ||
|
|
|
70 | 5 | ||
|
|
|
70 | 5 | ||
|
|
|
69 | 5 | ||
|
|
|
52 | 5 | ||
|
|
|
70 | 5 | ||
|
|
|
70 | 5 | ||
|
|
|
70 | 5 | ||
|
|
|
70 | 5 | ||
|
|
|
58 | 5 | ||
|
|
|
70 | 5 | ||
|
|
|
53 | 5 | ||
|
|
|
60 | 5 | ||
|
|
|
70 | 5 | ||
|
|
|
72 | 5 | ||
|
|
|
24 | 5 | ||
|
|
|
60 | 5 | ||
|
|
|
70 | 5 | ||
|
|
|
60 | 5 | ||
|
|
|
60 | 5 | ||
|
|
|
13 | 5 | ||
|
|
|
70 | 5 | ||
|
|
|
70 | 5 | ||
|
|
|
60 | 5 | ||
|
|
|
70 | 5 | ||
|
|
|
64 | 5 | ||
|
|
|
70 | 5 | ||
|
|
|
60 | 5 | ||
|
|
|
31 | 5 | ||
|
|
|
70 | 5 | ||
|
|
|
75 | 5 | ||
|
|
|
70 | 5 | ||
|
|
|
70 | 5 | ||
|
|
|
70 | 5 | ||
|
|
|
61 | 5 | ||
|
|
|
62 | 5 | ||
|
|
|
70 | 5 | ||
|
|
|
75 | 5 | ||
|
|
|
70 | 5 | ||
|
|
|
70 | 5 | ||
|
|
|
70 | 5 | ||
|
|
|
70 | 5 | ||
|
|
|
60 | 5 | ||
|
|
|
70 | 6 | ||
|
|
|
70 | 6 | ||
|
|
|
70 | 6 | ||
|
|
|
70 | 6 | ||
|
|
|
60 | 6 | ||
|
|
|
73 | 6 | ||
|
|
|
54 | 6 | ||
|
|
|
70 | 6 | ||
|
|
|
70 | 6 | ||
|
|
|
61 | 6 | ||
|
|
|
70 | 6 | ||
|
|
|
65 | 6 | ||
|
|
|
60 | 6 | ||
|
|
|
70 | 6 | ||
|
|
|
60 | 6 | ||
|
|
|
60 | 6 | ||
|
|
|
60 | 6 | ||
|
|
|
70 | 6 | ||
|
|
|
48 | 6 | ||
|
|
|
70 | 6 | ||
|
|
|
60 | 6 | ||
|
|
|
62 | 6 | ||
|
|
|
70 | 6 | ||
|
|
|
70 | 6 | ||
|
|
|
70 | 6 | ||
|
|
|
70 | 6 | ||
|
|
|
30 | 6 | ||
|
|
|
70 | 6 | ||
|
|
|
70 | 6 | ||
|
|
|
54 | 6 | ||
|
|
|
70 | 6 | ||
|
|
|
60 | 6 | ||
|
|
|
70 | 6 | ||
|
|
|
52 | 6 | ||
|
|
|
70 | 6 | ||
|
|
|
70 | 6 | ||
|
|
|
70 | 6 | ||
|
|
|
70 | 6 | ||
|
|
|
70 | 6 | ||
|
|
|
60 | 6 | ||
|
|
|
55 | 6 | ||
|
|
|
70 | 6 | ||
|
|
|
76 | 6 | ||
|
|
|
70 | 6 | ||
|
|
|
70 | 6 | ||
|
|
|
70 | 6 | ||
|
|
|
70 | 6 | ||
|
|
|
70 | 6 | ||
|
|
|
70 | 6 | ||
|
|
|
70 | 6 | ||
|
|
|
70 | 6 | ||
|
|
|
70 | 6 | ||
|
|
|
50 | 6 | ||
|
|
|
70 | 6 | ||
|
|
|
51 | 6 | ||
|
|
|
60 | 6 | ||
|
|
|
70 | 6 | ||
|
|
|
70 | 6 | ||
|
|
|
70 | 6 | ||
|
|
|
60 | 6 | ||
|
|
|
70 | 6 | ||
|
|
|
70 | 6 | ||
|
|
|
70 | 6 | ||
|
|
|
70 | 6 | ||
|
|
|
70 | 6 | ||
|
|
|
16 | 6 | ||
|
|
|
63 | 6 | ||
|
|
|
70 | 6 | ||
|
|
|
60 | 6 | ||
|
|
|
70 | 6 | ||
|
|
|
70 | 6 | ||
|
|
|
70 | 6 | ||
|
|
|
70 | 6 | ||
|
|
|
70 | 6 | ||
|
|
|
70 | 6 | ||
|
|
|
60 | 6 | ||
|
|
|
70 | 6 | ||
|
|
|
60 | 6 | ||
|
|
|
60 | 6 | ||
|
|
|
60 | 6 | ||
|
|
|
70 | 6 | ||
|
|
|
70 | 6 | ||
|
|
|
70 | 6 | ||
|
|
|
70 | 6 | ||
|
|
|
70 | 6 | ||
|
|
|
70 | 6 | ||
|
|
|
70 | 6 | ||
|
|
|
70 | 6 | ||
|
|
|
70 | 6 | ||
|
|
|
70 | 6 | ||
|
|
|
31 | 6 | ||
|
|
|
70 | 6 | ||
|
|
|
70 | 6 | ||
|
|
|
47 | 6 | ||
|
|
|
70 | 7 | ||
|
|
|
70 | 7 | ||
|
|
|
70 | 7 | ||
|
|
|
62 | 7 | ||
|
|
|
70 | 7 | ||