Last active
December 20, 2022 14:31
-
-
Save onli/211f3b2fab59cb30dc46e21d3fa3bf94 to your computer and use it in GitHub Desktop.
Count how many articles were published in a Serendipity blog in a specific category after a timstamp (here: 1.1.2022)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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