0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for gardeners and landscapers

SELECT
  p1."Id" as [Post Link],
  p1.*, 
  p2."Id" as [Post Link],
  p2."Id" as [Post Link],
  p2."Score" as "p2Score",
  p2."Body" as "p2Body",
  p2."OwnerUserId" as "p2UserId",
  p2."OwnerDisplayName" as "p2OwnerDisplayName",
  p2."CommentCount" as "p2CommentCount"
FROM 
   posts p1,
   posts p2
WHERE 
   p1."ParentId" IS NULL AND p1."AcceptedAnswerId" IS NOT NULL
   AND p1."AcceptedAnswerId" = p2."Id"
AND (p1.Tags LIKE '%compiler-errors%' OR p1.Tags LIKE '%compiler-warnings%')
AND p1."Body" LIKE '%reason:%'
ORDER BY p1."Score" DESC

fork query

edited may 13 17

created feb 25 17 Titus.Barik