ship attributes

SELECT conv.typeName,conv_attr.attributeName,COALESCE(attr.valueInt,attr.valueFloat,0) AS `AttributeValue`
FROM invtypes conv
LEFT JOIN invgroups grp ON (conv.groupID=grp.groupID)
LEFT JOIN dgmtypeattributes attr ON (attr.typeID=conv.typeID)
LEFT JOIN dgmattributetypes conv_attr ON (attr.attributeID = conv_attr.attributeID)
WHERE grp.categoryID = 6