Skip to content

Instantly share code, notes, and snippets.

@onli
Last active Dec 20, 2022
Embed
What would you like to do?
Count how many articles were published in a Serendipity blog in a specific category after a timstamp (here: 1.1.2022)
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;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment