mambax7 / publisher

            return $ret;

        }

        $theObjects = [];

        while (false !== ($myrow = $this->db->fetchArray($result))) {

            $item = new PublisherItem();

            $item->assignVars($myrow);

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

            unset($item);

        }

        foreach ($theObjects as $theObject) {

            if ('none' === $idKey) {

                $ret[] = $theObject;

        $sql    .= ' GROUP BY categoryid)mo';

        $sql    .= ' JOIN ' . $this->db->prefix($this->publisher->getDirname() . '_items') . ' mi ON mi.datesub = mo.date';

        $result = $this->db->query($sql);

        while (false !== ($row = $this->db->fetchArray($result))) {

            $item = new PublisherItem();

            $item->assignVars($row);

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

            unset($item);

        }

        return $ret;

    }