select top 1000 * from PendingFlags as pf left outer join...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Cognitive Sciences Meta

Q&A about the site for practitioners, researchers, and students in cognitive science, psychology, neuroscience, and psychiatry

select top 1000 *
from PendingFlags as pf
left outer join Posts as p on pf.id = p.id
where pf.CloseReasonTypeid in (102, 103, 104, 105) and p.ParentId is null

Enter Parameters

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