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.

Bitcoin

Q&A for Bitcoin crypto-currency enthusiasts

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 
where date between '2020/05/01' and '2020/06/01'

Enter Parameters

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