Barely Used Tags

0

Please login or register to vote for this query.

(click on this box to dismiss)

Enter Query Description

Physical Fitness Meta

Q&A about the site for physical fitness professionals, athletes, trainers, and those providing health-related needs

-- Enter Query Barely Used Tags
-- Enter Query Tags with only a few posts

SELECT

 tagName
 , max(p.CreationDate)
 , count(pt.Postid) PostCount

FROM
   tags t
   INNER JOIN PostTags pt
   ON t.id = pt.tagId
   JOIN Posts p
   ON p.id = pt.postId
   

GROUP BY
tagname

HAVING
 (count(pt.Postid) > 0) 
 AND (count(pt.Postid) < 15)

ORDER BY
PostCount

Enter Parameters

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