SQL for basic ship information

ships.sql

select it.typeid,typename,
coalesce(a1.valuefloat,a1.valueint,0) Low,
coalesce(a2.valuefloat,a2.valueint,0) Medium,
coalesce(a3.valuefloat,a3.valueint,0) High,
coalesce(a4.valuefloat,a4.valueint,0) Drone,
coalesce(a5.valuefloat,a5.valueint,0) Rig,
coalesce(a6.valuefloat,a6.valueint,0) Subsystem,
it.raceID,
raceName,
coalesce(metagroupname,"Tech I") tech,
groupname,
marketgroupname
from invTypes it
left join dgmTypeAttributes a1 on it.typeid=a1.typeid and a1.attributeid=12
left join dgmTypeAttributes a2 on it.typeid=a2.typeid and a2.attributeid=13
left join dgmTypeAttributes a3 on it.typeid=a3.typeid and a3.attributeid=14
left join dgmTypeAttributes a4 on it.typeid=a4.typeid and a4.attributeid=283
left join dgmTypeAttributes a5 on it.typeid=a5.typeid and a5.attributeid=1137
left join dgmTypeAttributes a6 on it.typeid=a6.typeid and a6.attributeid=1367
left join chrRaces on it.raceID=chrRaces.raceID
left join invGroups on it.groupid=invGroups.groupid
left join invMarketGroups on it.marketgroupid=invMarketGroups.marketgroupid
left join invMetaTypes on it.typeid=invMetaTypes.typeid
left join invMetaGroups on invMetaTypes.metaGroupID=invMetaGroups.metaGroupID
where categoryid=6;