Cannot paginate SQL query with sub-SELECT.

Consider this query:
```sql
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.