0

Please login or register to vote for this query.

(click on this box to dismiss)

Find users by tag score and location

Q&A for scientific skepticism

-- Skill search
-- Find users by tag score and location

-- select * from users where reputation>1000 and location like '%New York%' order by displayname;

-- select * from users where id = 478288;

-- table of all questions and answers
--select * from posts where owneruserid = 478288;

-- table of questions and their tags
--select * from posttags where postid=4307240;

--select Id from Tags where TagName like 'c++';

SELECT TOP 20 
    TagName,
    COUNT(*) AS UpVotes 
FROM Tags
    INNER JOIN PostTags ON PostTags.TagId = Tags.id
    INNER JOIN Posts ON Posts.ParentId = PostTags.PostId
    INNER JOIN Votes ON Votes.PostId = Posts.Id and VoteTypeId = 2
GROUP BY TagName, Posts.OwnerUserId
ORDER BY UpVotes DESC

fork query

created jan 16 11 chrisaycock