diff options
| -rw-r--r-- | extensions/ProdCompSearch/lib/WebService.pm | 1 |
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 => {} }); |