Query Almost Crashes Server

[floridawayne]

I have a Quad Core Server with 8GB Ram.

What uses this query, and why is it almost crashing the server?

Thanks.

780816 nmu98_techguy localhost nmu98_mainforum Query 15 Sorting result SELECT th
read.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount, thread.lastposte
r, thread.dateline, thread.views, thread.visible, thread.open, user.username, user.userid, user.u
sergroupid, user.displaygroupid^M\n\t\t\t\t\tFROM thread AS thread^M\n\t\t\t\t\tLEFT JOIN user AS
user ON (user.username = thread.lastposter)^M\n\t\t\t\t\tWHERE NOT ISNULL(thread.threadid) AND t
hread.visible = '1' AND thread.open!='10' AND thread.forumid NOT IN(75,113,151,92,185,176,254,76,
263,255,77,110,93,257,189,3,163,164,269,268,270,21 8,264,172,200,206,212,223) ^M\n\t\t\t\t\tORDER
BY lastpost DESC^M\n\t\t\t\t\tLIMIT 0, 10

[Lynne]

It looks like a custom query. I did a search in the files for "thread.forumid NOT IN" and go the search.php page, but it doesn't look like the full query is from there (I did a quick search - you should look through there too to verify that). Try searching through your plugins for that query.