MySQL语法错误；检查与您的 MySQL 服务器版本对应的手册，了解在第 4 行 ')' 附近使用的正确语法

Question

我收到下面列出的以下 mySQL 错误，想知道如何修复它。

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 4

下面是我的 MySQL 代码。

$q = "SELECT COUNT(DISTINCT tags.tag) FROM tags INNER JOIN articles_tags ON articles_tags.tag_id = tags.id INNER JOIN users ON articles_tags.user_id = users.user_id WHERE users.active IS NULL AND users.deletion = 0";
$r = mysqli_query ($mysqli, $q) or trigger_error("Query: $q\n<br />MySQL Error: " . mysqli_error($mysqli));
$row = mysqli_fetch_array ($r);
$records = $row[0];

这是我的表格。

CREATE TABLE tags (
id INT UNSIGNED NOT NULL AUTO_INCREMENT,
tag VARCHAR(255) NOT NULL,
PRIMARY KEY (id)
);


CREATE TABLE articles_tags (
id INT UNSIGNED NOT NULL AUTO_INCREMENT,
tag_id INT UNSIGNED NOT NULL,
article_id INT UNSIGNED NOT NULL,
user_id INT UNSIGNED NOT NULL,
date_created DATETIME NOT NULL,
unique_id CHAR(32) NOT NULL,
PRIMARY KEY (id),
UNIQUE KEY (tag_id, unique_id)
);

Answer 1

查询似乎没问题...我想这可能是一个问题，因为 DISTINCT 函数...
试试这个:

$q = "SELECT COUNT(tags.tag) FROM tags INNER JOIN articles_tags ON articles_tags.tag_id = tags.id INNER JOIN users ON articles_tags.user_id = users.user_id WHERE users.active IS NULL AND users.deletion = 0 GROUP BY tags.tag";