0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for anime and manga fans

select Posts.ID,
  Posts.PostTypeId,
  Posts.AcceptedAnswerId,
  Posts.ParentId,
  Posts.CreationDate,
  Posts.DeletionDate,
  Posts.Score,
  Posts.ViewCount,
  Posts.Body,
  Posts.OwnerUserId,
  Posts.OwnerDisplayName,
  Posts.LastEditorUserId,
  Posts.LastEditorDisplayName,
  Posts.LastEditDate,
  Posts.LastActivityDate,
  Posts.Title,
  Posts.Tags,
  Posts.AnswerCount,
  Posts.CommentCount,
  Posts.FavoriteCount,
  SuggestedEdits.Id,
  SuggestedEdits.CreationDate,
  SuggestedEdits.ApprovalDate,
  SuggestedEdits.RejectionDate,
  SuggestedEdits.OwnerUserId,
  SuggestedEdits.Comment,
  SuggestedEdits.Text,
  SuggestedEdits.Title,
  SuggestedEdits.Tags
from Posts inner join SuggestedEdits
  on Posts.ID = SuggestedEdits.PostId

fork query

edited oct 29 20

created oct 29 20 anonymous