0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people studying math at any level and professionals in related fields

SELECT 
    TagName, COUNT(TagName) as counter 
FROM Tags 
    INNER JOIN PostTags ON PostTags.TagId = Tags.id
    INNER JOIN PendingFlags ON PendingFlags.Id = PostTags.PostId
WHERE 
    PendingFlags.CloseReasonTypeId = 1 OR PendingFlags.CloseReasonTypeId = 101
GROUP BY TagName 
ORDER BY counter DESC

fork query

edited dec 3

created dec 3 anonymous