Fatal error: Uncaught Doctrine\DBAL\Query\QueryException: The given alias 'manufacturer' is not unique in FROM and JOIN clause table. The currently registered aliases are: product, variant, productCategory, avoidCustomerGroup, manufacturer. in /www/htdocs/w0131346/davert-shop-live/vendor/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryException.php:35 Stack trace: #0 /www/htdocs/w0131346/davert-shop-live/vendor/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(1401): Doctrine\DBAL\Query\QueryException::nonUniqueAlias('manufacturer', Array) #1 /www/htdocs/w0131346/davert-shop-live/vendor/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(1234): Doctrine\DBAL\Query\QueryBuilder->getSQLForJoins('product', Array) #2 /www/htdocs/w0131346/davert-shop-live/vendor/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(1197): Doctrine\DBAL\Query\QueryBuilder->getFromClauses() #3 /www/htdocs/w0131346/davert-shop-live/vendor/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(252): Doctrine\DBAL\Query\QueryBuilder->getSQLForSelect() #4 /www/htdocs/w0131346/davert-shop-live/vendor/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(212): Doctrine\DBAL\Query\QueryBuilder->getSQL() #5 /www/htdocs/w0131346/davert-shop-live/engine/Shopware/Bundle/SearchBundleDBAL/FacetHandler/CombinedConditionFacetHandler.php(83): Doctrine\DBAL\Query\QueryBuilder->execute() #6 /www/htdocs/w0131346/davert-shop-live/engine/Shopware/Bundle/SearchBundleDBAL/FacetHandler/CombinedConditionFacetHandler.php(62): Shopware\Bundle\SearchBundleDBAL\FacetHandler\CombinedConditionFacetHandler->getFacet(Object(Shopware\Bundle\SearchBundle\Facet\CombinedConditionFacet), Object(Shopware\Bundle\SearchBundle\Criteria), Object(Shopware\Bundle\SearchBundle\Criteria), Object(Shopware\Bundle\StoreFrontBundle\Struct\ShopContext)) #7 /www/htdocs/w0131346/davert-shop-live/engine/Shopware/Bundle/SearchBundleDBAL/ProductNumberSearch.php(158): Shopware\Bundle\SearchBundleDBAL\FacetHandler\CombinedConditionFacetHandler->generatePartialFacet(Object(Shopware\Bundle\SearchBundle\Facet\CombinedConditionFacet), Object(Shopware\Bundle\SearchBundle\Criteria), Object(Shopware\Bundle\SearchBundle\Criteria), Object(Shopware\Bundle\StoreFrontBundle\Struct\ShopContext)) #8 /www/htdocs/w0131346/davert-shop-live/engine/Shopware/Bundle/SearchBundleDBAL/ProductNumberSearch.php(91): Shopware\Bundle\SearchBundleDBAL\ProductNumberSearch->createFacets(Object(Shopware\Bundle\SearchBundle\Criteria), Object(Shopware\Bundle\StoreFrontBundle\Struct\ShopContext)) #9 /www/htdocs/w0131346/davert-shop-live/engine/Shopware/Bundle/SearchBundle/ProductSearch.php(59): Shopware\Bundle\SearchBundleDBAL\ProductNumberSearch->search(Object(Shopware\Bundle\SearchBundle\Criteria), Object(Shopware\Bundle\StoreFrontBundle\Struct\ShopContext)) #10 /www/htdocs/w0131346/davert-shop-live/engine/Shopware/Bundle/SearchBundle/VariantSearch.php(66): Shopware\Bundle\SearchBundle\ProductSearch->search(Object(Shopware\Bundle\SearchBundle\Criteria), Object(Shopware\Bundle\StoreFrontBundle\Struct\ShopContext)) #11 /www/htdocs/w0131346/davert-shop-live/engine/Shopware/Core/sArticles.php(2441): Shopware\Bundle\SearchBundle\VariantSearch->search(Object(Shopware\Bundle\SearchBundle\Criteria), Object(Shopware\Bundle\StoreFrontBundle\Struct\ShopContext)) #12 /www/htdocs/w0131346/davert-shop-live/engine/Shopware/Core/sArticles.php(505): sArticles->getListing(3, Object(Shopware\Bundle\StoreFrontBundle\Struct\ShopContext), Object(Enlight_Controller_Request_RequestHttp), Object(Shopware\Bundle\SearchBundle\Criteria)) #13 /www/htdocs/w0131346/davert-shop-live/engine/Shopware/Controllers/Frontend/Listing.php(220): sArticles->sGetArticlesByCategory(3, Object(Shopware\Bundle\SearchBundle\Criteria)) #14 /www/htdocs/w0131346/davert-shop-live/engine/Library/Enlight/Controller/Action.php(187): Shopware_Controllers_Frontend_Listing->manufacturerAction(Object(Shopware\Bundle\StoreFrontBundle\Struct\ShopContext)) #15 /www/htdocs/w0131346/davert-shop-live/engine/Library/Enlight/Controller/Dispatcher/Default.php(467): Enlight_Controller_Action->dispatch('manufacturerAct...') #16 /www/htdocs/w0131346/davert-shop-live/engine/Library/Enlight/Controller/Front.php(225): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp)) #17 /www/htdocs/w0131346/davert-shop-live/engine/Shopware/Kernel.php(197): Enlight_Controller_Front->dispatch() #18 /www/htdocs/w0131346/davert-shop-live/vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php(85): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #19 /www/htdocs/w0131346/davert-shop-live/vendor/symfony/http-kernel/HttpCache/HttpCache.php(479): Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle(Object(Shopware\Kernel), Object(Symfony\Component\HttpFoundation\Request), 1, true) #20 /www/htdocs/w0131346/davert-shop-live/engine/Shopware/Components/HttpCache/AppCache.php(266): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #21 /www/htdocs/w0131346/davert-shop-live/vendor/symfony/http-kernel/HttpCache/HttpCache.php(452): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true) #22 /www/htdocs/w0131346/davert-shop-live/vendor/symfony/http-kernel/HttpCache/HttpCache.php(346): Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch(Object(Symfony\Component\HttpFoundation\Request), true) #23 /www/htdocs/w0131346/davert-shop-live/engine/Shopware/Components/HttpCache/AppCache.php(192): Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true) #24 /www/htdocs/w0131346/davert-shop-live/vendor/symfony/http-kernel/HttpCache/HttpCache.php(224): Shopware\Components\HttpCache\AppCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true) #25 /www/htdocs/w0131346/davert-shop-live/engine/Shopware/Components/HttpCache/AppCache.php(117): Symfony\Component\HttpKernel\HttpCache\HttpCache->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #26 /www/htdocs/w0131346/davert-shop-live/shopware.php(122): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request)) #27 {main} thrown in /www/htdocs/w0131346/davert-shop-live/vendor/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryException.php on line 35