Checkmark amnesty

0

Please login or register to vote for this query.

(click on this box to dismiss)

Puzzling

Q&A for those who create, solve, and study puzzles

SELECT q.Id AS [Post Link], q.CreationDate,
  u.Id AS [User Link], u.LastAccessDate AS 'Last seen',
  a.Score AS 'Top answer score'
  FROM Posts AS q
  CROSS APPLY (
    SELECT TOP 1 Score
      FROM Posts
      WHERE ParentId = q.Id
      ORDER BY Score DESC
  ) a
  INNER JOIN Users AS u
    ON q.OwnerUserId = u.Id
  WHERE q.AcceptedAnswerId IS NULL
    AND q.PostTypeId = 1 -- Question
    AND u.Reputation < 200
    AND a.Score > 0
  ORDER BY a.Score DESC

Enter Parameters

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