Ok, if you run the query in a MySQL client as command line or PHPMyAdmin do you get results?
If the answer is yes, then are you sure that $_GET['pagination']
is correctly populated by your .htaccess rewrite rules?
To test it just try:
print_r($_GET);
to see the contents of this array.