Most Number of Great Questions in Java created in 2013

0

Please login or register to vote for this query.

(click on this box to dismiss)

Software Quality Assurance and Testing Meta

Q&A about the site for software quality control experts, automation engineers, and software testers

select distinct u.id as [User Link], q.Id as [Post Link], q.tags, q.score, q.answerCount, q.favoriteCount, q.viewcount
from   posts q
join   posts a on a.Id = q.Id
join   users u on u.Id = a.OwnerUserId
join   posttags  t on t.PostId = q.Id
where  (q.Score >= 100 or q.viewcount > 100000 or q.favoritecount > 100)
  and  u.Id > 0 and u.Id < 1000000
  and  t.TagId = 17
  and  q.creationdate between '2012/01/01' and '2014/02/01'
order by q.score desc

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results