0

Please login or register to vote for this query.

(click on this box to dismiss)

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

SELECT TOP (100) questions.id AS question_id, 
        questions.OwnerUserId AS questioner_id,
        questions.body AS question_body, 
        questions.CreationDate AS question_creation_date,
        answers.id AS answer_id,
        answers.body AS answer_body,
        answers.ParentId AS parent_id,
        answers.Score AS answer_score,
        answers.OwnerUserId AS respondant_id,
        answers.CreationDate AS answer_creation_date,
        DATEDIFF(second, questions.CreationDate, answers.CreationDate) AS time_after_answer
FROM posts questions
INNER JOIN posts answers
ON questions.id = answers.ParentId
WHERE questions.CreationDate >= '2019-06-06' 
AND questions.AnswerCount = 5
ORDER BY question_id, answer_score DESC;

fork query

edited jul 31 19

created jul 22 19 anonymous