0

Please login or register to vote for this query.

(click on this box to dismiss)

You need 500 edited posts to get 'Copy editor' badge and 80 edits to get 'Strunk & White' badge

Q&A about the site for Drupal developers and administrators

-- Enter Query Title
-- Enter Query Description

declare @UserId int = ##UserId##;

select count(p.Id) [Number of edited posts] from PostHistory ph
join Posts p on p.Id = ph.PostId
where ph.UserId = @UserId
GROUP BY p.Id

fork query

edited aug 3 12 DaveRandom

created may 28 11 marat.snowbear