How to count the total number of records in Sphinx with grouping?

Question

PHP

There is a request like

SELECT *, COUNT(group_id) as countByGroup FROM table GROUP BY group_id

in the sphinx everything works correctly
when I pass the request to the ActiveDataProvider, it tries to calculate the total number in this way

SELECT COUNT(*) FROM (SELECT *, COUNT(group_id) as countByGroup FROM table GROUP BY group_id)

and I get an error: "Syntax error or access violation: 1064 sphinxql: outer select list must be a single star near '(SELECT *, COUNT(*)........."
so the question is simple: how to count the total number of all records from a query with grouping in Spinxql?

Answer 1

Apparently you are somehow incorrectly passing the request to the ActiveDataProvider

Answer 2

SELECT COUNT(DISTINCT group_id) FROM table