Top 10 questions with worst score

0

Please login or register to vote for this query.

(click on this box to dismiss)

Craft CMS

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

SELECT #, DisplayName AS 'Owner', Location, Title AS 'Question', Body, T.Score, Text AS 'Answer' FROM 
(
  SELECT TOP 10
  row_number() OVER (ORDER BY Score) AS '#',
  A.*,
  B.DisplayName,
  B.Location
  FROM Posts A 
  INNER JOIN Users B ON A.OwnerUserId = B.Id
  WHERE (A.PostTypeId = 1 AND B.Location LIKE 'Monterrey%')
  ORDER BY Score
) T
INNER JOIN Comments C ON C.PostId = T.Id
ORDER BY T.#

Enter Parameters

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