Votes on questions and answers for [rust] per day averaged over months since 2013

1

Please login or register to vote for this query.

(click on this box to dismiss)

Blender Meta

Q&A about the site for people who use Blender to create 3D graphics, animations, or games

select questions.title, answers.Score
   
from Posts questions
    left join Posts answers on answers.ParentId = questions.Id
    --INNER JOIN PostTags 
      --  ON PostTags.PostId = Posts.Id OR PostTags.PostId = parents.Id
    --INNER JOIN Tags ON PostTags.TagId = Tags.Id
where
    questions.PostTypeId = 1 AND
    answers.PostTypeId = 2 AND
    --PostTags.TagId = 59148 AND
    --Tags.tagname = 'rust' AND
    --(VoteTypeId = 2 OR VoteTypeId = 3) AND
    questions.CreationDate > '2013-01-01' AND
    questions.CreationDate < '2013-01-02'

Enter Parameters

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