eZ\Publish\Core\Persistence\Legacy\Content\Type\Gateway\DoctrineDatabase::getLoadTypeQuery PHP Method

    protected function getLoadTypeQuery()
    {
        $q = $this->dbHandler->createSelectQuery();
        $this->selectColumns($q, 'ezcontentclass');
        $this->selectColumns($q, 'ezcontentclass_attribute');
        $q->select($this->dbHandler->aliasedColumn($q, 'group_id', 'ezcontentclass_classgroup'));
        $q->from($this->dbHandler->quoteTable('ezcontentclass'))->leftJoin($this->dbHandler->quoteTable('ezcontentclass_attribute'), $q->expr->lAnd($q->expr->eq($this->dbHandler->quoteColumn('id', 'ezcontentclass'), $this->dbHandler->quoteColumn('contentclass_id', 'ezcontentclass_attribute')), $q->expr->eq($this->dbHandler->quoteColumn('version', 'ezcontentclass'), $this->dbHandler->quoteColumn('version', 'ezcontentclass_attribute'))))->leftJoin($this->dbHandler->quoteTable('ezcontentclass_classgroup'), $q->expr->lAnd($q->expr->eq($this->dbHandler->quoteColumn('id', 'ezcontentclass'), $this->dbHandler->quoteColumn('contentclass_id', 'ezcontentclass_classgroup')), $q->expr->eq($this->dbHandler->quoteColumn('version', 'ezcontentclass'), $this->dbHandler->quoteColumn('contentclass_version', 'ezcontentclass_classgroup'))))->orderBy($this->dbHandler->quoteColumn('placement', 'ezcontentclass_attribute'));
        return $q;
    }