summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-rw-r--r--extensions/ProdCompSearch/lib/WebService.pm1
1 files changed, 1 insertions, 0 deletions
diff --git a/extensions/ProdCompSearch/lib/WebService.pm b/extensions/ProdCompSearch/lib/WebService.pm
index 3f8f0b75e..d668809f6 100644
--- a/extensions/ProdCompSearch/lib/WebService.pm
+++ b/extensions/ProdCompSearch/lib/WebService.pm
@@ -93,6 +93,7 @@ sub prod_comp_search {
INNER JOIN components ON products.id = components.product_id
WHERE (" . join(" AND ", @terms) . ")
AND products.id IN (" . join(",", @$enterable_ids) . ")
+ AND components.isactive = 1
ORDER BY " . join(", ", @order) . " $limit",
{ Slice => {} });