0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for cartographers, geographers and GIS professionals

SELECT TOP 1
    question.Id as 'Question ID', 
    question.OwnerUserId as 'Owner User ID', ou.Location as 'Owner Location', 
    aa.Id as 'AcceptedAnswerID', aa.OwnerUserId as 'User Who Answered',
    uaa.Location as 'User Who Answered Location',
    question.Tags as 'Tags', question.Body as 'Body'
FROM Posts question 
    INNER JOIN Posts aa  ON question.AcceptedAnswerId = aa.Id
    INNER JOIN Users ou  ON question.OwnerUserId      = ou.Id
    INNER JOIN Users uaa ON aa.OwnerUserId            = uaa.Id
WHERE
    question.PostTypeId = 1         AND
    question.score >= 0             AND
    question.AnswerCount > 0        AND
    YEAR(question.CreationDate) = '2019'

view current version

edited may 5 21

created may 5 21 Pedro Almir