5

Please login or register to vote for this query.

(click on this box to dismiss)

Your answers which were viewed the most times.

Q&A about the site for administrators, end users, developers and designers for Craft CMS

-- 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]
FROM
    Posts as Questions, Posts as Answers
WHERE
    Questions.PostTypeId = 1
    AND Answers.PostTypeId = 2
    AND Answers.OwnerUserId = 44491
    AND Answers.ParentId = Questions.Id
ORDER BY
    Questions.ViewCount DESC

view current version

edited jan 16 12 matt6125

created jun 16 10 sblair