SELECT q.Id AS QuestionId, q.CreationDate AS QuestionCrea...

0

Please login or register to vote for this query.

(click on this box to dismiss)

User Experience Meta

Q&A about the site for user experience researchers and experts

SELECT
    q.Id AS QuestionId,
    q.CreationDate AS QuestionCreationDate,
    q.OwnerUserId AS QuestionOwnerId,
    q.Score AS QuestionScore,
    a.Id AS AnswerId,
    a.CreationDate AS AnswerCreationDate,
    a.OwnerUserId AS AnswerOwnerId,
    a.Score AS AnswerScore
FROM 
    Posts q, 
    Posts a
WHERE
    --(q.Id = a.ParentId
    --AND q.PostTypeId = 1
    --AND a.PostTypeId = 2
    --AND DATEDIFF(second, a.CreationDate, q.CreationDate) BETWEEN -1 AND 60) OR
    q.Id = a.ParentId
    AND q.PostTypeId = 1
    AND a.PostTypeId = 2
    AND q.OwnerUserId = a.OwnerUserId
    AND DATEDIFF(second, a.CreationDate, q.CreationDate) BETWEEN 1 AND 3600;-- OR
    --(q.PostTypeId = 1
    --AND (q.Score > 10 OR a.Score > 10)
    --AND DATEDIFF(second, a.CreationDate, q.CreationDate) BETWEEN -1 AND 60);

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results