progress towards Research Assistant badge

3

Please login or register to vote for this query.

(click on this box to dismiss)

Counts the number of distinct tag wikis that you've edited.

Motor Vehicle Maintenance and Repair Meta

Q&A about the site for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles

select
    COUNT(DISTINCT Posts.Id) as TagWikisEdited,
    CAST(CONVERT(DECIMAL(5,2), COUNT(DISTINCT Posts.Id) * 2.0)  as VARCHAR(6)) + '%' as Progress
from SuggestedEdits as Edit
LEFT JOIN Posts on Edit.PostId=Posts.Id
WHERE Edit.OwnerUserId=##UserID:int##
AND Posts.PostTypeId = 5
AND Edit.ApprovalDate is not null

Enter Parameters

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