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.

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

fork query

edited jan 3 17 Carpetsmoker

created mar 28 15 Gilles