# Stream : Fehler bei Verwendung des Operators IN

**URL:** <https://forum.shopware.com/t/stream-fehler-bei-verwendung-des-operators-in/31900>\
**Category:** Administration\
**Created:** [3. November 2015 um 13:54 UTC](https://forum.shopware.com/t/stream-fehler-bei-verwendung-des-operators-in/31900 "2015-11-03T13:54:04Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![bringts](https://avatars.discourse-cdn.com/v4/letter/b/ecc23a/32.png) [@bringts](https://forum.shopware.com/u/bringts)\
**Post date:** [3. November 2015 um 13:54 UTC](https://forum.shopware.com/t/stream-fehler-bei-verwendung-des-operators-in/31900/1 "2015-11-03T13:54:04Z")

</div>

Shopware Version 5.1.1 Prof. Version Fehler der bei Erstellung eines Streams auftritt: Fehler tritt immer auf wenn als Operator IN ausgewählt wird: Haben auch versucht auf [http://www.shopwaredemo.de](http://www.shopwaredemo.de) einen Stream mit dem Operator IN auf ein Attribut zu erstellen, bekommen gleichen Fehler. Filter: Attribut Filter auf attr2 Operator: IN Wert: 100 Bekommen Fehler: Der Aufruf der Seite konnte nicht durchgeführt werden. Die nachfolgenden Hinweise sollten Ihnen weiterhelfen. An exception occurred while executing ‘SELECT SQL\_CALC\_FOUND\_ROWS product.id as \_\_product\_id, variant.id as \_\_variant\_id, variant.ordernumber as \_\_variant\_ordernumber FROM s\_articles product INNER JOIN s\_articles\_details variant ON variant.id = product.main\_detail\_id AND variant.active = 1 AND product.active = 1 INNER JOIN s\_core\_tax tax ON tax.id = product.taxID LEFT JOIN s\_articles\_avoid\_customergroups avoidCustomerGroup ON avoidCustomerGroup.articleID = product.id AND avoidCustomerGroup.customerGroupId IN (?) INNER JOIN s\_articles\_categories\_ro productCategory ON productCategory.articleID = product.id AND productCategory.categoryID IN (?) INNER JOIN s\_articles\_attributes productAttribute ON productAttribute.articledetailsID = variant.id WHERE (avoidCustomerGroup.articleID IS NULL) AND (productAttribute.attr2 IN (?)) GROUP BY product.id ORDER BY product.datum desc, product.changetime desc, product.id desc LIMIT 25’ with params [1, 3]: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens in vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php on line 119 Stack trace: #0 vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(836): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(PDOException), ‘SELECT SQL\_CALC…’, Array) #1 vendor/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(206): Doctrine\DBAL\Connection-\>executeQuery(‘SELECT SQL\_CALC…’, Array, Array) #2 Shopware/Bundle/SearchBundleDBAL/ProductNumberSearch.php(117): Doctrine\DBAL\Query\QueryBuilder-\>execute() #3 Shopware/Bundle/SearchBundleDBAL/ProductNumberSearch.php(95): Shopware\Bundle\SearchBundleDBAL\ProductNumberSearch-\>getProducts(Object(Shopware\Bundle\SearchBundleDBAL\QueryBuilder)) #4 Shopware/Bundle/SearchBundle/ProductSearch.php(65): Shopware\Bundle\SearchBundleDBAL\ProductNumberSearch-\>search(Object(Shopware\Bundle\SearchBundle\Criteria), Object(Shopware\Bundle\StoreFrontBundle\Struct\ProductContext)) #5 Shopware/Controllers/Backend/ProductStream.php(81): Shopware\Bundle\SearchBundle\ProductSearch-\>search(Object(Shopware\Bundle\SearchBundle\Criteria),