add order by and use predentindexnum to filter the result