Posts edited by the user, excluding own posts

1

Please login or register to vote for this query.

(click on this box to dismiss)

Craft CMS Meta

Q&A about the site for administrators, end users, developers and designers for Craft CMS

select h.postid as [Post Link], h.creationdate as [Edit Date] from posthistory h, posts p
where
h.userid=##UserID## and h.posthistorytypeid in (4,5,6)
and p.id=h.postid
and p.owneruserid <> ##UserID##
order by [Edit Date] desc

Enter Parameters

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