Diagnostics about "Posts"

0

Please login or register to vote for this query.

(click on this box to dismiss)

Just teasing apart what PostTypeId means, for now

Stack Overflow

Q&A for programmers

-- Enter Query Title
-- Enter Query Description

SELECT 
  PostTypeId,
  Id,
  AcceptedAnswerId, 
  CreationDate, 
  Score, 
  ViewCount, 
  OwnerUserId, 
  LastEditorUserId, 
  LastEditDate, 
  LastActivityDate,
  Title, 
  Tags, 
  AnswerCount,
  CommentCount,
  FavoriteCount,
  ClosedDate,
  ParentId,
  CommunityOwnedDate,
  Body
FROM
  Posts 
WHERE
--  (PostTypeId = 1 OR PostTypeID = 2) AND Id < 50
  (PostTypeId != 1 AND PostTypeID != 2)
ORDER BY PostTypeId ASC, Id ASC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results