Google maps questions with at least 10 answers


Please login or register to vote for this query.

(click on this box to dismiss)



select i.Id, i.CreationDate, i.Title, i.Tags, i.AcceptedAnswerId, i.Score, 
   i.Reputation, i.ViewCount, i.AnswerCount, i.CommentCount, i.ClosedDate,

from (

Select Distinct p.Id, p.CreationDate, p.Title, p.Tags, p.AcceptedAnswerId, p.Score, 
   p.ViewCount, p.AnswerCount, p.CommentCount, p.ClosedDate,
   CONCAT('', p.Id) as Link, u.Reputation
From Posts p 
 Inner Join PostTags pt on p.Id = Pt.PostId
 Inner Join Tags t on pt.TagId = t.Id
 Inner Join Users u On p.OwnerUserId = u.Id
 Where t.TagName in ('google-maps')
And p.PostTypeId = 1  -- Question

-- ) i; -- All
) i Where i.AnswerCount >= 10 -- At least 10 answers
-- ) i Where i.AnswerCount = 0 and i.CommentCount > 0; -- No answer, but comment
-- ) i Where i.Score <= 0; -- Non-positive score
Order by i.Score desc, i.Reputation desc, i.CreationDate desc;

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results