How to return top-N from each group with GROUP_CONCAT()

Manticore Announcements - English
1

Need the latest N items from each group without returning N rows per group?

In Manticore Search 28.6.6, GROUP_CONCAT() can now ORDER BY + LIMIT inside the aggregate: one row per group, total count intact, top IDs sorted.