Questions per month top 10 tags compared

0

Please login or register to vote for this query.

(click on this box to dismiss)

How many questions per month does each tag in the top 10 tags get

Craft CMS Meta

Q&A about the site for administrators, end users, developers and designers for Craft CMS

select 
    q.id,
    q.tags,
    q.CommentCount,
    q.AnswerCount,
    q.FavoriteCount,
    a.body as answerbody
    
from posts q
inner join posts a 
  on a.id = q.acceptedanswerid
where 
  q.tags >5 
  and q.CommentCount>5
  and q.AnswerCount>10
  and q.FavoriteCount>5
  and q.tags like '%<python>%'

Enter Parameters

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