#34: Indexing the results of an nested set ancestry query

I would like to use Sphinx and ThinkingSphinx to index the results of a nested set ancestry query, but I'm not entire sure how. The kind of query I need to do would be something like

SELECT id FROM taxa WHERE taxa.lft <= $target_taxon_lft AND taxa.rgt >= $target_taxon_rgt;

If I could somehow work the IDs from that query into a multi-value Sphinx attribute for each taxon, I would be golden. I just can't quite figure out how.

Think you've got a solution? Help 148c663fd665c53518538e093ce3c2ab_small kueda out by posting your solution