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