Optimize civicrm search by restricting the BIG query to only relevant contact ids ..

Improve the query that gets all the data by restricting it to the relevant contact ids. We can get all the contacts ids by a much smaller (and hence faster) query which does not need all the LEFT JOIN's. This potentially is a bit of problem with the order clause, so we might have to restrict its usage if we cannot figure out what tables to add (with profile search views etc)