You left your sql queries for the world to see and this one is a tad bit slow:

SELECT count(DISTINCT domain.id) FROM domain, action WHERE action.domain_id = domain.id AND action.user_id IS NULL AND domain.categories like ' %reference% '