0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for Tridion developers and administrators

SELECT TOP 200
            p.Id            AS [Post Link],
            p.Score,
            p.ViewCount,
            p.FavoriteCount,
            ROUND (
                p.FavoriteCount * 100.0 / p.ViewCount, 2
            ) AS [Favorites per view (%)]
FROM        Posts           p
WHERE       p.PostTypeId    = 1 -- Question
AND         p.Score         > 10
AND         p.ViewCount     > 200
ORDER BY    ROUND (p.FavoriteCount * 100.0 / p.ViewCount, 2)  DESC,
            p.ViewCount DESC

fork query

edited feb 29 12

created feb 29 12 Awesome Poodles