XOOPS / XoopsCore

        $this->addNotNullFieldClause($qb, $notNullFields, $whereMode);

        $theObjects = array();

        $result = $qb->execute();

        while ($myrow = $result->fetch(\PDO::FETCH_ASSOC)) {

            $item = new PublisherItem();

            $item->assignVars($myrow);

            $theObjects[$myrow['itemid']] = $item;

            unset($item);

        }

        /* @var $theObject PublisherItem */

        foreach ($theObjects as $theObject) {

            ->joinPrefix('mo', 'publisher_items', 'mi', 'mi.datesub = mo.date');

        $result = $qb->execute();

        while ($row = $result->fetch(\PDO::FETCH_ASSOC)) {

            $item = new PublisherItem();

            $item->assignVars($row);

            $ret[$row['categoryid']] = $item;

            unset($item);

        }

        return $ret;

    }