[SOLVED]$this->db->count_all() in pagination issue

[eluser]Marlbor0[/eluser]
Hello,
After some time spent on google i cant find the right way to do this, i have a custom sql select with joins to make a list of all my products, that select dont pick up products that dont have a manufacturer, so not all the records are taken from the db.

For the pagination, i need to set the max resuts so it can generate enought "pages" but with $this->db->count_all() i get all the data, i tried using $this->db->where() before counting the results but no go.

Is there a simple way, or right way to use pagination with custom query?