11 slide

0

Please login or register to vote for this query.

(click on this box to dismiss)

Board and Card Games

Q&A for people who like playing board games, designing board games or modifying the rules of existing board games

SELECT TOP 10 Tag.TagName, Tag2.TagName, COUNT(1) as postsPerTag
FROM PostTags AS PosTg
   INNER JOIN Tags AS Tag ON Tag.Id=PosTg.TagId
   INNER JOIN PostTags AS PosTg2 ON PosTg2.PostId=PosTg.PostId
   INNER JOIN Tags AS Tag2 ON Tag2.Id=PosTg2.TagId
WHERE PosTg.TagId>PosTg2.TagId
GROUP BY Tag.TagName, Tag2.TagName
ORDER BY COUNT(1) DESC



/*SELECT Count(ID) as Skaits
FROM Users
WHERE UPPER(DisplayName) LIKE 'ANDR%'*/



/*SELECT Count(ID) as Skaits
FROM Posts
WHERE CreationDate BETWEEN '2019/01/01 00:00:00' AND '2019/12/31 23:59:59'*/


/*SELECT DISTINCT TagID, TagName
from PostTags
INNER JOIN Tags
ON PostTags.TagID=Tags.ID
ORDER BY TagID*/

Enter Parameters

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