0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for anime and manga fans

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

fork query

created oct 28 11 genesis