Most Views

0

Please login or register to vote for this query.

(click on this box to dismiss)

Emacs

Q&A for those using, extending or developing Emacs

SELECT Posts.Id, Posts.Title,Posts.AcceptedAnswerId,Posts.CreationDate,Posts.DeletionDate,Posts.Score,Posts.ViewCount,Posts.OwnerUserId,Posts.OwnerDisplayName,
Posts.LastEditorUserId,Posts.LastEditorDisplayName,Posts.LastEditDate,Posts.LastActivityDate,Posts.Tags,Posts.AnswerCount,
Posts.CommentCount,Posts.FavoriteCount,Posts.CommunityOwnedDate,Posts.ClosedDate
FROM Posts  
    INNER JOIN PostHistory  
    ON Posts.Id=PostHistory.PostId
    where Posts.PostTypeId=2 and PostHistory.PostHistoryTypeId=16 and 
    year(Posts.CreationDate) in (2008,2009)

Enter Parameters

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