Comment count

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 2000 c.postid, c.id, c.score, c.text, c.creationdate, u.id, u.age, u.reputation, u.upvotes, u.downvotes
from comments c, posts p, users u
where c.postid=p.id and c.userid=u.id
and u.age is not null and u.age between 15 and 70
and u.reputation between 2 and 100000
and p.ClosedDate is Null
-- and there are at least three discussants on the post
and p.id in (select p.id 
      from posts p2, comments c2 
      where p2.id=c2.postid
      group by p2.id
      having count(distinct c2.userid)=3)



--(select p.id 
--      from posts p2, comments c2 
--      where p2.id=p.id and p.id=c2.postid and c2.userid=u.id
--      group by p2.id
--      having count(distinct c2.userid)=3)

Enter Parameters

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