# Versand mit eigenen Bedingungen - Column not found: 1054 Unknown column 'b.ordernumber'

**URL:** <https://forum.shopware.com/t/versand-mit-eigenen-bedingungen-column-not-found-1054-unknown-column-b-ordernumber/61965>\
**Category:** Administration\
**Created:** [24. September 2019 um 17:22 UTC](https://forum.shopware.com/t/versand-mit-eigenen-bedingungen-column-not-found-1054-unknown-column-b-ordernumber/61965 "2019-09-24T17:22:23Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![manatwork81](https://avatars.discourse-cdn.com/v4/letter/m/c77e96/32.png) [@manatwork81](https://forum.shopware.com/u/manatwork81)\
**Post date:** [24. September 2019 um 17:22 UTC](https://forum.shopware.com/t/versand-mit-eigenen-bedingungen-column-not-found-1054-unknown-column-b-ordernumber/61965/1 "2019-09-24T17:22:23Z")

</div>

Hallo!

Ich habe bei mir einen zubuchbaren Artikel “Zust0000” der für eine Zustellung vor ort ist.

Wenn diese im Warenkorn ist, sollten alle anderen Versandarten ausgeblendet werden und nur Zustellung aufscheinen.

&nbsp;

Hasbe folgendes eingetragen:&nbsp;IF(b.ordernumber like ‘%Zust%’,1,0) alternativ&nbsp;&nbsp;IF(d.ordernumber like ‘%Zust%’,1,0)

Folgendes passiert im LOG

```
PDOException: SQLSTATE(42S22): Column not found: 1054 Unknown column 'b.ordernumber' in 'where clause' in /vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:907 Stack trace:
#0 /vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(907): PDOStatement->execute()
#1 /vendor/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(206): Doctrine\DBAL\Connection->executeQuery('SELECT d.id as ...', Array, Array)
#2 /engine/Shopware/Core/sAdmin.php(2789): Doctrine\DBAL\Query\QueryBuilder->execute()
#3 /engine/Shopware/Controllers/Frontend/Checkout.php(1590): sAdmin->sGetPremiumDispatches('2', NULL, NULL)
#4 /engine/Shopware/Controllers/Frontend/Checkout.php(749): Shopware_Controllers_Frontend_Checkout->getSelectedDispatch()
#5 /engine/Library/Enlight/Controller/Action.php(192): Shopware_Controllers_Frontend_Checkout->shippingPaymentAction()
#6 /engine/Library/Enlight/Controller/Dispatcher/Default.php(478): Enlight_Controller_Action->dispatch('shippingPayment...')
#7 /engine/Library/Enlight/Controller/Front.php(228): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp))
#8 /engine/Shopware/Kernel.php(185): Enlight_Controller_Front->dispatch()
#9 /vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php(102): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)
#10 /vendor/symfony/http-kernel/HttpCache/HttpCache.php(448): Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle(Object(Shopware\Kernel), Object(Symfony\Component\HttpFoundation\Request), 1, true)
#11 /engine/Shopware/Components/HttpCache/AppCache.php(256): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL)
#12 /vendor/symfony/http-kernel/HttpCache/HttpCache.php(420): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true)
#13 /vendor/symfony/http-kernel/HttpCache/HttpCache.php(317): Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch(Object(Symfony\Component\HttpFoundation\Request), true)
#14 /engine/Shopware/Components/HttpCache/AppCache.php(183): Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true)
#15 /vendor/symfony/http-kernel/HttpCache/HttpCache.php(192): Shopware\Components\HttpCache\AppCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true)
#16 /engine/Shopware/Components/HttpCache/AppCache.php(110): Symfony\Component\HttpKernel\HttpCache\HttpCache->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)
#17 /var/www/clients/client1/web2/web/shopware.php(122): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request))
#18

```

Was mache ich hier falsch, die Dokumentation hilft mir auch nicht weiter. Hab ich hier etwas nicht gemacht, oder ist das ein BUG?

PS: Vers 5.6.1 & Danke im Voraus

&nbsp;

---

<div class="post-metadata">

**Author:** ![Moritz\_Naczenski](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.shopware.com/moritz_naczenski/32/7792_2.png) [@Moritz\_Naczenski](https://forum.shopware.com/u/Moritz_Naczenski)\
**Post date:** [24. September 2019 um 17:42 UTC](https://forum.shopware.com/t/versand-mit-eigenen-bedingungen-column-not-found-1054-unknown-column-b-ordernumber/61965/2 "2019-09-24T17:42:00Z")

</div>

Die Ordernumber ist in den Details, daher d.ordernumber, einmal nutzt du aber b.