BuddyPress.org

Hi everyone,

I’m trying to make a plugin to Suggest Friend to my users.

At this time, I suggest persons corresponding to xprofile fields.
I would like to suggest persons that have friends in common, like that :

Franck A : 5 friends in common
John D : 3 friends in common
Tom R : 1 friend in common

I don’t find the solution with a SQL query, do you have any idea on how to do that ?

Thanks a lot for your ideas.