BuddyPress.org

update: for an individual activity BP uses the function call $fav_count = bp_activity_get_meta( $activity_id, ‘favorite_count’ );

If you look at bp_activity_get_meta you should be able to determine the table used, and the SQL query to build.