SELECT * FROM foo WHERE bar_id IN (SELECT id FROM bar) LIMIT 0,30
The paginator will try to find the count by running SELECT COUNT(*) AS count FROM bar). Note the trailing closing parenthesis and the wrong table. This result in the pagination no longer works due to SQL syntax error.
Consider this query:
The paginator will try to find the count by running
SELECT COUNT(*) AS count FROM bar). Note the trailing closing parenthesis and the wrong table. This result in the pagination no longer works due to SQL syntax error.