Stack Exchange
log in help

The vampire flies away

0

Please login or register to vote for this query.

(click on this box to dismiss)

The result of this query is the fraction of 1.) questions tagged with identification-request; 2.) all questions; or 3.) _not_ tagged with identification-request, that had an answer within 24 hours, and received no response from the questioner (in the form of accepting an answer or commenting on a question or answer) ever (i.e. as of the last time the data dump was regenerated).

Poker Meta

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

SELECT
  p.Id AS [Post Link],
  u.Id AS [User Link]
FROM
  Posts AS p
  LEFT OUTER JOIN Users AS u
    ON p.OwnerUserId = u.Id
WHERE
  -- identification requests
  p.Tags LIKE '%identification-request%'
  -- that had an answer within 24 hours
  AND DATEDIFF(HOUR, p.CreationDate, (SELECT MIN(CreationDate) FROM Posts AS p2 WHERE p2.ParentId = p.Id)) < 24
view current version

Enter Parameters

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