Compare Tags by View Count & Score

0

Please login or register to vote for this query.

(click on this box to dismiss)

Vegetarianism

Q&A for those committed to a vegan or vegetarian lifestyle and anyone interested in learning more

SELECT count(distinct SourceTagName) as sourceTags,
count(distinct TargetTagName) as targetTags
from TagSynonyms


/*
  Tags.TagName
  , AVG(Score) AS 'Average Score'
  , AVG(ViewCount)  AS 'Average View Count'
FROM 
  Posts
INNER JOIN 
  PostTags ON Posts.Id=PostTags.PostId
  LEFT JOIN 
    Tags ON PostTags.TagId = Tags.Id
WHERE
  PostTypeId = 1 -- question
  AND Tags.TagName IN (
    @TagName1
    , @TagName2
  )
GROUP BY 
  Tags.TagName
  */

Enter Parameters

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