[Wayne Luke]

Looks like one of the search queries.

Actual query is as line 1503 in search.php within vBulletin 3.6.8, the building of the query is before that.

PHP Code:

     $threads = $db->query_read_slave("
      SELECT
      " . implode(', ', $thread_select_logic) . "
      FROM " . TABLE_PREFIX . "thread AS thread $userid_index
      " . ((!empty($post_query_logic) OR !empty($post_join_query_logic)) ? "INNER JOIN " . TABLE_PREFIX . "post AS post ON(thread.threadid = post.threadid $post_join_query_logic)" : "") . "
      " . (!empty($querylogic) ? "WHERE " . implode(" AND ", $querylogic) : "") . "
      $nl_query_limit
     "); 


Searching is fairly intensive. Might want to reduce the number of results returned if you don't already.