[kh99]

Originally Posted by Ghostt

this "sorting result" query.
why no one can explain why this query often slow and apear all the time?

| Query | 1 | Sorting result | SELECT thread.threadid,
thread.lastpost, thread.lastposter, thread.lastpostid, thread.replycount |

-i found this line in /tags.php

That looks like it might be a search for threads with a given tag. I don't know why that would happen often. I suppose you could check your web server logs and see if someone is actually doing a search, or if it's a spider or something.