users

0

Please login or register to vote for this query.

(click on this box to dismiss)

Mythology

Q&A for enthusiasts and scholars of mythology and folklore

SELECT
  top 100
  p.Id,
  p.Score,
  p.ViewCount,
  p.OwnerUserId,
  p.CommentCount,
  p.FavoriteCount,
  (CASE WHEN EXISTS(SELECT 1 FROM posts aa WHERE aa.postTypeId = 1 and aa.AcceptedAnswerId = p.id)
    THEN 1
    ELSE 0 
  END) AS IsAcceptedAnswer
from posts p
where postTypeId = 2

--select * from posttypes
-- 1 = question
-- 2 = answer

Enter Parameters

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