How to keep sorting when grouping in Sphinx?

Question

Sphinx

Good afternoon!
The request itself

SELECT json FROM shop 
    WHERE folders IN (123,5456,789) 
    GROUP BY json._id WITHIN GROUP ORDER BY is_master DESC
    ORDER BY integer(json.data_vyezda) ASC 
    LIMIT 0, 40;

The problem is that when grouping, sorting is lost.
Please tell me what are the possible solutions to the problem?

Answer 1

ORDER BY FIND_IN_SET(folders, '123,5456,789')