SELECT DISTINCT u.ID as UnitID, u.SortID, uc.Class FROM bn_units u LEFT JOIN bn_units_type uc ON uc.ID = u.ClassID LEFT JOIN bn_architecture a ON u.ID = a.UnitID WHERE a.AssemblyID = 8 AND u.PageID = 6 ORDER BY u.SortID ASC