initial query to determine social network from reverts