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
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
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 3,553
Downloads 1,376
CodeID
DB ID
ANmarAmdeen
610
Revisions
v1.0
Saturday
September
22
2018