RAW question list

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select
  Posts.Id as [Post Link],
  Posts.Id,
  Posts.Title,
  Posts.Score,
  Posts.Tags,
  Posts.CreationDate,
  Posts.ViewCount,
  Posts.Body,
  Posts.OwnerUserId,
  CONCAT(Posts.OwnerDisplayName, PostUsers.DisplayName) as OwnerDisplayName,
  PostUsers.Reputation as OwnerReputation,
  Posts.LastEditorUserId,
  CONCAT(Posts.LastEditorDisplayName, EditUsers.DisplayName) as LastEditorDisplayName,
  EditUsers.Reputation as LastEditorReputation,
  Posts.LastEditDate,
  Posts.LastActivityDate,
  Posts.AnswerCount,
  Posts.CommentCount,
  Posts.FavoriteCount,
  Posts.ClosedDate
from Posts
left join Users as PostUsers on (Posts.OwnerUserId = PostUsers.Id)
left join Users as EditUsers on (Posts.LastEditorUserId = EditUsers.Id)
where PostTypeId = 1
and Tags like '%rules-as-written%'

Enter Parameters

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