X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;ds=sidebyside;f=FS%2FFS%2Fcust_main%2FSearch.pm;h=3061b2c121e4bc027f4eb0c71d1b45a2923ffd0b;hb=656df6e610807dea9e2c58bd33f763e0e22f8cdc;hp=b1af41c2ab2e933bc88c2dc9e4890a66b77cc94a;hpb=1e88509da1f9e4cc1626f1714f64953f9efba8e3;p=freeside.git

diff --git a/FS/FS/cust_main/Search.pm b/FS/FS/cust_main/Search.pm
index b1af41c2a..3061b2c12 100644
--- 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'}) {