cliffers

0

Please login or register to vote for this query.

(click on this box to dismiss)

Poker Meta

Q&A about the site for serious players and enthusiasts of poker

SELECT
  q.Id AS [Post Link],
  q.Score AS qScore,
  a.Score AS aScore,
  q.ViewCount AS Views,
  q.CreationDate AS qDate
FROM
  Posts AS q
INNER JOIN
  Posts AS a
ON
  a.ParentId = q.Id
WHERE
     q.PostTypeId = 1
 and a.PostTypeId = 2
 and q.AnswerCount = 1
 and q.CreationDate < '2014-08-22T11:11:59.999'
 and q.Score < 1
 and a.Score = 1
 and a.Body NOT LIKE '%a href="%'
 and LEN(a.Body) < 399
 and q.AcceptedAnswerId IS NULL
 and q.ClosedDate < '2014-08-22T11:11:59.999'
 and q.LastEditDate < '2014-08-22T11:11:59.999'
 GROUP BY q.Id, q.Score, a.Score, q.ViewCount, q.CreationDate
 ORDER BY
   a.Score ASC

Enter Parameters

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