Posts Per Year

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

Public
Tested
My Own Work
SELECT yoyo, SUM(coco1) AS coco FROM (
SELECT YEAR(DateAdded) AS yoyo, COUNT(*) AS coco1 FROM Table_Name GROUP BY DateAdded
) AS derivedtbl_1
GROUP BY yoyo
ORDER BY yoyo DESC

Views 2361 Downloads 964

SQL Date+Time
ANmarAmdeen
627
Revisions

v1.0