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

Public
Tested
My Own 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 1820 Downloads 704

SQL Date+Time
ANmarAmdeen
627
Attachments
Revisions

v1.0