Target questions for "canonical" vs "fastest-gun" answers

1

Please login or register to vote for this query.

(click on this box to dismiss)

based off http://meta.stackexchange.com/questions/171172/stack-overflow-technology-makes-me-write-bad-answers - 2+ upvotes - ? 0 answers? No. Don't -care number of A. - Tags with average number of followers == ??? --- maybe contains a tag from my favorites? --- http://data.stackexchange.com/unix/query/356006/my-tags-by-post-count ---- maybe posts where all of the tags are middle-of-the-road counts for me? or high counts? ---- at least one of the tags? - not closed - not community-owned - posted in the last month - at least one favorite - adhoc - less than 6 answers (maybe HNQ activity) posts where one of their tags is in: (SELECT TOP 20 T.Id FROM Tags T, PostTags Pot, Posts P, Users U, PostTypes Pt WHERE U.Id = P.OwnerUserId AND Pt.Id = P.PostTypeId AND P.OwnerUserId = ##user:int?117549## AND Pot.PostId = P.ParentID AND T.Id = Pot.TagId GROUP BY T.Id)

Stack Overflow

Q&A for professional and enthusiast programmers

select DISTINCT Id as [Post Link], Body, Score, Tags, AnswerCount, FavoriteCount, 
DATEDIFF(Day, CreationDate, GETDATE()) As Age
FROM Posts
JOIN posttags ON posts.id = posttags.postid
where 
PostTypeId = 1 -- Question
and Score > 1
and Score < 45 -- arbitrary knob
and ClosedDate IS NULL -- not closed
and CommunityOwnedDate IS NULL -- not Community Wiki
and FavoriteCount > 0
and DATEDIFF(Day, CreationDate, GETDATE()) < 60 -- arbitrary knob
and AnswerCount < 6 -- arbitrary knob
and Body NOT LIKE ##user:int?117549## -- gratuitous clause to get my userid
and posttags.tagid IN (
  SELECT TOP 20 T.Id
  FROM Tags T, PostTags Pot, Posts P, Users U, PostTypes Pt
  WHERE U.Id = P.OwnerUserId
  AND Pt.Id = P.PostTypeId
  -- user: Your user ID "to collate posts with tags you've answered on"
  AND P.OwnerUserId = ##user:int?117549##
  AND Pot.PostId = P.ParentID
  AND T.Id = Pot.TagId
  GROUP BY T.Id
)
ORDER BY Tags ASC

Enter Parameters

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