;with allusers as ( select id , creationdate , (select mi...


Please login or register to vote for this query.

(click on this box to dismiss)

Ask Different

Q&A for power users of Apple hardware and software

;with allusers as (
select id
     , creationdate
     , (select min(id) id from Users where id > u.id) nid
from users u
where id > 0
SELECT top 1000
  curr.id as [User Link]
, curr.id
, curr.creationdate
, next.id
, next.creationdate
, next.id as [User Link]
, 'site://users/history/' + CAST(next.id AS nvarchar) + '?type=Moderator+merges+users|Merge history'
From AllUsers curr
inner join allusers next on curr.nid = next.id
where curr.creationdate > next.creationdate

ORDER BY curr.creationdate desc

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results