X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=httemplate%2Fsearch%2Fsvc_phone.cgi;h=0ad458b72060b73266614e2af29881a6e1b39f75;hb=d0221fabd4656b3a04251ca6168cc45f54d23574;hp=21e1a92333c50771368d6f1dbf7b80a690839447;hpb=0681cc7e7224bf00988d7851c233dca6a2b0d5d7;p=freeside.git

diff --git a/httemplate/search/svc_phone.cgi b/httemplate/search/svc_phone.cgi
index 21e1a9233..0ad458b72 100644
--- a/httemplate/search/svc_phone.cgi
+++ b/httemplate/search/svc_phone.cgi
@@ -102,7 +102,7 @@ if ( $cgi->param('magic') =~ /^(all|unlinked)$/ ) {
 
       my $f_w =
         " FROM cdr_termination LEFT JOIN cdr USING ( acctid ) ".
-        " WHERE cdr.acctid = svc_phone.phonenum ". # XXX connectone-specific
+        " WHERE cdr.carrierid = CAST(svc_phone.phonenum AS BIGINT) ". # XXX connectone-specific, has to match svc_external.id :/
         $and_date;
 
       push @select,