Posts per year-month

Create summary list
If you have SQL table named Messages, with DateStamp having dates, you can then create a Posts-Per-YearMonth list as summary using SQL below
Something that I use to build a Posts-Per-YearMonth list in most of my websites

CodeFunctionName
What is this?

Public

Tested

Original Work
SELECT yoyo, Momo, SUM(coco1) AS coco FROM (
SELECT YEAR(DateStamp) AS yoyo, Month(DateStamp) As Momo, COUNT(*) AS coco1 FROM Messages GROUP BY DateStamp
) AS derivedtbl_1
GROUP BY yoyo, Momo
ORDER BY yoyo DESC, Momo Desc

Views 3,244

Downloads 1,195

CodeID
DB ID