0

Please login or register to vote for this query.

(click on this box to dismiss)

Questions must have at least 1000 views to qualify

Q&A for professional and enthusiast programmers

-- Top 100 most viewed questions
-- Questions must have at least 1000 views to qualify

SELECT
    Questions.Id AS [Post Link],
    Questions.ViewCount AS [View Count],
    Answers.Id AS [Answer Link]
FROM
    Posts as Questions, Posts as Answers
WHERE
    Questions.PostTypeId = 1
    AND Answers.PostTypeId = 2
    AND Answers.OwnerUserId = 24694
    AND Answers.ParentId = Questions.Id
ORDER BY
    Questions.ViewCount DESC

view current version

edited jan 11 12 jon.doe7137

created jun 16 10 sblair