In our recent project we implemented Sphinx Search for an osCommerce based site. We included the full path (breadcrumb) of category into search. I thought the breadcrumb query might be helpful for many developers. Note we had the nested categories up to 9 levels, you can easily adjust query for any level. You may or may not need the id or name so you can remove to make query simple