1

Please login or register to vote for this query.

(click on this box to dismiss)

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

fork query

edited mar 7 14

created mar 7 14 jon.doe12549