Most popular tags

0

Please login or register to vote for this query.

(click on this box to dismiss)

Gardening and Landscaping Meta

Q&A about the site for gardeners and landscapers

/*SELECT
  COUNT(PostId) AS Rate, TagName
FROM
  Tags, PostTags, Posts
WHERE 
  Tags.Id = PostTags.TagId and Posts.Id = PostId
GROUP BY 
  TagName
ORDER BY
  Rate DESC 
  ##################
  select
    count(Posts.Id) tag_count,
    Tags.TagName,
    Tags.Id
from
    Tags
    join PostTags on Tags.Id = PostTags.PostId
    join Posts on PostTags.TagId = Posts.Id
where
    year(Posts.CreationDate) = 2018
    and Posts.ParentId is null
    and Posts.DeletionDate is null
    and Tags.Id = 16
group by
    Tags.TagName,
    Tags.Id
order by
    tag_count desc
##############    
  
select top 10 * from Tags t
inner join posts p
on t.ExcerptPostId = p.id 
--select * from PostTypes 
select top 10* from posts where posttypeid = 1
  Tags, PostTags, Posts
  */
  
  SELECT
  top 10 * 
FROM
  Tags, PostTags, Posts

Enter Parameters

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