# nutzung der Doctrine Extension ifnull

**URL:** <https://forum.shopware.com/t/nutzung-der-doctrine-extension-ifnull/13645>\
**Category:** Shopware 3.5\
**Tags:** programming\
**Created:** [9. Juni 2013 um 13:21 UTC](https://forum.shopware.com/t/nutzung-der-doctrine-extension-ifnull/13645 "2013-06-09T13:21:45Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![finkkraft](https://avatars.discourse-cdn.com/v4/letter/f/3bc359/32.png) [@finkkraft](https://forum.shopware.com/u/finkkraft)\
**Post date:** [9. Juni 2013 um 13:21 UTC](https://forum.shopware.com/t/nutzung-der-doctrine-extension-ifnull/13645/1 "2013-06-09T13:21:45Z")

</div>

hallo leutz, kann mir jemand von euch kurz erklären, wie ich die DoctrineExtensions\Query\Mysql\IfNull in meiner query nutzen kann? `$builder = Shopware()-\>Models()-\>createQueryBuilder(); $builder-\>select(array('articles', 'attributes', 'details', 'prices', 'category')); $builder-\>from('Shopware\Models\Article\Article', 'articles'); $builder-\>leftJoin('articles.attribute', 'attributes'); $builder-\>leftJoin('articles.details', 'details'); $builder-\>leftJoin('details.prices', 'prices'); $builder-\>leftJoin('articles.categories', 'category'); $builder-\>where('category.id IN ('.implode(',', $categories).')'); $builder-\>addGroupBy('articles.id'); $builder-\>setFirstResult($start); $builder-\>setMaxResults($limit); $query = $builder-\>getQuery();`