The pagination is what applies the limits to the themes (causing the
unsupported SQL).

In actuality, those limits shouldn't even apply to the filter options
(it would restrict the filters to things on the current page, rather
than over the entire search).