--- a/reproctool.cgi	Sun Jan 25 13:14:07 2009 +0000
+++ b/reproctool.cgi	Sun Jan 25 13:33:20 2009 +0000
@@ -65,13 +65,13 @@
 	SUM(CASE WHEN m1.requiredTypeID = 40 THEN m1.quantity ELSE 0 END), -- [Megacyte]
 	SUM(CASE WHEN m1.requiredTypeID = 11399 THEN m1.quantity ELSE 0 END) -- [Morphite]
 FROM invTypes types
-INNER JOIN dgmTypeAttributes attrs ON types.typeID = attrs.typeID AND attrs.attributeID = 633
+LEFT JOIN dgmTypeAttributes attrs ON types.typeID = attrs.typeID AND attrs.attributeID = 633
 INNER JOIN typeActivityMaterials m1 ON types.typeID = m1.typeID
 INNER JOIN invGroups groups ON types.groupID = groups.groupID
 INNER JOIN eveGraphics graphics ON types.graphicID = graphics.graphicID
 WHERE $sql_typenames
 GROUP BY types.typeID
-ORDER BY groupName ASC, typeName ASC
+ORDER BY groups.categoryID DESC, groupName ASC, typeName ASC
 END
 my $pre_reprocess = $db->prepare($sql_reprocess);