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

s9y_catcount.sql

SELECT category_name, COUNT(*) as amount FROM serendipity_entries INNER JOIN serendipity_entrycat ON serend
ipity_entries.id = serendipity_entrycat.entryid  INNER JOIN serendipity_category ON serendipity_entrycat.categoryid
 = serendipity_category.categoryid WHERE timestamp > 1640995201 GROUP BY category_name ORDER BY amount;