top reputation


Please login or register to vote for this query.

(click on this box to dismiss)

Open Data

Q&A for developers and researchers interested in open data

DECLARE @UserId int = 953553;

--Select top 15 * from Users order by reputation desc;
SELECT @UserId, '{'+ Replace(STUFF((SELECT CONCAT('"', TagName COLLATE DATABASE_DEFAULT,'": ', count (*),' ,')
			  FROM Tags
              INNER JOIN PostTags ON PostTags.TagId =
              INNER JOIN Posts ON Posts.ParentId = PostTags.PostId
              WHERE Posts.OwnerUserId = @UserId
			  GROUP BY TagName
              order by count(*) desc
              FOR XML PATH('')), 1, 0, '')+'%',',%','')+'}' AS [Output]

Enter Parameters

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