Sphinx SE screw table with @count filter options

Question

Sphinx

Hello to all residents of Habr!

I'm trying to set up a sphinx module for mysql so that I can join to it in the future.

I have the following query for counting the number of multi attribute options:

SELECT *, COUNT(*) as cnt FROM productIndex WHERE MATCH('') GROUP BY color_id ORDER BY cnt DESC LIMIT 0,100;

It outputs something like this:


And I can't figure out how to get the exact same result in mysql. That is, so that it would be possible to join @ count by color_id

Answer 1

I already read in the documentation that you can bandage a column if you specify the prefix `_sph_` instead of a dog, that is, `_sph_count`.