0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for administrators, end users, developers and designers for Craft CMS

SELECT TOP 1000
  q.Id AS [Post Link],
  q.Title,
  q.CreationDate,
  q.Score,
  q.ViewCount,
  q.AnswerCount,
  u.DisplayName AS [User Link]
FROM 
  Posts q
INNER JOIN
  Users u ON q.OwnerUserId = u.Id
WHERE
  q.PostTypeId = 2 -- 1 represents questions
ORDER BY
  q.CreationDate DESC

fork query

edited aug 3 anonymous

created aug 3 jon.doe34472