Bug 1183492: Optimize the SQL query for get_enterable_products()

r=LpSolit a=sgreen

1 files 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} =