
How to return top-N from each group with GROUP_CONCAT()
A practical example of how to select several most recent items from each group in Manticore Search and combine them into a single string.
Senior Core Developer
Stanislav Klinov is one of the Senior Core Developers of Manticore Search.

A practical example of how to select several most recent items from each group in Manticore Search and combine them into a single string.

A practical guide to searching long hashes, event IDs, message IDs, and email addresses in Manticore Search: limits, exact matching, wildcard search, tokenization, migration, and limitations.

A practical guide to using UUID as a document ID in Manticore Search 28.5.0: SQL, JSON API, /bulk, automatic ID generation, errors, and replication.

Starting with Manticore Search 28.5.0, you can use a UUID as the document ID. Here we look at how to drop the mapping to numeric IDs, who generates the UUID, and what limitations still remain.

Manticore Search 25.12.0 adds strict, auto, and max facet modes so e-commerce filters can show selected, available, and unavailable values without manually building separate queries.

A practical checklist for migrating standalone, distributed, and replicated Manticore Search deployments to authentication without losing access or cluster state.

Learn how to enable Manticore authentication, bootstrap the first administrator, create least-privilege users, use SQL and HTTP credentials, and verify allowed and denied access.

Manticore Search adds built-in authentication and authorization across SQL/MySQL, HTTP, and replication-related operations so teams can control who connects and what each user can do.
Install Manticore Search in one command on Linux or macOS:
curl https://manticoresearch.com | sh
For advanced installation options, see the full installation guide and the manual .