Wt

This query is used alongside the actual query to retrieve the number of results. Generally this should be a query that is performed faster than the actual query.

However, currently this takes the whole query, and performs a SELECT COUNT(1) FROM with a subquery. This subquery is the original query, with all its selects. This results in a suboptimal query, where more data is actually fetched than is necessary, causing slower queries. This should be optimised such that the unnecessary selects are removed, and we perform a SELECT COUNT(1) on the original query directly, instead of using it as a subquery.