Give Me a Challenge Already!!

0

Please login or register to vote for this query.

(click on this box to dismiss)

Popular and Open yet Unanswered Difficult Questions

History

Q&A for historians and history buffs

-- Unanswered questions with high views + high votes, by tag
--
-- List all questions with:
--  - an open state (unanswered and not closed/merged/etc...),
--  - a high score (default: > 10),
--  - a high view count (default: > 100),
--  - a low answer count (default: 0),
--  - a specific tag (default: '%' to match all).

select
  top 500 Posts.Id as [Post Link], Score, ViewCount, Tags, ClosedDate
from Posts
where
  Score > ##Score:int?10##
  and ViewCount > ##ViewCount:int?100##
  and ParentId is null
  and AcceptedAnswerId is not null
  and AnswerCount >= ##AnswerCount:int?0##
  and Tags LIKE '%<##TagName1?%##>%'
  and Tags LIKE '%<##TagName2?%##>%'
  and ClosedDate is null
order by ViewCount desc

Enter Parameters

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