EVE Technology Lab

I have been messing around with data base query's on the eve static data. I wanted to get certain info from towers and this is what I came up with so far.

SELECT
  Names.[typeID]  AS ID,
  Names.[typeName] AS Name,  
  COALESCE(
    HP.[valueFloat],
    HP.[valueInt]
  ) AS Structure,  
  COALESCE(  
    ArmorHP.[valueFloat],    
    ArmorHP.[valueInt]
  ) AS Armor,  
  COALESCE(
    ShieldHP.[valueFloat],    
    ShieldHP.[valueInt]
  ) AS Sheild,  
  COALESCE(
    PWG.[valueFloat],    
    PWG.[valueInt]
  ) AS PowerGrid,  
  COALESCE(
    Tf.[valueFloat],    
    Tf.[valueInt]
  ) AS CPU
FROM invTypes AS Names
INNER JOIN dgmTypeAttributes As HP
  ON Names.[typeID] = HP.[typeID]   
  AND HP.[attributeID] = 9  
INNER JOIN dgmTypeAttributes AS ArmorHP
  ON Names.[typeID] = ArmorHP.[typeID]  
  AND ArmorHP.[attributeID] = 265  
INNER JOIN dgmTypeAttributes AS ShieldHP
  ON ShieldHP.[typeID] = Names.[typeID]  
  AND ShieldHP.[attributeID] = 263  
INNER JOIN dgmTypeAttributes AS PWG
  ON Names.[typeID] = PWG.[typeID]  
  AND PWG.[attributeID] = 11  
INNER JOIN dgmTypeAttributes AS Tf
  ON Names.[typeID] = Tf.[typeID]  
  AND Tf.[attributeID] = 48
WHERE 
  Names.[groupID] = 365 
  AND Names.[published] = 1 
  AND Names.[typeID] != 4361;

It returns the information in the format that I want it to be in, but it seems a little long. I was wondering if there was a better way to get the same result? Just really interested to see if I can add some techniques for my mental toolbox.

Great! Thanks for the reply. Well I Guess if anyone needs a query returns the following tower info:

typeID, typeName, Structure, Armor, Shield

Feel free to use this one. I know looking at examples helps learn from first hand experience.