0

Please login or register to vote for this query.

(click on this box to dismiss)

Shows Nicholas Paldino's edit history from 7/1/2010 - now on content that is not his own

Q&A for anime and manga fans

-- Enter Query Title
-- Enter Query Description

select 
    pht.Name as PostHistoryType, ph.* 
from 
    PostHistory as ph
        inner join PostHistoryTypes as pht on pht.Id = ph.PostHistoryTypeId
        inner join Posts as p on p.Id = ph.PostId
where
    ph.UserId = 50776 and
    ph.CreationDate >= '2010-07-01' and
    pht.Id <> 2 and
    p.OwnerUserId <> 50776

fork query

created jul 6 11 casperOne