现在,我试图在ONE查询中获取所有数据,包括文章主题、每篇文章的标记和每篇文章的注释数量。我现在使用的sql查询是 articles.subject, GROUP_CONCAT(tags.name) AS tags, COUNT(comments.aid) AS commentsFROM articles LEFT JOIN rela
我想通过_id of articleComment和commentId of articleReply找到articleReply value。我只找到articleComment值,找不到articleReply值。{_id=60b312a73df6b758e09396d7, territoryId=1, articleId=60ac9e9a3df6b7312c4cbab0, userId=2, userAccount=163397@qq.com
由于合并了以下表格,我有两个表: -Aid bigint -Email nvarchar(500)
-ArIdvarchar(50) -……Some other fields……
-ArId varchar(50) -Year int
-FieldId int
-ArId varchar(50) (Foreign ke