i ended up in a situation where i had to use QoQ but my pagination is not working because i used limit and offset in mysql anyone can guide what could be the best approach i can use to fix it

fix it

You don't actually tell us what's broken. Once again, Gavy, you need to stop assuming we know what's going on a) in your code; b) in your head. We are not clairvoyant. Ask proper questions. How often have I pointed you to http://www.catb.org/~esr/faqs/smart-questions.html and http://sscce.org/? You just perpetually ignore advice as to how to articulate your problems clearly.

@Adam Cameron right, i need to rephrase my questions, i am learning better but still a long way to go, also i did solved the issue by removing QoQ and going on a different route to fix it