SELECT p.Id,u.DisplayName AS "Asker", 'https://ell.stacke...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Emacs

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

Enter Parameters

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