Search Results V3.12

Wow, I see what you mean. Lots more "stuff" in yours. I thought reading the search code in V3.12 was a mess but I don't have any of the tmp3/tmp4/tmp5, App-S, App-E stuff to cope with.

This looks very peculiar to me
"
query=replace(query, " ORDER", tmp5 & " ORDER")"
"

Looks like they're using " ORDER" as place holder in "query" and then sticking in the tmp5 string (which appears to do the selects) + " ORDER" using the replace. Not sure why the select strings weren't built into the process of building the query.

If I were you, I'd try changing, line 198?,
"
ORDER BY categories.categoryDesc
"
to
"
ORDER BY categories.idParentCategory, categories.idCategory, categories.categoryDesc
"

And that would also mean changing below, line 185?, to add idParentCategory
"
strSQL= "SELECT "& pcv_strLimitPhrase &" COUNT(categories.idcategory) AS ProductCount, categories.idcategory, categories.categoryDesc
"
to
"
strSQL= "SELECT "& pcv_strLimitPhrase &" COUNT(categories.idcategory) AS ProductCount, categories.idcategory, categories.categoryDesc, categories.idParentCategory "
"

Also don't forget to add the idParentCategory to the Group By, line 568?
"
tmp5=tmp5 & "GROUP BY categories.idcategory, categories.categoryDesc
"
to
"
tmp5=tmp5 & "GROUP BY categories.idParentCategory, categories.idcategory, categories.categoryDesc
"

Sorry, I didn't know that my files were that much different than V3.11. Maybe in the next version things will get even simpler? This is a bit intimidating to work with.

Good luck