Index: trunk/core/units/visits/visits_tag_processor.php =================================================================== diff -u -N -r2737 -r2759 --- trunk/core/units/visits/visits_tag_processor.php (.../visits_tag_processor.php) (revision 2737) +++ trunk/core/units/visits/visits_tag_processor.php (.../visits_tag_processor.php) (revision 2759) @@ -44,12 +44,17 @@ $sql = 'SELECT '.$affil_idfield.' FROM '.$affil_table.' WHERE PortalUserId = '.$this->Application->GetVar('u_id'); $affiliate_id = $this->Conn->GetOne($sql); - $sql = 'SELECT COUNT(DISTINCT vis.PortalUserId) AS TotalVisitors, COUNT(ord.OrderId) AS OrderCount + $sql = 'SELECT COUNT(ord.OrderId) AS OrderCount FROM '.$list->TableName.' vis LEFT JOIN '.TABLE_PREFIX.'Orders ord ON ord.VisitId = vis.VisitId WHERE (vis.AffiliateId = '.$affiliate_id.') AND (ord.Status = '.ORDER_STATUS_PROCESSED.')'.($date_limit ? ' AND '.$date_limit : ''); $result = $this->Conn->GetRow($sql); + + $sql = 'SELECT COUNT(*) FROM '.$list->TableName.' vis + WHERE AffiliateId = '.$affiliate_id.($date_limit ? ' AND '.$date_limit : ''); + + $result['TotalVisitors'] = $this->Conn->GetOne($sql); $result['OrderTotalAmount'] = $list->getTotal('OrderTotalAmount', 'SUM'); $result['OrderAffiliateCommission'] = $list->getTotal('OrderAffiliateCommission', 'SUM');