Swiftriver\EventHandlers\TagClusteringEventHandler::ScoreForAccurateContentSql PHP Method

    private function ScoreForAccurateContentSql($contentIds)
    {
        $idString = $this->IdsToString($contentIds);
        return "select\n                c.id as 'contentId',\n                SUM(a.tagCount) /\n                    (\n                        select\n                            count(*)\n                        from\n                            SC_Content_Tags ct join SC_Content c\n                                on ct.contentId = c.id\n                        where\n                            c.state = 'accurate'\n                    ) as 'score'\n            from\n                (\n                    select\n                        t.id as 'tagId',\n                        t.text as 'tagText',\n                        count(t.id) as 'tagCount'\n                    from\n                        SC_Tags t\n                            join SC_Content_Tags ct on t.id = ct.tagId\n                                join SC_Content c on c.id = ct.contentId\n                    where\n                        c.state = 'accurate'\n                    group by\n                        t.id\n                ) a\n                join SC_Content_Tags ct on a.tagId = ct.tagId\n                    join SC_Content c on ct.contentId = c.id\n            where\n                a.tagCount > 1\n                and\n                c.id in {$idString}\n            group by\n                c.id";
    }