Affects Version/s: 1.5
Fix Version/s: 1.6
Fixed conditions should never be in the ON clause of a JOIN.
Example fixed conditions:
civicrm_location.entity_table = 'civicrm_contact'
civicrm_email.is_primary = 1
civicrm_location.is_primary = 1
These are all in the ON clause of their JOINs. The queries will speed up immensely if you move them to where the they belong, the WHERE clause.