View count of each question answered by a specific user

0

Please login or register to vote for this query.

(click on this box to dismiss)

Ask Ubuntu

Q&A for Ubuntu users and developers

DECLARE @SiteUrl VARCHAR(MAX)

SET @SiteUrl = (
  SELECT
    'https://' +
    CASE WHEN DB_NAME() = 'StackOverflow' THEN 'stackoverflow'
         WHEN DB_NAME() = 'ServerFault' THEN 'serverfault'
         WHEN DB_NAME() = 'SuperUser' THEN 'superuser'
         WHEN DB_NAME() LIKE 'StackExchange.%%' THEN REPLACE(DB_NAME(), 'StackExchange.', '')
         ELSE 'stackexchange' -- Default or if it doesn't match anything specific
    END +
    '.stackexchange.com/q/'
)

SELECT 
    q.Id AS QuestionId,
    q.Title AS QuestionTitle,
    q.ViewCount AS ViewCount,
    CONCAT(LOWER(@SiteUrl), q.Id) AS QuestionURL
FROM 
    Posts a
JOIN 
    Posts q ON a.ParentId = q.Id
WHERE 
    a.PostTypeId = 2 -- This denotes an Answer
    AND a.OwnerUserId = ##UserId:int##
ORDER BY 
    q.ViewCount DESC

Enter Parameters

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