BuddyPress.org

bp-activity/bp-activity-classes.php will be where all the SQL happens. Note that the Activity Stream’s database uses a MPTT structure, so unless yours does, it may be worth looking at the WP Core comments query builder.