0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for those using, extending or developing Emacs

SELECT
    p.Id,u.DisplayName AS "Asker",
    'https://ell.stackexchange.com/users/' + CONVERT(VARCHAR, u.Id) AS AskerLink,
    au.DisplayName AS "Answerer",
    'https://ell.stackexchange.com/users/' + CONVERT(VARCHAR, au.Id) AS AnswererLink,
 
    'https://ell.stackexchange.com/questions/' + CONVERT(VARCHAR, p.Id) as Link,
    p.Body as QuestionBody,
    p.Tags,
    p.Title,a.Body AS HighestScoringAnswer
FROM Posts p
JOIN Posts a ON a.ParentId = p.Id
JOIN Users u ON p.OwnerUserId = u.Id
JOIN Users au ON a.OwnerUserId = au.Id
ORDER BY p.Id
OFFSET 2000000 ROWS
FETCH NEXT 100 ROWS ONLY

fork query

edited may 25

created may 25 jon.doe38788