Title-only edits by somebody else than the post author

0

Please login or register to vote for this query.

(click on this box to dismiss)

Meta Stack Exchange

Q&A for meta-discussion of the Stack Exchange family of Q&A websites

SELECT ph.PostId AS [Post Link], ph.CreationDate AS 'Title-only edit on'
  FROM PostHistory AS ph
  INNER JOIN Posts AS p
    ON ph.PostId = p.Id
  LEFT OUTER JOIN PostHistory AS ph1
    ON ph.RevisionGUID = ph1.RevisionGUID
   AND ph1.PostHistoryTypeId = 5 -- Edit Body
  WHERE p.OwnerUserId = ##UserId:int##
    AND ph.PostHistoryTypeId = 4 -- Edit Title
    AND ph.UserId != p.OwnerUserId -- by somebody else
    AND ph1.Id IS NULL
  ORDER BY ph.CreationDate DESC

Enter Parameters

Options:
Switch sites
loading Hold tight while we fetch your results