$sql='SELECT COUNT(ord.OrderId) as OrderCount, SUM(AffiliateCommission) as TotalCommission, SUM(SubTotal+ShippingCost+VAT-CouponDiscount) as TotalAmount
FROM '.TABLE_PREFIX.'Orders ord
LEFT JOIN '.TABLE_PREFIX.'Affiliates af ON (vis.AffiliateId = af.AffiliateId)
LEFT JOIN '.TABLE_PREFIX.'Visits vis ON (ord.VisitId = vis.VisitId)
WHERE af.PortalUserId = '.$object_user->GetDBField('PortalUserId').'
+ AND ord.Status = 4
GROUP BY af.PortalUserId
';
$info = $this->Conn->GetRow($sql);
$params_info = $this->prepareTagParams($params);
$params_info['name'] = $params_info['render_as'];
if (!$info['OrderCount']) $info['OrderCount'] = 0;
if (!$info['TotalAmount']) $info['TotalAmount'] = 0;
if (!$info['AffiliateCommission']) $info['AffiliateCommission'] = 0;