My comments on new user questions

1

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select parent.id as [Post Link], comments.id as [Comment Id], comments.score as [Score] from comments join (select p.id from posts p inner join users u 
on (p.ownerUserId=u.id) 
and (DATEDIFF(d, u.CreationDate, p.CreationDate) < 3)
where p.postTypeId = 1) parent 
ON parent.id = comments.postId 
and comments.userId=##UserId##
order by comments.score desc;

Enter Parameters

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