Boulder Co, athletic locals: <p>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 QUERY: SELECT distinct e.* from elggentities e JOIN elggmetadata m1 on e.guid = m1.entity_guid JOIN elggmetadata m2 on e.guid = m2.entity_guid where m1.name_id='' and m1.value_id='8' and m2.name_id='' and m2.value_id='2' and e.type = 'object' and e.site_guid = 1 and e.container_guid = 70 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 MAX_JOIN_SIZE=# if the SELECT is okay QUERY: SELECT distinct e.* from elggentities e JOIN elggmetadata m1 on e.guid = m1.entity_guid JOIN elggmetadata m2 on e.guid = m2.entity_guid where m1.name_id='' and m1.value_id='8' and m2.name_id='' and m2.value_id='2' and e.type = 'object' and e.site_guid = 1 and e.container_guid = 70 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 MAX_JOIN_SIZE=# if the SELECT is okay QUERY: SELECT distinct e.* from elggentities e JOIN elggmetadata m1 on e.guid = m1.entity_guid JOIN elggmetadata m2 on e.guid = m2.entity_guid where m1.name_id='' and m1.value_id='8' and m2.name_id='' and m2.value_id='2' and e.type = 'object' and e.site_guid = 1 and e.container_guid = 70 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