Untitled

SELECT SUM(i.score * t.COUNT) AS score
FROM            search_index    i
INNER JOIN      search_total    t    ON i.word = t.word
INNER JOIN      node            n    ON n.nid = i.sid
INNER JOIN      node_access     na   ON na.nid = n.nid
WHERE   n.STATUS = 1
        AND (na.grant_view >= 1
                AND ((na.gid = 0 AND na.realm = 'all')
                        OR (na.gid = 1 AND na.realm = 'workflow_access')
                        OR (na.gid = 0 AND na.realm = 'workflow_access_owner')))
        AND (i.word = 'sghsfghnsf')
        AND i.TYPE = 'node'
GROUP BY i.TYPE, i.sid
HAVING COUNT(*) >= 1
ORDER BY score DESC LIMIT 0, 1