answers for https://judaism.meta.stackexchange.com/a/4103

0

Please login or register to vote for this query.

(click on this box to dismiss)

Mi Yodeya

Q&A for those who base their lives on Jewish law and tradition and anyone interested in learning more

select id as [Post Link] , owneruserid from posts p
where posttypeid= 2
and parentid in(select postid from  votes where creationdate<cast(p.creationdate as date)
group by postid having 1<SUM( Case when VoteTypeId = 2 then 1 when VoteTypeId = 3 then -1 end))
and id=(select min(id) from posts where parentid=p.parentid)
and score>2
and creationdate>='2016-08-09'
and parentid in(select id from posts where dateadd(m,6, creationdate)<p.creationdate)
order by 2

Enter Parameters

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