I had 1 next to the New Member Connection Request and when I clicked on it to go check it out, this is what I saw... 

user warning: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay query: SELECT requestee_uid, requester_uid, field_first_name_value AS firstname, field_last_name_value AS lastname, IF(field_profession_value like 'Other%', field_other_job_title_value, field_profession_value ) AS profession, field_name_of_company_value AS company, picture AS picture, field_city_value AS city, field_state_province_value AS state FROM buddylist_pending_requests AS b INNER JOIN users AS u ON b.requester_uid = u.uid INNER JOIN node AS n ON u.uid = n.uid AND n.type = 'user_profile' INNER JOIN content_type_user_profile AS ctup ON n.vid = ctup.vid INNER JOIN content_field_other_job_title AS ojt ON n.vid = ojt.vid LEFT JOIN node AS v ON u.uid = v.vid AND v.type = 'vcard' LEFT JOIN content_field_city ON v.nid = content_field_city.nid LEFT JOIN content_field_state_province ON v.nid = content_field_state_province.nid WHERE b.requestee_uid = 71488 in /mnt/shared/web/sites/prod/script_releases/1202435980/includes/database.mysql.inc on line 172.