Vi questions across Stack Exchange, per month (with graph)

1

Please login or register to vote for this query.

(click on this box to dismiss)

Number of questions posted each month about Vi across Stack Exchange. All questions from Vi Stack Exchange are included, as well as questions tagged [vi], [macvim] or [vim] on other sites.

Stack Overflow

Q&A for professional and enthusiast programmers

select
  convert(datetime, so.month + '-01 13:37:00', 120) as [month],
  vi.count as [Vi],
  so.count as [SO],
  su.count as [SU],
  unix.count as [Unix&Linux],
  ubuntu.count as [Ubuntu],
  apple.count as [Apple],
  tex.count as [TeX]
from (
  select
    convert(char(7), CreationDate, 20) as [month],
    count(*) as [count]
  from [StackOverflow].dbo.Posts p
  where p.PostTypeId = 1
    and p.Tags like '%<vi>%' or p.Tags like '%<vim>%' or p.Tags like '%<macvim>%'
  group by convert(char(7), CreationDate, 20)
) as so full outer join (
  select
    convert(char(7), CreationDate, 20) as [month],
    count(*) as [count]
  from [SuperUser].dbo.Posts p
  where p.PostTypeId = 1
    and p.Tags like '%<vi>%' or p.Tags like '%<vim>%' or p.Tags like '%<macvim>%'
  group by convert(char(7), CreationDate, 20)
) as su on su.month = so.month full outer join (
  select
    convert(char(7), CreationDate, 20) as [month],
    count(*) as [count]
  from [StackExchange.Unix].dbo.Posts p
  where p.PostTypeId = 1
    and p.Tags like '%<vi>%' or p.Tags like '%<vim>%' or p.Tags like '%<macvim>%'
  group by convert(char(7), CreationDate, 20)
) as unix on unix.month = so.month full outer join (
  select
    convert(char(7), CreationDate, 20) as [month],
    count(*) as [count]
  from [StackExchange.Ubuntu].dbo.Posts p
  where p.PostTypeId = 1
    and p.Tags like '%<vi>%' or p.Tags like '%<vim>%' or p.Tags like '%<macvim>%'
  group by convert(char(7), CreationDate, 20)
) as ubuntu on ubuntu.month = so.month full outer join (
  select
    convert(char(7), CreationDate, 20) as [month],
    count(*) as [count]
  from [StackExchange.Apple].dbo.Posts p
  where p.PostTypeId = 1
    and p.Tags like '%<vi>%' or p.Tags like '%<vim>%' or p.Tags like '%<macvim>%'
  group by convert(char(7), CreationDate, 20)
) as apple on apple.month = so.month full outer join (
  select
    convert(char(7), CreationDate, 20) as [month],
    count(*) as [count]
  from [StackExchange.TeX].dbo.Posts p
  where p.PostTypeId = 1
    and p.Tags like '%<vi>%' or p.Tags like '%<vim>%' or p.Tags like '%<macvim>%'
  group by convert(char(7), CreationDate, 20)
) as tex on tex.month = so.month full outer join (
  select
    convert(char(7), CreationDate, 20) as [month],
    count(*) as [count]
  from [StackExchange.Vi].dbo.Posts p
  where p.PostTypeId = 1
  group by convert(char(7), CreationDate, 20)
) as vi on vi.month = so.month
order by so.month asc

Enter Parameters

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