From f8e71b44a39cf7b4d8185c57a46045636e7cc2a4 Mon Sep 17 00:00:00 2001 From: ivan Date: Sat, 18 Feb 2012 04:32:53 +0000 Subject: [PATCH] fix per-user commission reports to filter packages they didn't order, RT#15634 --- httemplate/search/part_pkg.html | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/httemplate/search/part_pkg.html b/httemplate/search/part_pkg.html index 8a4419857..2c9bdee1c 100644 --- a/httemplate/search/part_pkg.html +++ b/httemplate/search/part_pkg.html @@ -215,6 +215,6 @@ my $order_by = join(', ', @order_by); #my $count_query = "SELECT COUNT(*) FROM ( SELECT 1 FROM part_pkg $addl_from $extra_sql ) AS num"; #mysql? my $count_query = "SELECT COUNT(*) FROM ( SELECT DISTINCT part_pkg.pkgpart FROM part_pkg $addl_from $extra_sql ) AS num"; -warn $count_query; +#warn $count_query; -- 2.11.0