Count how many articles were published in a Serendipity blog in a specific category after a timstamp (here: 1.1.2025)

s9y_catcount.sql

SELECT category_name, COUNT(*) as amount FROM serendipity_entries INNER JOIN serendipity_entrycat ON serendipity_entries.id = serendipity_entrycat.entryid  INNER JOIN serendipity_category ON serendipity_entrycat.categoryid = serendipity_category.categoryid WHERE timestamp > unixepoch('2025-01-01 00:00:01') GROUP BY category_name ORDER BY amount;