Hunting to close : questions seeking for recomendations and flag them efficiently

1

Please login or register to vote for this query.

(click on this box to dismiss)

Questions asking for recommendations or any off-site resources are off-topic on StackOverflow as they tend to attract opinion-based answers, or spam. Use this query to edit to make them suitable for the site. I realize most of them can't be salvageable through editing. So let's increase your helpful flag counter!

Stack Overflow

Q&A for programmers

select
   Posts.Id as [Post Link], -- Question title.
   Count(PendingFlags.PostId) as [Number of pending flags], -- Number of pending flags per questions.
   LEN(body) as [PostQuality], -- The smaller is the bofy the higher is the chance the post don't describe it's problem.
   Posts.OwnerUserId as [User Link], -- Let click on the colum to see if the same user ask off-topic questions often.
   Reputation as [User Reputation], -- Interesting to see that such questions are sometimes asked by high rep users.
   Posts.Score as [Votes], -- Interesting to see that some questions have more than 100 upvotes.
   Posts.AnswerCount as [Number of Answers], -- I thought we shouldn't answer on off-topic post.
   Posts.FavoriteCount as [Number of Stars], -- Some questions seems to be very helpfull :) .
   Posts.CreationDate as [Asked on], -- The older is the question, the more is the chance that flags on them can't get reviewed.
   Posts.LastActivityDate as [last activity], -- Similar effect as with Posts.CreationDate.
   Posts.LastEditDate as [modified on],
   Posts.ViewCount -- How many peoples were too dumb to not close the question.
from posts 
   LEFT OUTER JOIN Users on Users.id = posts.OwnerUserId
   LEFT OUTER JOIN PendingFlags on PendingFlags.PostId = Posts.Id
where ClosedDate IS NULL -- The question is not closed.
   AND LEN(body)<=##PostQuality:int?172## -- PostQuality: Number of characters in the question "IF YOU INCREASE THIS PARAMETER, YOU WILL FIND MORE OFF-TOPIC QUESTIONS, BUT YOU'LL ALSO INCREASE THE FALSE POSITIVE PERCENTAGE"
   AND ((LOWER(title) like '%best tool%') or (LOWER(title) like '%best utility%') or (LOWER(title) like '%best library%') or (LOWER(title) like '%best alternative%') OR (LOWER(title) like '%good tool%') or (LOWER(title) like '%good utility%') or (LOWER(title) like '%good library%') or (LOWER(title) like '%good alternative%') OR (LOWER(title) like 'is there a tool%') or (LOWER(title) like '%is there an utility%') or (LOWER(title) like '%an alternative%') or (LOWER(title) like '%is there an open source%') or (LOWER(title) like '%is there a utility%') or (LOWER(title) like '%is there a library%') or (LOWER(title) like '%any library%') or (LOWER(title) like '%any tool%') or (LOWER(title) like '%any utility%') or (LOWER(title) like '%any library%') or (LOWER(title) like '%any alternative%') or (LOWER(title) like '%any open source%') or (LOWER(title) like '%do you know%') or (LOWER(title) like '%does anyone know a%')) -- criterias for finding questions with a high probabilty to be opinion-based.
group by Posts.id, Posts.OwnerUserId, body, Reputation, Posts.Score, Posts.FavoriteCount, Posts.AnswerCount, Posts.CreationDate, Posts.LastActivityDate, Posts.LastEditDate, Posts.ViewCount
order by Count(PendingFlags.PostId) desc; -- Questions with more flags have more chance to get them handled, and the higher is the probabilty that the question is off-topic (since several users already reviewed the question).

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results