select P.Id as [Post Link], P.Body as [Parent text], C.Te...

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

select 
    P.Id as [Post Link], 
    P.Body as [Parent text], 
    C.Text as [Comment text], 
    CASE 
        WHEN P.PostTypeId = 1 THEN 'Question'
        WHEN P.PostTypeId = 2 THEN 'Answer'
    END as [Post Type]
from 
    Posts as P 
    join Comments as C on P.Id = C.PostId
where 
    C.Score >= 5
order by 
    P.Id;

Enter Parameters

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