Custom - Questions between time and response times

0

Please login or register to vote for this query.

(click on this box to dismiss)

Views, Score and Answers per Game (with limited blacklist for other tags)

Joomla

Q&A for Joomla! administrators, users, developers and designers

SELECT question.Id, Tagname, DATEDIFF(MINUTE, question.CreationDate, answer.CreationDate) diff
FROM Posts question
  INNER JOIN Posts answer ON question.Id = answer.ParentId
  JOIN PostTags ON question.Id = PostTags.PostId
  JOIN Tags ON PostTags.TagId = Tags.Id
  WHERE question.PostTypeId = 1 
        AND question.CreationDate < '2019-11-05' 
        AND question.CreationDate >= '2019-010-07'
        AND question.AcceptedAnswerId = answer.Id
        AND Tagname like '%snowflake%'
        AND answer.Score > 0
        AND DATEDIFF(MINUTE, question.CreationDate, answer.CreationDate) < 40 * 2 -- median is 40

ORDER BY question.Id ASC

Enter Parameters

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