WITH CandidatePosts AS ( select ParentId postId from post...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

WITH CandidatePosts AS (
select ParentId postId
from 
   posts p
where
   p.OwnerUserId = 1744834
  and p.postTypeId = 2
  and p.score > 0
)
select p1.id as [Post Link], p1.ownerUserId as [User Link], body
from posts p1
join CandidatePosts cp on cp.postId = p1.parentId
where p1.ownerUserId <> 1744834
order by p1.Score DESC

Enter Parameters

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