Sphinx: how to index an array?

Question

Sphinx

There is such a database model:
item :
-item_id
-title
-desk
-other
There is another table:
item_types:
-item_type_id
-item_id
-views
-clicks
and there can be a lot of data in the second table with the same item_id
There is a query on the sphinx: find posts by title (item:title) and sort them by views (clicks or clicks/views) where item_type_id = 1(let's say)
Question: How can you store item_types?

Answer 1

Do it in two requests