select
    user, count(*) as hits
from ...
where keyword in ('Architect', 'Sydney', 'Small')
group by user
order by hits desc