Last active
August 14, 2017 23:48
-
-
Save fuzzysteve/10647593 to your computer and use it in GitHub Desktop.
skill levels - Eve online
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Style 1 : 1 row per type. multiple skills in each row. | |
| select typeid, max(skill1) skill1,max(skill1level) skill1level,max(skill2) skill2,max(skill2level) skill2level,max(skill3) skill3,max(skill3level) skill3level,max(skill4) skill4,max(skill4level) skill4level,max(skill5) skill5,max(skill5level) skill5level,max(skill6) skill6,max(skill6level) skill6level from | |
| ( | |
| select typeid,coalesce(valueint,valuefloat,0) skill1,0 skill1level,0 skill2,0 skill2level,0 skill3,0 skill3level,0 skill4,0 skill4level,0 skill5,0 skill5level,0 skill6,0 skill6level from dgmTypeAttributes where attributeID=182 | |
| union | |
| select typeid,0 skill1,0 skill1level,coalesce(valueint,valuefloat,0) skill2,0 skill2level,0 skill3,0 skill3level,0 skill4,0 skill4level,0 skill5,0 skill5level,0 skill6,0 skill6level from dgmTypeAttributes where attributeID=183 | |
| union | |
| select typeid,0 skill1,0 skill1level,0 skill2,0 skill2level,coalesce(valueint,valuefloat,0) skill3,0 skill3level,0 skill4,0 skill4level,0 skill5,0 skill5level,0 skill6,0 skill6level from dgmTypeAttributes where attributeID=184 | |
| union | |
| select typeid,0 skill1,coalesce(valueint,valuefloat,0) skill1level,0 skill2,0 skill2level,0 skill3,0 skill3level,0 skill4,0 skill4level,0 skill5,0 skill5level,0 skill6,0 skill6level from dgmTypeAttributes where attributeID=277 | |
| union | |
| select typeid,0 skill1,0 skill1level,0 skill2,coalesce(valueint,valuefloat,0) skill2level,0 skill3,0 skill3level,0 skill4,0 skill4level,0 skill5,0 skill5level,0 skill6,0 skill6level from dgmTypeAttributes where attributeID=278 | |
| union | |
| select typeid,0 skill1,0 skill1level,0 skill2,0 skill2level,0 skill3,coalesce(valueint,valuefloat,0) skill3level,0 skill4,0 skill4level,0 skill5,0 skill5level,0 skill6,0 skill6level from dgmTypeAttributes where attributeID=279 | |
| union | |
| select typeid,0 skill1,0 skill1level,0 skill2,0 skill2level,0 skill3,0 skill3level,coalesce(valueint,valuefloat,0) skill4,0 skill4level,0 skill5,0 skill5level,0 skill6,0 skill6level from dgmTypeAttributes where attributeID=1285 | |
| union | |
| select typeid,0 skill1,0 skill1level,0 skill2,0 skill2level,0 skill3,0 skill3level,0 skill4,coalesce(valueint,valuefloat,0) skill4level,0 skill5,0 skill5level,0 skill6,0 skill6level from dgmTypeAttributes where attributeID=1286 | |
| union | |
| select typeid,0 skill1,0 skill1level,0 skill2,0 skill2level,0 skill3,0 skill3level,0 skill4,0 skill4level,coalesce(valueint,valuefloat,0) skill5,0 skill5level,0 skill6,0 skill6level from dgmTypeAttributes where attributeID=1289 | |
| union | |
| select typeid,0 skill1,0 skill1level,0 skill2,0 skill2level,0 skill3,0 skill3level,0 skill4,0 skill4level,0 skill5,coalesce(valueint,valuefloat,0) skill5level,0 skill6,0 skill6level from dgmTypeAttributes where attributeID=1286 | |
| union | |
| select typeid,0 skill1,0 skill1level,0 skill2,0 skill2level,0 skill3,0 skill3level,0 skill4,0 skill4level,0 skill5,0 skill5level,coalesce(valueint,valuefloat,0) skill6,0 skill6level from dgmTypeAttributes where attributeID=1290 | |
| union | |
| select typeid,0 skill1,0 skill1level,0 skill2,0 skill2level,0 skill3,0 skill3level,0 skill4,0 skill4level,0 skill5,0 skill5level,0 skill6,coalesce(valueint,valuefloat,0) skill6level from dgmTypeAttributes where attributeID=1288 | |
| ) skills group by typeid; | |
| Type 2: multiple entries per type. | |
| select typeid, groupid,max(skill) skill,max(skilllevel) skilllevel from | |
| ( | |
| select typeid,1 groupid, coalesce(valueint,valuefloat,0) skill, 0 skilllevel from dgmTypeAttributes where attributeID=182 | |
| union | |
| select typeid,2 groupid, coalesce(valueint,valuefloat,0) skill, 0 skilllevel from dgmTypeAttributes where attributeID=183 | |
| union | |
| select typeid,3 groupid, coalesce(valueint,valuefloat,0) skill, 0 skilllevel from dgmTypeAttributes where attributeID=184 | |
| union | |
| select typeid,4 groupid, coalesce(valueint,valuefloat,0) skill, 0 skilllevel from dgmTypeAttributes where attributeID=1285 | |
| union | |
| select typeid,5 groupid, coalesce(valueint,valuefloat,0) skill, 0 skilllevel from dgmTypeAttributes where attributeID=1289 | |
| union | |
| select typeid,6 groupid, coalesce(valueint,valuefloat,0) skill, 0 skilllevel from dgmTypeAttributes where attributeID=1290 | |
| union | |
| select typeid,1 groupid, 0 skill, coalesce(valueint,valuefloat,0) skilllevel from dgmTypeAttributes where attributeID=277 | |
| union | |
| select typeid,2 groupid, 0 skill, coalesce(valueint,valuefloat,0) skilllevel from dgmTypeAttributes where attributeID=278 | |
| union | |
| select typeid,3 groupid, 0 skill, coalesce(valueint,valuefloat,0) skilllevel from dgmTypeAttributes where attributeID=279 | |
| union | |
| select typeid,4 groupid, 0 skill, coalesce(valueint,valuefloat,0) skilllevel from dgmTypeAttributes where attributeID=1286 | |
| union | |
| select typeid,5 groupid, 0 skill, coalesce(valueint,valuefloat,0) skilllevel from dgmTypeAttributes where attributeID=1287 | |
| union | |
| select typeid,6 groupid, 0 skill, coalesce(valueint,valuefloat,0) skilllevel from dgmTypeAttributes where attributeID=1288 | |
| ) skills group by typeid,groupid; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment