0

Please login or register to vote for this query.

(click on this box to dismiss)

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

SELECT 
    q.Id AS QuestionId,
    q.Title AS QuestionTitle,
    q.CreationDate AS QuestionCreationDate,
    q.Score AS QuestionScore,
    a.Id AS AnswerId,
    a.CreationDate AS AnswerCreationDate,
    a.Score AS AnswerScore,
    DATEDIFF(second, q.CreationDate, a.CreationDate) AS TimeDifferenceInSeconds,  -- Time difference in seconds
    (q.Score + a.Score) AS GainedUpvotes
FROM 
    Posts AS q
JOIN 
    Posts AS a ON q.Id = a.ParentId
WHERE 
    q.PostTypeId = 1  -- 1 indicates questions
    AND a.PostTypeId = 2  -- 2 indicates answers
    AND q.OwnerUserId = 61624  -- User ID for Daniel Kaplan
    AND a.OwnerUserId = 61624  -- User ID for Daniel Kaplan
ORDER BY 
    TimeDifferenceInSeconds DESC

fork query

edited dec 8

created dec 8 anonymous