Query causing huge load ..

[eluser]GSV Sleeper Service[/eluser]
you might have to add a few indices to your tables. get the SQL that the query generates, stick EXPLAIN in front of it, then run that query in phpmyadmin, you'll see a lot of performance information, and from there'll you'll be able to see what tables/columns need indexing.