if i include the PK field then i do not get the distinct values, just using order by gives me an error.