SELECT
  concepts.Id,
  fsn,
  PathLength
FROM 
  concepts JOIN transitiveclosure 
    ON concepts.Id = transitiveclosure.SubtypeId
WHERE
  `transitiveclosure`.`SupertypeId` = 364708003 AND
   concepts.active = 1
ORDER BY
   PathLength, fsn
