Exakat\Reports\Ambassador::getAnalyzersCount PHP Method

    private function getAnalyzersCount($limit)
    {
        $list = Analyzer::getThemeAnalyzers($this->themesToShow);
        $list = '"' . join('", "', $list) . '"';
        $query = "SELECT analyzer, count(*) AS number\n                    FROM results\n                    WHERE analyzer in ({$list})\n                    GROUP BY analyzer\n                    ORDER BY number DESC ";
        if ($limit) {
            $query .= " LIMIT " . $limit;
        }
        $result = $this->sqlite->query($query);
        $data = array();
        while ($row = $result->fetchArray(\SQLITE3_ASSOC)) {
            $data[] = array('analyzer' => $row['analyzer'], 'value' => $row['number']);
        }
        return $data;
    }