这行告诉我错误：
错误：select列表的表达式#1不在group by子句中，并且包含未聚合列“hng#u 1.tags.id”，该列在功能上不依赖于group by子句中的列；这与sql\u mode=only\u full\u group by不兼容

foreach($groups as $group)
    {
            $query = mysqli_query($verbindung, "SELECT * FROM (SELECT *, COUNT(id) AS c FROM tags WHERE typ='" . mysqli_real_escape_string($verbindung, $group) . "' GROUP BY slug ORDER BY c DESC LIMIT 9) AS i ORDER BY i.tag ASC") or die("Error: " . mysqli_error($verbindung));

            while ($row = mysqli_fetch_array($query)) {
                    $tmp_tags[] = $row;
            }
    }

如何更改查询以修复此错误？