make note on pagination and group by.