From EVEDev
SELECT DISTINCT
invTypes.typeID,
invTypes.typeName,
dgmTypeAttributes.valueFloat AS rank
FROM
invTypes
INNER JOIN invGroups ON (invTypes.groupID = invGroups.groupID)
INNER JOIN dgmTypeAttributes ON (invTypes.typeID = dgmTypeAttributes.typeID)
WHERE
invGroups.categoryID = 16
AND invTypes.published = 1
AND dgmTypeAttributes.attributeID = 275
AND dgmTypeAttributes.valueFloat IS NOT NULL
ORDER BY
invTypes.typeID;
| typeID | typeName | rank |
|---|
| 3300 | Gunnery | 1 |
| 3301 | Small Hybrid Turret | 1 |
| 3302 | Small Projectile Turret | 1 |
| 3303 | Small Energy Turret | 1 |
| 3304 | Medium Hybrid Turret | 3 |
| 3305 | Medium Projectile Turret | 3 |
| 3306 | Medium Energy Turret | 3 |
| 3307 | Large Hybrid Turret | 5 |
| 3308 | Large Projectile Turret | 5 |
| 3309 | Large Energy Turret | 5 |
| 3310 | Rapid Firing | 2 |
| 3311 | Sharpshooter | 2 |
| 3312 | Motion Prediction | 2 |
| 3315 | Surgical Strike | 4 |
| 3316 | Controlled Bursts | 2 |