My List of Tag Synonyms which permit Voting

1

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for programmers

SELECT 'site://tags/' + TargetTagName + '/synonyms|' + TargetTagName AS [VOTE4ME], Count(SourceTagName) AS [SYNONYMS]
FROM TagSynonyms TS
WHERE
ApprovalDate IS NULL
AND
(SELECT SUM(
 CASE V.VoteTypeId 
 WHEN 2 THEN 1 
 WHEN 3 THEN -1 
 END) 
 FROM TAGS T, PostTags Pt, Posts P, Votes V, VoteTypes Vt
 WHERE T.Id = Pt.TagId
 AND P.Id = V.PostId
 AND Pt.PostId = P.ParentId
 AND Vt.Id = V.VoteTypeId
 AND T.TagName = TargetTagName
 AND P.OwnerUserId = ##userid##
 AND P.CommunityOwnedDate IS NULL
) > 4
GROUP BY TargetTagName

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results