How to search for multiple matches grouped by some field?

Question

Sphinx

Analogue in sql:

select
    distinct
    group_id,
    text
from index_1 as i1
where text like '%search_text_1%'
    and exists (select 1 from index_1 as i2 where i2.group_id = i1.group_id and i2.text like
    '%search_text_2%')

An attempt on the Sphinx:

select
    group_id,
    text
from index_1
where match('@text %search_text_1%')
...?
group by group_id

Tell me please

Answer 1

The query looks like "find a group for which one document has one text, and another (or the same) has another". It seems to me that you need to make an index in which the document is a group, and just look for both matches at once. Why is that:

• If you search by "AND", then there will be only group documents in which there is both one and the other text (i.e. the situation "in another document the second text" is not found)
  
• If you search by "OR" and then filter the results by HAVING COUNT(*) > 1, then you get extra results (2 documents with the first text)