Google maps questions with at least 10 answers

0

Please login or register to vote for this query.

(click on this box to dismiss)

スタック・オーバーフローMeta

プログラマーと熱狂的なプログラマーのためのサイトに関する質問と回答

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

from (

Select Distinct p.Id, p.CreationDate, p.Title, p.Tags, p.AcceptedAnswerId, p.Score, 
   p.ViewCount, p.AnswerCount, p.CommentCount, p.ClosedDate,
   CONCAT('http://stackoverflow.com/questions/', 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

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