Posts (Q/A) and Comments per month

0

Please login or register to vote for this query.

(click on this box to dismiss)

Plot the site activity by voting, questions, answers and comments, aggregated per month.

Sitecore Meta

Q&A about the site for developers and end users of the Sitecore CMS and multichannel marketing software

select dd.id as id , dd.body as body, dd.date as date from(select p.id as id , p.parentid as parentid, c.text as body, c.creationdate as date
from (select id , parentid 
from posts 
where tags like '%iquibase%' or tags like '%iquidbase%' ) 
p join comments c on p.id = c.postid) dd

Enter Parameters

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