0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people who love outdoor activities, excursions, and outdoorsmanship

select top 50000 p1.id as p1_Id
from ((posts as p1 left join posts as p2 on p1.id=p2.parentid) left join
users as u1 on p1.OwnerUserId = u1.id) left join users as u2 on
p2.OwnerUserId = u2.id
where p1.PostTypeID = 1 and p1.CreationDate > '2018-02-06' and
p1.CreationDate < '2018-05-06'
order by p1.CreationDate desc

fork query

edited jul 15

created jul 15 anonymous