discourse:master
← discourse:queued_posts_count
opened 05:46PM - 21 Jun 21 UTC
In #12841, we started setting the `ReviewableQueuedPost`'s target and topic afte…r approving it instead of storing them in the payload. As a result, the reviewable_counts query started to include queued posts.
When a category is set to require approval, every post has an associated reviewable. Pointing that each post has an associated queued post is not necessary in this case, so I added a WHERE clause to skip them.