# Review queue priority adjustment

**URL:** <https://meta.discourse.org/t/review-queue-priority-adjustment/235006>\
**Category:** Product Support\
**Created:** [August 3, 2022, 2:20pm UTC](https://meta.discourse.org/t/review-queue-priority-adjustment/235006 "2022-08-03T14:20:01Z")\
**Posts on this page:** 1\
**Showing post:** 5

<div class="post-metadata">

**Author:** ![tshenry](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/tshenry/32/119495_2.png) [@tshenry](https://meta.discourse.org/u/tshenry)\
**Post date:** [August 10, 2022, 7:16pm UTC](https://meta.discourse.org/t/review-queue-priority-adjustment/235006/5 "2022-08-10T19:16:51Z")

</div>

The UI and settings don’t currently allow for that level of granularity. With that said, you can use the [Data Explorer](https://meta.discourse.org/t/32566?silent=true) to get a sorted list of currently queued _topics_.

Unfortunately there’s no way to identify if a _reply_ was queued from a watched word or category setting, so I’ve excluded queued replies from the results.

> **Description:** List all pending queued topics sorted by watched word first, then by most recent. The first column specifies why the topic was queued, the second links to the reviewable, and the third shows how long ago the topic was queued.

```sql
SELECT
  CASE WHEN category_id IS NOT NULL THEN 'Category Queued Topic or Post' ELSE 'Watched Word' END,
  concat('<a href="/review/', id, '">', payload::json->>'title', '</a>') AS html$topic_reviewable_link,
  created_at AS reltime$created_at
FROM reviewables
WHERE type = 'ReviewableQueuedPost'
  AND status = 0
  AND payload::json->>'title' IS NOT NULL
ORDER BY category_id DESC, created_at DESC

```

The results will look like this:

 ![Screen Shot 2022-08-10 at 12.13.34 PM](https://global.discourse-cdn.com/meta/original/4X/7/0/d/70d6d381c4b6890a54f7f125a7e2f41a41d494e7.png)

I realize it’s not a perfect solution, but if things have piled up and you need a quick way to sort things, this will hopefully help!

---

_[View the full topic](https://meta.discourse.org/t/review-queue-priority-adjustment/235006)._