Ships by Race and class

From EVEDev

This Mysql 5.x query will fetch all ships by race and class (including faction ships)

SELECT
   t.*, 
   g.groupName,
   r.raceName,
   m.marketGroupName marketGroupName,
   mp.marketGroupName marketParentGroupName
FROM
  chrRaces AS r INNER JOIN
  invTypes AS t ON r.raceID = t.raceID INNER JOIN
  invGroups AS g ON t.groupID = g.groupID LEFT OUTER JOIN
  invMarketGroups AS m ON t.marketGroupID = m.marketGroupID LEFT JOIN
  invMarketGroups AS mp ON m.parentGroupID = mp.marketGroupID 
WHERE
  g.categoryID = 6 AND t.published = 1
ORDER BY
  t.typeName ASC