Different Results When Using ez_results

I have no problems using ez_results with smarty. However, I seem to have this problem when using the following sql query.

SELECT DISTINCTROW lab_ID, lab_title FROM t01_label
INNER JOIN t01_stock ON t01_stock.sto_lab_ID = t01_label.lab_ID
WHERE t01_stock.sto_qty > 0 ORDER BY lab_title

When I run the above query from phpMyAdmin, I get 1221 results. However, using it on my page using ez_results.smarty.php, I get 2089 results with 141 pages of 20 results on each page.

Page 63 onwards will show empty page, though the navigation will show up to Page 141. What seems to be the problem?

I have also experience incorrect results when using MySQL's "GROUP BY" statement in a query.

Any help is appreciated.