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