查找所有未标记的主题

数据与报告
1

我正在寻找一个使用数据资源管理器（Data Explorer）来获取所有未标记主题的查询。

2 
SELECT t.id AS topic_id
FROM topics t
LEFT JOIN topic_tags tt ON tt.topic_id = t.id
WHERE tt.tag_id IS NULL
3 个赞
3

我本来想加一点“未删除”和“非 PM”的 :slight_smile:

SELECT t.id AS topic_id
FROM topics t
LEFT JOIN topic_tags tt ON t.id = tt.topic_id
WHERE tt.tag_id IS NULL
AND t.deleted_at IS NULL
AND t.archetype = 'regular'
ORDER BY topic_id DESC
3 个赞
4

这非常有帮助……你和 @RGJ 都帮了大忙……谢谢！

1 个赞
5

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.