From 61a971cd65be2eaaa923af0f17a00159cc0e8222 Mon Sep 17 00:00:00 2001 From: Matt Tyson Date: Tue, 28 Jul 2015 18:28:13 +0200 Subject: Bug 1183492: Optimize the SQL query for get_enterable_products() r=LpSolit a=sgreen --- Bugzilla/User.pm | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/Bugzilla/User.pm b/Bugzilla/User.pm index 8df1316c5..d6c1f1225 100644 --- a/Bugzilla/User.pm +++ b/Bugzilla/User.pm @@ -1431,10 +1431,10 @@ sub get_enterable_products { WHERE ' . $dbh->sql_in('products.id', $enterable_ids) . ' AND products.id IN (SELECT DISTINCT components.product_id FROM components - WHERE components.isactive = 1) + WHERE components.isactive = 1 AND products.id = components.product_id) AND products.id IN (SELECT DISTINCT versions.product_id FROM versions - WHERE versions.isactive = 1)'); + WHERE versions.isactive = 1 AND products.id = versions.product_id)'); } $self->{enterable_products} = -- cgit v1.2.3-24-g4f1b