select max(UserId) as UserId from PostHistory ph where Po...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Gardening and Landscaping Meta

Q&A about the site for gardeners and landscapers

-- Enter Query Title
-- Enter Query Description
select max(UserId) as UserId from PostHistory ph where PostHistoryTypeId in (4,5) and PostId not in
 (select p.Id from Posts p where p.OwnerUserId = ph.UserId)
  group by UserId having COUNT(distinct RevisionGuid) > 453

Enter Parameters

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