1

Please login or register to vote for this query.

(click on this box to dismiss)

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

SELECT distinct
    FORMAT (d.CreationDate, 'yyyy-MM') as [date1],
    (d.Id) as id,
    d.Body,
    Score,
    AnswerCount,
    CommentCount,
    FavoriteCount
  FROM Posts d
  WHERE
    d.PostTypeId = 1  -- 1=Question
    and d.CreationDate > '2013-01-01'
    and (d.tags like '%cloud9%' or d.tags like '%repl.it%' or d.tags like '%web-ide%' or d.tags like '%cloud9-ide%' or d.tags like '%aws-cloud9%' or d.tags like '%codeanywhere%' or d.tags like '%codenvy%' or d.tags like '%koding%' or d.tags like '%codespaces%' or d.tags like '%eclipse-che%' or d.tags like '%theia%')
order by FORMAT (d.CreationDate, 'yyyy-MM')

fork query

edited jul 10

created jul 10 jon.doe33046