mysql> SELECT T1.skillId, playerClass FROM (SELECT NA_DS3_22F_SKILLLOG.logId, NA_DS3_22F_SKILLLOG.playerName, NA_DS3_22F_SKILLLOG.playerServer, skillId FROM NA_DS3_22F_SKILLLOG WHERE playerServer='Mount Tyrannas' GROUP BY skillId, NA_DS3_22F_SKILLLOG.playerName) T1 JOIN NA_DS3_22F_PARTY ON T1.playerName = NA_DS3_22F_PARTY.playerName AND NA_DS3_22F_PARTY.logId = T1.logId GROUP BY skillId, playerClass;
+----------+-------------+
| skillId  | playerClass |
+----------+-------------+
|    10300 | Reaper      |
|    10302 | Reaper      |
|    10303 | Reaper      |
|    11200 | Archer      |
|    11200 | Berserker   |
|    11200 | Brawler     |
|    11200 | Lancer      |
|    11200 | Mystic      |
|    11200 | Ninja       |
|    11200 | Slayer      |
|    11200 | Sorcerer    |
|    11200 | Warrior     |
|    11201 | Brawler     |
|    11201 | Lancer      |
|    11201 | Mystic      |
|    11201 | Ninja       |
|    11202 | Brawler     |
|    11202 | Lancer      |
|    11202 | Ninja       |
|    11203 | Brawler     |
|    11203 | Ninja       |
|    11204 | Ninja       |
|    11205 | Ninja       |
|    11206 | Ninja       |
|    11220 | Gunner      |
|    11220 | Priest      |
|    11230 | Brawler     |
|    11230 | Ninja       |
|    11231 | Brawler     |
|    11232 | Brawler     |
|    11240 | Ninja       |
|    11241 | Ninja       |
|    11242 | Ninja       |
|    11244 | Ninja       |
|    11246 | Ninja       |
|    11270 | Ninja       |
|    20620 | Gunner      |
|    21000 | Mystic      |
|    21020 | Sorcerer    |
|    21100 | Slayer      |
|    21110 | Archer      |
|    21201 | Brawler     |
|    21202 | Brawler     |
|    21203 | Brawler     |
|    21204 | Brawler     |
|    21210 | Brawler     |
|    21211 | Brawler     |
|    30201 | Brawler     |
|    30300 | Reaper      |
|    30320 | Sorcerer    |
|    30330 | Reaper      |
|    30800 | Lancer      |
|    30820 | Ninja       |
|    30830 | Lancer      |
|    30912 | Archer      |
|    30913 | Archer      |
|    31013 | Berserker   |
|    31100 | Slayer      |
|    31101 | Gunner      |
|    31102 | Gunner      |
|    31130 | Gunner      |
|    40300 | Reaper      |
|    40330 | Reaper      |
|    40901 | Gunner      |
|    40902 | Gunner      |
|    40904 | Gunner      |
|    40920 | Sorcerer    |
|    40921 | Sorcerer    |
|    40922 | Sorcerer    |
|    40923 | Sorcerer    |
|    40930 | Gunner      |
|    41000 | Brawler     |
|    41030 | Brawler     |
|    41100 | Berserker   |
|    41110 | Ninja       |
|    41130 | Berserker   |
|    41130 | Warrior     |
|    41211 | Archer      |
|    41212 | Archer      |
|    41213 | Archer      |
|    50100 | Lancer      |
|    50220 | Archer      |
|    50330 | Reaper      |
|    50921 | Ninja       |
|    51001 | Gunner      |
|    60200 | Reaper      |
|    60200 | Slayer      |
|    60230 | Reaper      |
|    60231 | Reaper      |
|    60500 | Berserker   |
|    60700 | Sorcerer    |
|    61010 | Ninja       |
|    61101 | Brawler     |
|    61120 | Gunner      |
|    61122 | Gunner      |
|    61130 | Brawler     |
|    61131 | Brawler     |
|    70820 | Gunner      |
|    70821 | Gunner      |
|    71100 | Brawler     |
|    71130 | Brawler     |
|    71200 | Ninja       |
|    80200 | Ninja       |
|    80200 | Reaper      |
|    80201 | Ninja       |
|    80202 | Ninja       |
|    80230 | Ninja       |
|    80230 | Reaper      |
|    80700 | Lancer      |
|    80900 | Archer      |
|    80901 | Archer      |
|    80930 | Slayer      |
|    81100 | Mystic      |
|    81100 | Sorcerer    |
|    81101 | Brawler     |
|    81130 | Brawler     |
|    81131 | Brawler     |
|    90100 | Reaper      |
|    90300 | Lancer      |
|    90800 | Slayer      |
|    91021 | Gunner      |
|    91022 | Gunner      |
|    91023 | Gunner      |
|    91024 | Gunner      |
|    91025 | Gunner      |
|    91101 | Brawler     |
|    91102 | Brawler     |
|    91130 | Brawler     |
|    91131 | Brawler     |
|   100200 | Reaper      |
|   100230 | Reaper      |
|   100300 | Lancer      |
|   100420 | Archer      |
|   100700 | Warrior     |
|   100800 | Brawler     |
|   100830 | Brawler     |
|   101113 | Berserker   |
|   101124 | Gunner      |
|   110200 | Reaper      |
|   110201 | Reaper      |
|   110202 | Reaper      |
|   110203 | Reaper      |
|   110800 | Berserker   |
|   110800 | Warrior     |
|   110901 | Gunner      |
|   110902 | Gunner      |
|   110930 | Gunner      |
|   110931 | Gunner      |
|   111000 | Lancer      |
|   111100 | Priest      |
|   111100 | Sorcerer    |
|   120200 | Reaper      |
|   120201 | Reaper      |
|   120500 | Slayer      |
|   120620 | Sorcerer    |
|   120720 | Gunner      |
|   120800 | Warrior     |
|   121101 | Ninja       |
|   121130 | Ninja       |
|   130120 | Reaper      |
|   130201 | Gunner      |
|   130202 | Gunner      |
|   130230 | Gunner      |
|   130700 | Slayer      |
|   131001 | Ninja       |
|   131030 | Ninja       |
|   131100 | Lancer      |
|   131130 | Lancer      |
|   140300 | Reaper      |
|   140800 | Slayer      |
|   140801 | Slayer      |
|   140802 | Slayer      |
|   141000 | Sorcerer    |
|   141101 | Ninja       |
|   141102 | Ninja       |
|   141130 | Ninja       |
|   150380 | Reaper      |
|   150720 | Archer      |
|   150720 | Ninja       |
|   150900 | Slayer      |
|   150914 | Berserker   |
|   150930 | Brawler     |
|   151001 | Lancer      |
|   160400 | Ninja       |
|   160400 | Slayer      |
|   160430 | Ninja       |
|   160501 | Brawler     |
|   160530 | Brawler     |
|   160701 | Warrior     |
|   160900 | Priest      |
|   160900 | Sorcerer    |
|   161000 | Archer      |
|   170300 | Archer      |
|   170620 | Sorcerer    |
|   171010 | Brawler     |
|   171100 | Warrior     |
|   180101 | Brawler     |
|   180102 | Brawler     |
|   180130 | Brawler     |
|   180610 | Berserker   |
|   180722 | Gunner      |
|   180900 | Sorcerer    |
|   180920 | Ninja       |
|   180921 | Ninja       |
|   181000 | Archer      |
|   181001 | Archer      |
|   181100 | Lancer      |
|   181100 | Warrior     |
|   181101 | Lancer      |
|   190500 | Ninja       |
|   190530 | Ninja       |
|   190800 | Archer      |
|   191000 | Warrior     |
|   191001 | Warrior     |
|   200100 | Reaper      |
|   200200 | Archer      |
|   200510 | Sorcerer    |
|   210100 | Slayer      |
|   210200 | Warrior     |
|   210400 | Lancer      |
|   211000 | Mystic      |
|   220200 | Warrior     |
|   220800 | Archer      |
|   230200 | Lancer      |
|   230200 | Slayer      |
|   230220 | Archer      |
|   230230 | Slayer      |
|   231100 | Mystic      |
|   231130 | Mystic      |
|   240100 | Lancer      |
|   240100 | Slayer      |
|   240130 | Slayer      |
|   240212 | Berserker   |
|   240213 | Berserker   |
|   240220 | Archer      |
|   241010 | Mystic      |
|   250100 | Berserker   |
|   250130 | Berserker   |
|   250130 | Slayer      |
|   250220 | Archer      |
|   250700 | Lancer      |
|   250730 | Lancer      |
|   260120 | Berserker   |
|   261100 | Priest      |
|   270420 | Sorcerer    |
|   270800 | Warrior     |
|   271100 | Priest      |
|   271130 | Priest      |
|   280700 | Warrior     |
|   280730 | Warrior     |
|   290100 | Archer      |
|   290700 | Warrior     |
|   290730 | Warrior     |
|   291100 | Priest      |
|   291101 | Priest      |
|   300100 | Sorcerer    |
|   300200 | Warrior     |
|   300230 | Warrior     |
|   310101 | Berserker   |
|   310900 | Warrior     |
|   310930 | Warrior     |
|   340100 | Warrior     |
|   350410 | Priest      |
|   400120 | Priest      |
|   420120 | Mystic      |
|   700809 | Mystic      |
|   800907 | Priest      |
| 10151032 | Reaper      |
| 60400111 | Lancer      |
| 67044429 | Mystic      |
| 67044430 | Gunner      |
| 67044430 | Mystic      |
| 67044431 | Mystic      |
| 67044431 | Warrior     |
| 67044432 | Mystic      |
| 67044435 | Gunner      |
+----------+-------------+
276 rows in set (0.00 sec)