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