java/code/src/com/redhat/rhn/common/db/datasource/xml/Channel_queries.xml | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
New commits:
commit 081173fb42eff6c7cbab122cddf83790b9598145
Author: Tomas Lestach <tlestach(a)redhat.com>
Date: Fri Aug 30 14:24:30 2013 +0200
1002912 - fix Systems Subscribed column on the /rhn/channels/software/Entitlements.do page
diff --git a/java/code/src/com/redhat/rhn/common/db/datasource/xml/Channel_queries.xml b/java/code/src/com/redhat/rhn/common/db/datasource/xml/Channel_queries.xml
index f5c9de9..a35cb83 100644
--- a/java/code/src/com/redhat/rhn/common/db/datasource/xml/Channel_queries.xml
+++ b/java/code/src/com/redhat/rhn/common/db/datasource/xml/Channel_queries.xml
@@ -216,7 +216,7 @@ ORDER BY UPPER(C.name)
<query params="org_id">
SELECT CFO.id, CFO.name, CFO.label, CFO.current_members, CFO.max_members, CFO.has_subscription, CFO.url,
CFO.fve_current_members as current_flex, CFO.fve_max_members as max_flex,
- (select count(*)
+ (select count(distinct s.id)
from rhnServerChannel sc
inner join rhnChannelFamilyMembers CFM on CFM.channel_id = sc.channel_id
inner join rhnServer s on s.id = sc.server_id