posts and accepted answer id body

0

Please login or register to vote for this query.

(click on this box to dismiss)

Monero Meta

Q&A about the site for developers and users of the secure, private and untraceable cryptocurrency Monero

WITH
    Answers AS (
        SELECT *
            FROM Posts
            WHERE PostTypeId = 2 -- Answers
             
    )
SELECT TOP ##NumberOfQuestions:int##
        Questions.Id AS [Q Id],
        Questions.Score AS [Q Score],
        Questions.Viewcount AS [Q Views],
        Questions.AnswerCount AS [Q Answers],
        Questions.FavoriteCount AS [Q Favorites],
        Questions.Tags AS [Q Tags],
        Questions.CreationDate AS [Q Date],
        'site://a/' + CAST(FirstAnswer.Id AS NVARCHAR) + '|' + CAST(DATEDIFF(mi, Questions.CreationDate, FirstAnswer.CreationDate) AS NVARCHAR) AS [Minutes to First Ans],
        'site://a/' + CAST(AcceptedAnswer.Id AS NVARCHAR) + '|' + CAST(DATEDIFF(mi, Questions.CreationDate, AcceptedAnswer.CreationDate) AS NVARCHAR) AS [Minutes to Accepted Ans]
    FROM Posts AS Questions
        LEFT OUTER JOIN Answers AS FirstAnswer
            ON FirstAnswer.ParentId = Questions.Id
        LEFT OUTER JOIN Answers AS AcceptedAnswer
            ON AcceptedAnswer.Id = Questions.AcceptedAnswerId
    WHERE
        Questions.PostTypeId = 1 -- Questions
        and Questions.Tags like '%unity%'
       OR Questions.Tags like '%unity'
        OR Questions.Tags like '%unity'
       

        AND year(Questions.CreationDate) between 2014 and 2018 AND month(Questions.CreationDate) = 12
        AND AcceptedAnswer.Id = (
            SELECT TOP 1 Id
                FROM Answers
                WHERE
                    AcceptedAnswer.Id = Questions.Id
                ORDER BY CreationDate ASC
        )
        Order by Questions.Score desc
;

Enter Parameters

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