WordPress database error: [The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay]
SELECT SQL_CALC_FOUND_ROWS XYUUf_posts.ID
FROM XYUUf_posts LEFT JOIN XYUUf_term_relationships ON (XYUUf_posts.ID = XYUUf_term_relationships.object_id) LEFT JOIN XYUUf_postmeta ON ( XYUUf_posts.ID = XYUUf_postmeta.post_id ) LEFT JOIN XYUUf_postmeta AS mt1 ON ( XYUUf_posts.ID = mt1.post_id AND mt1.meta_key = 'rental' )
WHERE 1=1 AND (
NOT EXISTS (
SELECT 1
FROM XYUUf_term_relationships
INNER JOIN XYUUf_term_taxonomy
ON XYUUf_term_taxonomy.term_taxonomy_id = XYUUf_term_relationships.term_taxonomy_id
WHERE XYUUf_term_taxonomy.taxonomy = 'objecttype'
AND XYUUf_term_relationships.object_id = XYUUf_posts.ID
)
AND
XYUUf_term_relationships.term_taxonomy_id IN (125)
AND
NOT EXISTS (
SELECT 1
FROM XYUUf_term_relationships
INNER JOIN XYUUf_term_taxonomy
ON XYUUf_term_taxonomy.term_taxonomy_id = XYUUf_term_relationships.term_taxonomy_id
WHERE XYUUf_term_taxonomy.taxonomy = 'district'
AND XYUUf_term_relationships.object_id = XYUUf_posts.ID
)
) AND (
( XYUUf_postmeta.meta_key = 'rental' AND XYUUf_postmeta.meta_value = '' )
OR
mt1.post_id IS NULL
) AND XYUUf_posts.post_type = 'page' AND ((XYUUf_posts.post_status = 'publish'))
GROUP BY XYUUf_posts.ID
ORDER BY XYUUf_posts.post_date DESC
LIMIT 0, 1
