RT# 77532 - search count is now correct

[freeside.git] / FS / FS / cust_main / Search.pm

diff --git a/FS/FS/cust_main/Search.pm b/FS/FS/cust_main/Search.pm
index b1af41c..3061b2c 100644 (file)
--- a/FS/FS/cust_main/Search.pm
+++ b/FS/FS/cust_main/Search.pm
@@ -1143,7 +1143,7 @@ sub search {
 
   }
 
-  my $count_query = "SELECT COUNT(*) FROM cust_main $addl_from $extra_sql";
+  my $count_query = "SELECT COUNT(DISTINCT cust_main.custnum) FROM cust_main $addl_from $extra_sql";
 
   if ($params->{'flattened_pkgs'}) {