[eluser]LuckyFella73[/eluser]
The pagination library just need to know how many rows there are
available totally and how many rows you want to display per page
to calculate how many links (pages) to create (and how to set up the pagination-links).
The second query gets the data for the actual page based on the given
values (per page, start page). The query to generate the pagination
links is generally undependent from the query getting the data to display
in your view. You just have to make sure that the num-per-page value and
the "start-from" value in your "view-query" matches with the pagination
config value to get a result set and pagination links that make sense.
Sorry, for I'm no native english speaker it's not so easy to express
clearly what I'm trying to ...