Own post edits

0

Please login or register to vote for this query.

(click on this box to dismiss)

Drupal Answers

Q&A for Drupal developers and administrators

SELECT PostHistoryTypes.name, PostHistory.*, Posts.Id as [Post Link]
FROM PostHistory , Posts, PostHistoryTypes
WHERE 
PostHistoryTypes.id = PostHistory.PostHistoryTypeId AND
PostHistory.UserId = ##UserId##  AND
Posts.OwnerUserId = ##UserId## AND
Posts.Id = PostHistory.PostID AND
PostHistory.PostHistoryTypeId IN (4,5,6); -- title, tags, body

Enter Parameters

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