location fields on package churn report, #39988

diff --git a/httemplate/search/cust_pkg_churn.html b/httemplate/search/cust_pkg_churn.html
index 0ab99aa..30962c9 100644 (file)
--- a/httemplate/search/cust_pkg_churn.html
+++ b/httemplate/search/cust_pkg_churn.html
@@ -146,6 +146,7 @@ if ($pkg_query->{extra_sql}) {
 $extra_sql .= join(' AND ', @where);
 
 my $sql_query = {
+  'select'    => $pkg_query->{select},
   'table'     => $table,
   'addl_from' => $from,
   'extra_sql' => $extra_sql,