0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for administrators, end users, developers and designers for Craft CMS

select
  u.Id, u.DisplayName,u.Reputation,u.CreationDate as Cre,u.LastAccessDate as Acc, 
  (select count(p.Id) from Posts p where u.Id=p.OwnerUserId and p.PostTypeId=2 and p.CreationDate < '2013-02-01') as PrB,
  (select count(p.Id) from Posts p where u.Id=p.OwnerUserId and p.PostTypeId=2 and p.CreationDate < '2013-03-01') as M01,
  (select count(p.Id) from Posts p where u.Id=p.OwnerUserId and p.PostTypeId=2 and p.CreationDate < '2013-04-01') as M02,
  (select count(p.Id) from Posts p where u.Id=p.OwnerUserId and p.PostTypeId=2 and p.CreationDate < '2013-05-01') as M03,
  (select count(p.Id) from Posts p where u.Id=p.OwnerUserId and p.PostTypeId=2 and p.CreationDate < '2013-06-01') as M04,
  (select count(p.Id) from Posts p where u.Id=p.OwnerUserId and p.PostTypeId=2 and p.CreationDate < '2013-07-01') as M05,
  (select count(p.Id) from Posts p where u.Id=p.OwnerUserId and p.PostTypeId=2 and p.CreationDate < '2013-08-01') as M06,
  (select count(p.Id) from Posts p where u.Id=p.OwnerUserId and p.PostTypeId=2 and p.CreationDate < '2013-09-01') as M07,
  (select count(p.Id) from Posts p where u.Id=p.OwnerUserId and p.PostTypeId=2 and p.CreationDate < '2013-10-01') as M08,
  (select count(p.Id) from Posts p where u.Id=p.OwnerUserId and p.PostTypeId=2 and p.CreationDate < '2013-11-01') as M09,
  (select count(p.Id) from Posts p where u.Id=p.OwnerUserId and p.PostTypeId=2 and p.CreationDate < '2013-12-01') as M10,
  (select count(p.Id) from Posts p where u.Id=p.OwnerUserId and p.PostTypeId=2 and p.CreationDate < '2014-01-01') as M11,
  (select count(p.Id) from Posts p where u.Id=p.OwnerUserId and p.PostTypeId=2 and p.CreationDate < '2014-02-01') as M12,
  (select count(p.Id) from Posts p where u.Id=p.OwnerUserId and p.PostTypeId=2 and p.CreationDate < '2014-03-01') as M13,
  (select count(p.Id) from Posts p where u.Id=p.OwnerUserId and p.PostTypeId=2 and p.CreationDate < '2014-04-01') as M14,
  (select count(p.Id) from Posts p where u.Id=p.OwnerUserId and p.PostTypeId=2 and p.CreationDate < '2014-05-01') as M15,
  (select count(p.Id) from Posts p where u.Id=p.OwnerUserId and p.PostTypeId=2 and p.CreationDate < '2014-07-01') as M16,
  (select count(p.Id) from Posts p where u.Id=p.OwnerUserId and p.PostTypeId=2 and p.CreationDate < '2014-06-01') as M17
  

from Users u INNER JOIN Posts p ON u.Id = p.OwnerUserId
where p.PostTypeId=2 
group by  u.Id, u.DisplayName,u.Reputation,u.CreationDate, u.LastAccessDate
order by u.Id

fork query

edited jul 2 14

created jan 26 14 anonymous