Индексы в сфинкс серч

[ulan]

Подскажите как добавить в поиск сфинкса данные из поля <!--Custom_var3-->
сейчас вот такие индексы

Code: Select all

sql_query = SELECT gi.gallery_id, UNIX_TIMESTAMP(gi.activation_date) as date, alt, description, gi.duration, sponsor_id, gs.total_ctr, gi.content_type, \
                (SELECT group_concat(tag_name) FROM rot_gal2tag g2t \
                LEFT JOIN rot_tags as t on t.tag_id = g2t.tag_id \
                WHERE g2t.gallery_id = gi.gallery_id) as tags, \
                (SELECT group_concat(tag_id) FROM rot_gal2tag g2t \
                WHERE g2t.gallery_id = gi.gallery_id) as tag_ids, \
                (SELECT group_concat(name) FROM rot_groups  \
                WHERE rot_groups.id in (SELECT group_id FROM rot_gallery_stats1 WHERE rot_gallery_stats1.gallery_id = gi.gallery_id AND group_id != 0) ) as group_names, \
                                                                             \
                (SELECT group_concat(name) FROM rot_groups  \
                WHERE rot_groups.id in (SELECT group_id FROM rot_gallery_stats1 WHERE rot_gallery_stats1.gallery_id = gi.gallery_id AND group_id != 0) ) as group_names, \
                    \
                (SELECT group_concat(gss.group_id) FROM rot_gallery_stats1 as gss \
                WHERE gss.gallery_id = gi.gallery_id AND group_id != 0) as categories \
                FROM rot_gallery_info AS gi \
                JOIN rot_gallery_data1 AS gd ON gi.gallery_id = gd.gallery_id \
                JOIN rot_gallery_stats1 AS gs ON gs.gallery_id = gi.gallery_id \
                WHERE gallery_status = 'active' and gallery_type = 0 \
                and gs.best_thumb = 'yes' and gs.group_id = 0 AND gs.group_id NOT IN (SELECT group_id FROM rot_groups_data WHERE status != 1)

[admin]

например после alt, написать custom_var3