Edit History by casperOne

0

Please login or register to vote for this query.

(click on this box to dismiss)

Total edit history by casperOne

Network Engineering

Q&A for network engineers

-- Edit History by casperOne
-- Total edit history by casperOne

select
    t.Year, t.PostHistoryTypeId 
from
    (
        select
            year(ph.CreationDate) as Year, ph.PostHistoryTypeId
        from
            Posts as p
                inner join PostHistory as ph on ph.PostId = p.Id
        where
            ph.UserId = 50776
    ) as t
group by
    t.Year, t.PostHistoryTypeId

Enter Parameters

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