select posts1.Id from Posts posts1 join ( select Id, Crea...

0

Please login or register to vote for this query.

(click on this box to dismiss)

MathOverflow

Q&A for professional mathematicians

select posts1.Id from Posts posts1
join 
(
select Id, CreationDate, OwnerUserId from Posts posts1
) a on a.OwnerUserId = posts1.OwnerUserId
where a.CreationDate < posts1.CreationDate and posts1.OwnerUserId = 4783614 and posts1.Id = 42077099
--group by posts1.Id

Enter Parameters

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