UBB.Developers Forums General Discussion Suggestions and Feedback What is this query doing ??

Let me clarify my question ...

There are three type of 'search' :

• 1. Show the user's all post (from showprofile.php) : This is done in dosearch.php , and it is very 'light' to MySQL , and can be response in 1 second. I DO NOT want to disable it.
  
• 2. Text Search : This is done in search.php/tmpl and postlist.tmpl (at bottom) , and this form posts to dosearch.php and trigger 'SQL LIKE' query . This is a very heavy query , I have disabled both button in search.tmpl and postlist.tmpl , that no one can do any text search.
  
• 3. This strange query . It is not a 'SQL LIKE' query , so , it is not text search. I observed this query from mytop ( http://jeremy.zawodny.com/mysql/mytop/ ) . This query often crashes my system , but I just cannot re-produce this query . I don't who clicks what button or link triggers this strange query. And when I manual query this query , just got a list of posts , not from a specific user.