Matget.com Social: <p>The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay QUERY: SELECT distinct e.* from elgg_entities e JOIN elgg_metadata m1 on e.guid = m1.entity_guid JOIN elgg_metadata m2 on e.guid = m2.entity_guid where m1.name_id='23' and m1.value_id='8' and m2.name_id='21' and m2.value_id='2' and e.type = 'object' and e.subtype = 3 and e.site_guid = 1 and e.container_guid = 443 and (e.access_id in (2) or (e.access_id = 0 and e.owner_guid = -1)) and e.enabled='yes' order by e.time_created desc limit 0, 10000</p>

The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay QUERY: SELECT distinct e.* from elgg_entities e JOIN elgg_metadata m1 on e.guid = m1.entity_guid JOIN elgg_metadata m2 on e.guid = m2.entity_guid where m1.name_id='23' and m1.value_id='8' and m2.name_id='21' and m2.value_id='2' and e.type = 'object' and e.subtype = 3 and e.site_guid = 1 and e.container_guid = 443 and (e.access_id in (2) or (e.access_id = 0 and e.owner_guid = -1)) and e.enabled='yes' order by e.time_created desc limit 0, 10000

The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay QUERY: SELECT distinct e.* from elgg_entities e JOIN elgg_metadata m1 on e.guid = m1.entity_guid JOIN elgg_metadata m2 on e.guid = m2.entity_guid where m1.name_id='23' and m1.value_id='8' and m2.name_id='21' and m2.value_id='2' and e.type = 'object' and e.subtype = 3 and e.site_guid = 1 and e.container_guid = 443 and (e.access_id in (2) or (e.access_id = 0 and e.owner_guid = -1)) and e.enabled='yes' order by e.time_created desc limit 0, 10000