Out of memory (Needed 1048548 bytes)
QUERY: SELECT count(DISTINCT e.guid) as total FROM elgg_entities e JOIN elgg_metadata n_table on
e.guid = n_table.entity_guid JOIN elgg_metadata n_table1
on e.guid = n_table1.entity_guid JOIN elgg_metastrings msn1
on n_table1.name_id = msn1.id JOIN elgg_metastrings msv1
on n_table1.value_id = msv1.id WHERE (((msn1.string = 'status' AND BINARY msv1.string
= 'published' AND ( (n_table1.access_id IN (2)
OR (n_table1.owner_guid = -1)
OR (
n_table1.access_id = 0
AND n_table1.owner_guid = -1
)
) and n_table1.enabled='yes')))) AND ((e.type = 'object' AND e.subtype IN (4))) AND (e.site_guid IN (1)) AND ( (e.access_id IN (2)
OR (e.owner_guid = -1)
OR (
e.access_id = 0
AND e.owner_guid = -1
)
) and e.enabled='yes')