0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for committed Christians, experts in Christianity and those interested in learning more

SELECT q.Id, a.Id
FROM Posts p
INNER JOIN Users AS q ON p.OwnerUserId = q.Id
INNER JOIN Posts AS answers ON p.AcceptedAnswerId = answers.Id
INNER JOIN Users AS a ON answers.OwnerUserId = a.Id
WHERE q.CreationDate > DATEADD(month, -1, GETDATE()) 
AND a.CreationDate > DATEADD(month, -1, GETDATE())
AND p.OwnerUserId != answers.OwnerUserId AND p.OwnerUserId IS NOT NULL
AND answers.OwnerUserId IS NOT NULL
  
GROUP BY q.Id, a.Id HAVING COUNT(*) > 1

fork query

edited sep 18 18

created sep 18 18 anonymous