Skip to content

Instantly share code, notes, and snippets.

Last active December 20, 2022 14:31
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
Star You must be signed in to star a gist
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 = 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