How can I use a join to paginate the model?

Hello there,

There is nothing wrong with the query. I am writing for the query in my first message. I can't join the model and this is a very serious problem.

The solution I'm looking for:

There will be both where and join, order by and pagination. How can I do it ?

Can you show me an example based on the first message?

Thank you.