Displaying 2 lists in view.list

Hi,
You can create a custom view and in their you can apply the where condition in the query.
If you know SuiteCRM coding, you can understand what I am saying

Please check these articles

And about no pagination, it is not a recommended approach to skip the pagination from any view as it will come up with many performance issues in future when your data size will increase.

Thanks