pagination with filters

How do I do pagintation with filters where the filters need information from ANOTHER table?

Imagine Tinder where you have a users table, and a 'swipes' table.

And let's say you wanna get only users you have not swiped on.

You wanna build the UI where you can swipe left and right.

How would you paginate this?
Was this page helpful?