Most Views

0

Please login or register to vote for this query.

(click on this box to dismiss)

Sports

Q&A for participants in team and individual sport activities

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=1 and PostHistory.PostHistoryTypeId=16

Enter Parameters

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