Read the blogs!
// Find the 10 most recent messages they can *view*. // !!!SLOW This query is really slow. $request = db_query(" SELECT m.ID_MSG FROM {$db_prefix}messages AS m, {$db_prefix}boards AS b WHERE b.ID_BOARD = m.ID_BOARD" . (!empty($modSettings['recycle_enable']) && $modSettings['recycle_board'] > 0 ? " AND b.ID_BOARD != $modSettings[recycle_board]" : '') . " AND $user_info[query_see_board] ORDER BY m.ID_MSG DESC LIMIT 10", __FILE__, __LINE__);
// Get all the most recent posts. $request = db_query(" SELECT m.ID_MSG, m.subject, m.smileysEnabled, m.posterTime, m.body, m.ID_TOPIC, t.ID_BOARD, b.ID_CAT, b.name AS bname, c.name AS cname, t.numReplies, m.ID_MEMBER, m2.ID_MEMBER AS ID_FIRST_MEMBER, IFNULL(mem2.realName, m2.posterName) AS firstPosterName, t.ID_FIRST_MSG, IFNULL(mem.realName, m.posterName) AS posterName, t.ID_LAST_MSG FROM {$db_prefix}messages AS m, {$db_prefix}messages AS m2, {$db_prefix}topics AS t, {$db_prefix}boards AS b, {$db_prefix}categories AS c LEFT JOIN {$db_prefix}members AS mem ON (mem.ID_MEMBER = m.ID_MEMBER) LEFT JOIN {$db_prefix}members AS mem2 ON (mem2.ID_MEMBER = m2.ID_MEMBER) WHERE m2.ID_MSG = t.ID_FIRST_MSG AND t.ID_TOPIC = m.ID_TOPIC AND b.ID_BOARD = t.ID_BOARD AND c.ID_CAT = b.ID_CAT AND m.ID_MSG IN (" . implode(', ', $messages) . ") ORDER BY m.ID_MSG DESC LIMIT 0, 10", __FILE__, __LINE__);