Cannot paginate SQL query with sub-SELECT.

[MikuAuahDark]

Consider this query:

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.