1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

SELECT CONCAT('https://stackoverflow.com/a/',po.Id) AS AnswerLink, pa.Title AS QuestionTitle, po.Body AS AnswerBody, po.Score AS PostScore, pa.ViewCount AS QuestionViewCount
FROM Posts po, Posts pa
WHERE po.ParentId = pa.Id
AND po.OwnerUserId = ##userID##
ORDER BY pa.ViewCount DESC

fork query

edited jul 17 22

created jul 17 22 dan1st