Questions and Answers per week

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 week.

Physical Fitness Meta

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

select res.id as id , res.bodycom as body , res.datecom as date from(select qa.q_id as id ,qa.a_id as a_id, qa.a_body as body, qa.creationdate as date, c.text as bodycom, c.creationdate as datecom
from (SELECT questions.Id as q_id, answers.id as a_id, questions.title ,questions.body as q_body, answers.body as a_body, answers.creationdate
FROM Posts answers
INNER JOIN Posts questions ON answers.parentid = questions.id
WHERE questions.tags like '%microservices%'  and questions.tags like '%security%' and questions.tags like '%single-sign-on%'
and questions.tags like '%cloud%' and questions.tags like '%paas%')qa join comments c on qa.a_id = c.postid) res

Enter Parameters

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