How many upvotes do I have for each tag?

0

Please login or register to vote for this query.

(click on this box to dismiss)

how long before I get tag badges?

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT top 10 A.TagName, B.TagName,
(select count(*) from PostTags pt where pt.tagid = b.id) as occured
FROM Tags as A, Tags as B
WHERE A.id <> B.id 
AND EXISTS (
  SELECT * FROM 
    PostTags as C, PostTags as D 
  where C.PostId=D.PostId and C.TagId=A.id and D.TagId=B.id)
and a.tagname = 'java'


--SELECT * FROM PostTags as C, PostTags as D where C.PostId=D.PostId and C.TagId=1 and D.TagId=17
--select * from posttags where PostId=10980

Enter Parameters

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