QUERY: SELECT count(DISTINCT e.guid) as total FROM elgg_entities e JOIN elgg_users_entity ue ON e.guid = ue.guid WHERE (MATCH (ue.username,ue.name) AGAINST ('+@tonaymemi.cat' IN BOOLEAN MODE)) AND ((e.type = 'user')) 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')