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 = 5
						ORDER BY u.SortID ASC