closed users who stayed

0

Please login or register to vote for this query.

(click on this box to dismiss)

Genealogy and Family History Meta

Q&A about the site for expert genealogists and people interested in genealogy or family history

select * from posts p1
inner join 
(select owneruserid, min(id) as id from posts p2 
where p2.closeddate is not null and p2.id = (select min(id) from posts p4 where p2.owneruserid = p4.owneruserid)
  group by owneruserid) p3
on p3.owneruserid = p1.owneruserid and p3.id <> p1.id
where posttypeid = 1

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results