thecodingmachine / database.tdbm

        if ($columnsList !== null) {

            $joinSql = '';

            $parentFks = $this->getParentRelationshipForeignKeys($mainTable);

            foreach ($parentFks as $fk) {

                $joinSql .= sprintf(' JOIN %s ON (%s.%s = %s.%s)',

                    $this->connection->quoteIdentifier($fk->getForeignTableName()),

                    $this->connection->quoteIdentifier($fk->getLocalTableName()),

                    $this->connection->quoteIdentifier($fk->getLocalColumns()[0]),

                    $this->connection->quoteIdentifier($fk->getForeignTableName()),

                    $this->connection->quoteIdentifier($fk->getForeignColumns()[0])

                    );

            }

            $childrenFks = $this->getChildrenRelationshipForeignKeys($mainTable);

            foreach ($childrenFks as $fk) {

            }

            $childrenFks = $this->getChildrenRelationshipForeignKeys($mainTable);

            foreach ($childrenFks as $fk) {

                $joinSql .= sprintf(' LEFT JOIN %s ON (%s.%s = %s.%s)',

                    $this->connection->quoteIdentifier($fk->getLocalTableName()),

                    $this->connection->quoteIdentifier($fk->getForeignTableName()),

                    $this->connection->quoteIdentifier($fk->getForeignColumns()[0]),

                    $this->connection->quoteIdentifier($fk->getLocalTableName()),

                    $this->connection->quoteIdentifier($fk->getLocalColumns()[0])

                );

            }

            $sql = 'SELECT '.implode(', ', $columnsList).' FROM ('.$sql.') AS '.$mainTable.' '.$joinSql;

        }