# إيجاد جميع المواضيع غير الموسومة

**URL:** https://meta.discourse.org/t/finding-all-untagged-topics/237958
**Category:** Data & reporting
**Tags:** sql-query
**Created:** [2 سبتمبر 2022، 5:25م UTC](https://meta.discourse.org/t/finding-all-untagged-topics/237958 "2022-09-02T17:25:44Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![Ben\_Garrison](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/ben_garrison/32/241789_2.png) [@Ben\_Garrison](https://meta.discourse.org/u/Ben_Garrison)
#### Post date: [2 سبتمبر 2022، 5:25م UTC](https://meta.discourse.org/t/finding-all-untagged-topics/237958/1 "2022-09-02T17:25:44Z")

</div>

أبحث عن استعلام باستخدام مستكشف البيانات للحصول على جميع المواضيع غير المصنفة.

---

<div class="post-metadata">

### Author: ![RGJ](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/rgj/32/523185_2.png) [@RGJ](https://meta.discourse.org/u/RGJ)
#### Post date: [2 سبتمبر 2022، 5:40م UTC](https://meta.discourse.org/t/finding-all-untagged-topics/237958/2 "2022-09-02T17:40:44Z")

</div>

```sql
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

```

---

<div class="post-metadata">

### Author: ![JammyDodger](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/jammydodger/32/254611_2.png) [@JammyDodger](https://meta.discourse.org/u/JammyDodger)
#### Post date: [2 سبتمبر 2022، 5:46م UTC](https://meta.discourse.org/t/finding-all-untagged-topics/237958/3 "2022-09-02T17:46:39Z")

</div>

كنت سأضيف القليل من “غير محذوف” و “غير PM” 🙂

```sql
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

```

---

<div class="post-metadata">

### Author: ![Ben\_Garrison](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/ben_garrison/32/241789_2.png) [@Ben\_Garrison](https://meta.discourse.org/u/Ben_Garrison)
#### Post date: [2 سبتمبر 2022، 6:01م UTC](https://meta.discourse.org/t/finding-all-untagged-topics/237958/4 "2022-09-02T18:01:43Z")

</div>

> [@JammyDodger](#):
>
> ` `

هذا مفيد للغاية.. أنت و @RGJ.. شكراً لك!

---

<div class="post-metadata">

### Author: ![system](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/system/32/443519_2.png) [@system](https://meta.discourse.org/u/system)
#### Post date: [2 أكتوبر 2022، 6:02م UTC](https://meta.discourse.org/t/finding-all-untagged-topics/237958/5 "2022-10-02T18:02:03Z")

</div>

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