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.title, question.creationDate, 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-010-07'
        AND question.AcceptedAnswerId = answer.Id
        AND Tagname like '%snowflake%'
        AND answer.Score > 0
ORDER BY question.Id ASC

Enter Parameters

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