From 61a971cd65be2eaaa923af0f17a00159cc0e8222 Mon Sep 17 00:00:00 2001
From: Matt Tyson <mtyson@redhat.com>
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(-)

(limited to 'Bugzilla/User.pm')

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