The vampire flies away

1

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

DECLARE @dumpdate datetime = (SELECT MAX(CreationDate) FROM PostHistory)

-- Param: Enter '1' for identification-request; '2' for all questions; '3' for all minus identification-request: 
DECLARE @param int = ##Param:int##

SELECT
  -- Was there a response by OP, in the form of an accepted answer or a comment
  -- on either the question or one of its answers?
  (CASE WHEN NOT EXISTS (SELECT 1 
                         FROM Comments AS c 
                         WHERE c.UserId = u.Id 
                               AND (c.PostId = p.Id 
                                    OR c.PostId IN (SELECT p2.Id
                                                    FROM Posts AS p2
                                                    WHERE p2.ParentId = p.Id)
                                    )
                        )
             AND p.AcceptedAnswerId IS NULL
        THEN 0
        ELSE 1 END) AS [Response?]
INTO 
  #stats
FROM
  Posts AS p
  LEFT OUTER JOIN Users AS u
    ON p.OwnerUserId = u.Id
WHERE
  (CASE WHEN @param = 1 THEN (CASE WHEN (p.Tags LIKE '%identify-this-%') THEN 1 ELSE 0 END)
        WHEN @param = 2 THEN 1
        WHEN @param = 3 THEN (CASE WHEN (p.Tags NOT LIKE '%identify-this-%') THEN 1 ELSE 0 END) END) = 1
  -- questions 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
  -- ignoring ones created too close to the data dump
  AND DATEDIFF(HOUR, p.CreationDate, @dumpdate) > 24
  
SELECT 1.0-CAST(SUM([Response?]) AS float)/CAST(COUNT(*) AS float) 
FROM #stats

Enter Parameters

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