Inheritance diagram for Zend_Db_Select:

Public Member Functions
	__construct (Zend_Db_Adapter_Abstract $adapter)

	getBind ()

	bind ($bind)

	distinct ($flag=true)

	from ($name, $cols=' *', $schema=null)

	columns ($cols=' *', $correlationName=null)

	union ($select=array(), $type=self::SQL_UNION)

	join ($name, $cond, $cols=self::SQL_WILDCARD, $schema=null)

	joinInner ($name, $cond, $cols=self::SQL_WILDCARD, $schema=null)

	joinLeft ($name, $cond, $cols=self::SQL_WILDCARD, $schema=null)

	joinRight ($name, $cond, $cols=self::SQL_WILDCARD, $schema=null)

	joinFull ($name, $cond, $cols=self::SQL_WILDCARD, $schema=null)

	joinCross ($name, $cols=self::SQL_WILDCARD, $schema=null)

	joinNatural ($name, $cols=self::SQL_WILDCARD, $schema=null)

	where ($cond, $value=null, $type=null)

	orWhere ($cond, $value=null, $type=null)

	group ($spec)

	having ($cond, $value=null, $type=null)

	orHaving ($cond, $value=null, $type=null)

	order ($spec)

	limit ($count=null, $offset=null)

	limitPage ($page, $rowCount)

	forUpdate ($flag=true)

	getPart ($part)

	query ($fetchMode=null, $bind=array())

	assemble ()

	reset ($part=null)

	getAdapter ()

	_joinUsing ($type, $name, $cond, $cols=' *', $schema=null)

	__call ($method, array $args)

	__toString ()

Data Fields
const	DISTINCT = 'distinct'

const	COLUMNS = 'columns'

const	FROM = 'from'

const	UNION = 'union'

const	WHERE = 'where'

const	GROUP = 'group'

const	HAVING = 'having'

const	ORDER = 'order'

const	LIMIT_COUNT = 'limitcount'

const	LIMIT_OFFSET = 'limitoffset'

const	FOR_UPDATE = 'forupdate'

const	INNER_JOIN = 'inner join'

const	LEFT_JOIN = 'left join'

const	RIGHT_JOIN = 'right join'

const	FULL_JOIN = 'full join'

const	CROSS_JOIN = 'cross join'

const	NATURAL_JOIN = 'natural join'

const	SQL_WILDCARD = '*'

const	SQL_SELECT = 'SELECT'

const	SQL_UNION = 'UNION'

const	SQL_UNION_ALL = 'UNION ALL'

const	SQL_FROM = 'FROM'

const	SQL_WHERE = 'WHERE'

const	SQL_DISTINCT = 'DISTINCT'

const	SQL_GROUP_BY = 'GROUP BY'

const	SQL_ORDER_BY = 'ORDER BY'

const	SQL_HAVING = 'HAVING'

const	SQL_FOR_UPDATE = 'FOR UPDATE'

const	SQL_AND = 'AND'

const	SQL_AS = 'AS'

const	SQL_OR = 'OR'

const	SQL_ON = 'ON'

const	SQL_ASC = 'ASC'

const	SQL_DESC = 'DESC'

const	REGEX_COLUMN_EXPR = '/^([\w]\s$([^\($]\|(?1))*\))$/'

const	REGEX_COLUMN_EXPR_ORDER = '/^([\w]+\s$([^\($]\|(?1))\))$/'

const	REGEX_COLUMN_EXPR_GROUP = '/^([\w]+\s$([^\($]\|(?1))\))$/'

const	REGEX_SQL_COMMENTS

Protected Member Functions
	_join ($type, $name, $cond, $cols, $schema=null)

	_tableCols ($correlationName, $cols, $afterCorrelationName=null)

	_where ($condition, $value=null, $type=null, $bool=true)

	_getDummyTable ()

	_getQuotedSchema ($schema=null)

	_getQuotedTable ($tableName, $correlationName=null)

	_renderDistinct ($sql)

	_renderColumns ($sql)

	_renderFrom ($sql)

	_renderUnion ($sql)

	_renderWhere ($sql)

	_renderGroup ($sql)

	_renderHaving ($sql)

	_renderOrder ($sql)

	_renderLimitoffset ($sql)

	_renderForupdate ($sql)

Protected Attributes
	$_bind = array()

	$_adapter

	$_parts = array()

	$_tableCols = array()

Static Protected Attributes
static	$_partsInit

static	$_joinTypes

static	$_unionTypes

Detailed Description

Definition at line 44 of file Select.php.

Constructor & Destructor Documentation

◆ __construct()

__construct ( Zend_Db_Adapter_Abstract $adapter )

Class constructor

Parameters

Zend_Db_Adapter_Abstract $adapter

Definition at line 184 of file Select.php.

     {
         $this->_adapter = $adapter;
         $this->_parts = self::$_partsInit;
     }

Member Function Documentation

◆ __call()

__call	(		$method,
		array	$args
	)

Turn magic function calls into non-magic function calls for joinUsing syntax

Parameters

string	$method
array	$args	OPTIONAL Zend_Db_Table_Select query modifier

Returns: Zend_Db_Select

Exceptions

Zend_Db_Select_Exception If an invalid method is called.

Recognize methods for Has-Many cases: findParent<Class>() findParent<Class>By<Rule>() Use the non-greedy pattern repeat modifier e.g. \w+?

Definition at line 1333 of file Select.php.

     {
         $matches = array();
 
         if (preg_match('/^join([a-zA-Z]*?)Using$/', $method, $matches)) {
             $type = strtolower($matches[1]);
             if ($type) {
                 $type .= ' join';
                 if (!in_array($type, self::$_joinTypes)) {
                     #require_once 'Zend/Db/Select/Exception.php';
                     throw new Zend_Db_Select_Exception("Unrecognized method '$method()'");
                 }
                 if (in_array($type, array(self::CROSS_JOIN, self::NATURAL_JOIN))) {
                     #require_once 'Zend/Db/Select/Exception.php';
                     throw new Zend_Db_Select_Exception("Cannot perform a joinUsing with method '$method()'");
                 }
             } else {
                 $type = self::INNER_JOIN;
             }
             array_unshift($args, $type);
             return call_user_func_array(array($this, '_joinUsing'), $args);
         }
 
         #require_once 'Zend/Db/Select/Exception.php';
         throw new Zend_Db_Select_Exception("Unrecognized method '$method()'");
     }

◆ __toString()

__toString ( )

Implements magic method.

Returns: string This object as a SELECT string.

Definition at line 1371 of file Select.php.

     {
         try {
             $sql = $this->assemble();
         } catch (Exception $e) {
             trigger_error($e->getMessage(), E_USER_WARNING);
             $sql = '';
         }
         return (string)$sql;
     }

◆ _getDummyTable()

_getDummyTable ( )

protected

Returns: array

Definition at line 1049 of file Select.php.

     {
         return array();
     }

◆ _getQuotedSchema()

_getQuotedSchema ( $schema = null )

protected

Return a quoted schema name

Parameters

string $schema The schema name OPTIONAL

Returns: string|null

Definition at line 1060 of file Select.php.

     {
         if ($schema === null) {
             return null;
         }
         return $this->_adapter->quoteIdentifier($schema, true) . '.';
     }

◆ _getQuotedTable()

_getQuotedTable	(	$tableName,
		$correlationName = `null`
	)

protected

Return a quoted table name

Parameters

string	$tableName	The table name
string	$correlationName	The correlation name OPTIONAL

Returns: string

Definition at line 1075 of file Select.php.

     {
         return $this->_adapter->quoteTableAs($tableName, $correlationName, true);
     }

◆ _join()

_join	(	$type,
		$name,
		$cond,
		$cols,
		$schema = `null`
	)

protected

Populate the $_parts 'join' key

Does the dirty work of populating the join key.

The $name and $cols parameters follow the same logic as described in the from() method.

Parameters

null \| string	$type	Type of join; inner, left, and null are currently supported
array \| string \| Zend_Db_Expr	$name	Table name
string	$cond	Join on this condition
array \| string	$cols	The columns to select from the joined table
string	$schema	The database name to specify, if any.

Returns: Zend_Db_Select This Zend_Db_Select object

Exceptions

Zend_Db_Select_Exception

See also: Zend_Db_Select_Exception; Zend_Db_Select_Exception

Definition at line 779 of file Select.php.

     {
         if (!in_array($type, self::$_joinTypes) && $type != self::FROM) {
             #require_once 'Zend/Db/Select/Exception.php';
             throw new Zend_Db_Select_Exception("Invalid join type '$type'");
         }
 
         if (count($this->_parts[self::UNION])) {
             #require_once 'Zend/Db/Select/Exception.php';
             throw new Zend_Db_Select_Exception("Invalid use of table with " . self::SQL_UNION);
         }
 
         if (empty($name)) {
             $correlationName = $tableName = '';
         } elseif (is_array($name)) {
             // Must be array($correlationName => $tableName) or array($ident, ...)
             foreach ($name as $_correlationName => $_tableName) {
                 if (is_string($_correlationName)) {
                     // We assume the key is the correlation name and value is the table name
                     $tableName = $_tableName;
                     $correlationName = $_correlationName;
                 } else {
                     // We assume just an array of identifiers, with no correlation name
                     $tableName = $_tableName;
                     $correlationName = $this->_uniqueCorrelation($tableName);
                 }
                 break;
             }
         } elseif ($name instanceof Zend_Db_Expr|| $name instanceof Zend_Db_Select) {
             $tableName = $name;
             $correlationName = $this->_uniqueCorrelation('t');
         } elseif (preg_match('/^(.+)\s+AS\s+(.+)$/i', $name, $m)) {
             $tableName = $m[1];
             $correlationName = $m[2];
         } else {
             $tableName = $name;
             $correlationName = $this->_uniqueCorrelation($tableName);
         }
 
         // Schema from table name overrides schema argument
         if (!is_object($tableName) && false !== strpos($tableName, '.')) {
             list($schema, $tableName) = explode('.', $tableName);
         }
 
         $lastFromCorrelationName = null;
         if (!empty($correlationName)) {
             if (array_key_exists($correlationName, $this->_parts[self::FROM])) {
                 #require_once 'Zend/Db/Select/Exception.php';
                 throw new Zend_Db_Select_Exception("You cannot define a correlation name '$correlationName' more than once");
             }
 
             if ($type == self::FROM) {
                 // append this from after the last from joinType
                 $tmpFromParts = $this->_parts[self::FROM];
                 $this->_parts[self::FROM] = array();
                 // move all the froms onto the stack
                 while ($tmpFromParts) {
                     $currentCorrelationName = key($tmpFromParts);
                     if ($tmpFromParts[$currentCorrelationName]['joinType'] != self::FROM) {
                         break;
                     }
                     $lastFromCorrelationName = $currentCorrelationName;
                     $this->_parts[self::FROM][$currentCorrelationName] = array_shift($tmpFromParts);
                 }
             } else {
                 $tmpFromParts = array();
             }
             $this->_parts[self::FROM][$correlationName] = array(
                 'joinType'      => $type,
                 'schema'        => $schema,
                 'tableName'     => $tableName,
                 'joinCondition' => $cond
                 );
             while ($tmpFromParts) {
                 $currentCorrelationName = key($tmpFromParts);
                 $this->_parts[self::FROM][$currentCorrelationName] = array_shift($tmpFromParts);
             }
         }
 
         // add to the columns from this joined table
         if ($type == self::FROM && $lastFromCorrelationName == null) {
             $lastFromCorrelationName = true;
         }
         $this->_tableCols($correlationName, $cols, $lastFromCorrelationName);
 
         return $this;
     }

◆ _joinUsing()

_joinUsing	(	$type,
		$name,
		$cond,
		$cols = `'*'`,
		$schema = `null`
	)

Handle JOIN... USING... syntax

This is functionality identical to the existing JOIN methods, however the join condition can be passed as a single column name. This method then completes the ON condition by using the same field for the FROM table and the JOIN table.

$select = $db->select()->from('table1') ->joinUsing('table2', 'column1');

// SELECT * FROM table1 JOIN table2 ON table1.column1 = table2.column2

These joins are called by the developer simply by adding 'Using' to the method name. E.g.

joinUsing
joinInnerUsing
joinFullUsing
joinRightUsing
joinLeftUsing

Returns: Zend_Db_Select This Zend_Db_Select object.

Definition at line 898 of file Select.php.

     {
         if (empty($this->_parts[self::FROM])) {
             #require_once 'Zend/Db/Select/Exception.php';
             throw new Zend_Db_Select_Exception("You can only perform a joinUsing after specifying a FROM table");
         }
 
         $join  = $this->_adapter->quoteIdentifier(key($this->_parts[self::FROM]), true);
         $from  = $this->_adapter->quoteIdentifier($this->_uniqueCorrelation($name), true);
 
         $joinCond = array();
         foreach ((array)$cond as $fieldName) {
             $cond1 = $from . '.' . $fieldName;
             $cond2 = $join . '.' . $fieldName;
             $joinCond[]  = $cond1 . ' = ' . $cond2;
         }
         $cond = implode(' '.self::SQL_AND.' ', $joinCond);
 
         return $this->_join($type, $name, $cond, $cols, $schema);
     }

◆ _renderColumns()

_renderColumns ( $sql )

protected

Render DISTINCT clause

Parameters

string $sql SQL query

Returns: string|null

Definition at line 1101 of file Select.php.

     {
         if (!count($this->_parts[self::COLUMNS])) {
             return null;
         }
 
         $columns = array();
         foreach ($this->_parts[self::COLUMNS] as $columnEntry) {
             list($correlationName, $column, $alias) = $columnEntry;
             if ($column instanceof Zend_Db_Expr) {
                 $columns[] = $this->_adapter->quoteColumnAs($column, $alias, true);
             } else {
                 if ($column == self::SQL_WILDCARD) {
                     $column = new Zend_Db_Expr(self::SQL_WILDCARD);
                     $alias = null;
                 }
                 if (empty($correlationName)) {
                     $columns[] = $this->_adapter->quoteColumnAs($column, $alias, true);
                 } else {
                     $columns[] = $this->_adapter->quoteColumnAs(array($correlationName, $column), $alias, true);
                 }
             }
         }
 
         return $sql . ' ' . implode(', ', $columns);
     }

◆ _renderDistinct()

_renderDistinct ( $sql )

protected

Render DISTINCT clause

Parameters

string $sql SQL query

Returns: string

Definition at line 1086 of file Select.php.

     {
         if ($this->_parts[self::DISTINCT]) {
             $sql .= ' ' . self::SQL_DISTINCT;
         }
 
         return $sql;
     }

◆ _renderForupdate()

_renderForupdate ( $sql )

protected

Render FOR UPDATE clause

Parameters

string $sql SQL query

Returns: string

Definition at line 1315 of file Select.php.

     {
         if ($this->_parts[self::FOR_UPDATE]) {
             $sql .= ' ' . self::SQL_FOR_UPDATE;
         }
 
         return $sql;
     }

◆ _renderFrom()

_renderFrom ( $sql )

protected

Render FROM clause

Parameters

string $sql SQL query

Returns: string

Definition at line 1134 of file Select.php.

     {
         /*
          * If no table specified, use RDBMS-dependent solution
          * for table-less query.  e.g. DUAL in Oracle.
          */
         if (empty($this->_parts[self::FROM])) {
             $this->_parts[self::FROM] = $this->_getDummyTable();
         }
 
         $from = array();
 
         foreach ($this->_parts[self::FROM] as $correlationName => $table) {
             $tmp = '';
 
             $joinType = ($table['joinType'] == self::FROM) ? self::INNER_JOIN : $table['joinType'];
 
             // Add join clause (if applicable)
             if (! empty($from)) {
                 $tmp .= ' ' . strtoupper($joinType) . ' ';
             }
 
             $tmp .= $this->_getQuotedSchema($table['schema']);
             $tmp .= $this->_getQuotedTable($table['tableName'], $correlationName);
 
             // Add join conditions (if applicable)
             if (!empty($from) && ! empty($table['joinCondition'])) {
                 $tmp .= ' ' . self::SQL_ON . ' ' . $table['joinCondition'];
             }
 
             // Add the table name and condition add to the list
             $from[] = $tmp;
         }
 
         // Add the list of all joins
         if (!empty($from)) {
             $sql .= ' ' . self::SQL_FROM . ' ' . implode("\n", $from);
         }
 
         return $sql;
     }

◆ _renderGroup()

_renderGroup ( $sql )

protected

Render GROUP clause

Parameters

string $sql SQL query

Returns: string

Definition at line 1222 of file Select.php.

     {
         if ($this->_parts[self::FROM] && $this->_parts[self::GROUP]) {
             $group = array();
             foreach ($this->_parts[self::GROUP] as $term) {
                 $group[] = $this->_adapter->quoteIdentifier($term, true);
             }
             $sql .= ' ' . self::SQL_GROUP_BY . ' ' . implode(",\n\t", $group);
         }
 
         return $sql;
     }

◆ _renderHaving()

_renderHaving ( $sql )

protected

Render HAVING clause

Parameters

string $sql SQL query

Returns: string

Definition at line 1241 of file Select.php.

     {
         if ($this->_parts[self::FROM] && $this->_parts[self::HAVING]) {
             $sql .= ' ' . self::SQL_HAVING . ' ' . implode(' ', $this->_parts[self::HAVING]);
         }
 
         return $sql;
     }

◆ _renderLimitoffset()

_renderLimitoffset ( $sql )

protected

Render LIMIT OFFSET clause

Parameters

string $sql SQL query

Returns: string

Definition at line 1285 of file Select.php.

     {
         $count = 0;
         $offset = 0;
 
         if (!empty($this->_parts[self::LIMIT_OFFSET])) {
             $offset = (int) $this->_parts[self::LIMIT_OFFSET];
             $count = PHP_INT_MAX;
         }
 
         if (!empty($this->_parts[self::LIMIT_COUNT])) {
             $count = (int) $this->_parts[self::LIMIT_COUNT];
         }
 
         /*
          * Add limits clause
          */
         if ($count > 0) {
             $sql = trim($this->_adapter->limit($sql, $count, $offset));
         }
 
         return $sql;
     }

◆ _renderOrder()

_renderOrder ( $sql )

protected

Render ORDER clause

Parameters

string $sql SQL query

Returns: string

Definition at line 1256 of file Select.php.

     {
         if ($this->_parts[self::ORDER]) {
             $order = array();
             foreach ($this->_parts[self::ORDER] as $term) {
                 if (is_array($term)) {
                     if(is_numeric($term[0]) && strval(intval($term[0])) == $term[0]) {
                         $order[] = (int)trim($term[0]) . ' ' . $term[1];
                     } else {
                         $order[] = $this->_adapter->quoteIdentifier($term[0], true) . ' ' . $term[1];
                     }
                 } elseif (is_numeric($term) && strval(intval($term)) == $term) {
                     $order[] = (int)trim($term);
                 } else {
                     $order[] = $this->_adapter->quoteIdentifier($term, true);
                 }
             }
             $sql .= ' ' . self::SQL_ORDER_BY . ' ' . implode(', ', $order);
         }
 
         return $sql;
     }

◆ _renderUnion()

_renderUnion ( $sql )

protected

Render UNION query

Parameters

string $sql SQL query

Returns: string

Definition at line 1182 of file Select.php.

     {
         if ($this->_parts[self::UNION]) {
             $parts = count($this->_parts[self::UNION]);
             foreach ($this->_parts[self::UNION] as $cnt => $union) {
                 list($target, $type) = $union;
                 if ($target instanceof Zend_Db_Select) {
                     $target = $target->assemble();
                 }
                 $sql .= $target;
                 if ($cnt < $parts - 1) {
                     $sql .= ' ' . $type . ' ';
                 }
             }
         }
 
         return $sql;
     }

◆ _renderWhere()

_renderWhere ( $sql )

protected

Render WHERE clause

Parameters

string $sql SQL query

Returns: string

Definition at line 1207 of file Select.php.

     {
         if ($this->_parts[self::FROM] && $this->_parts[self::WHERE]) {
             $sql .= ' ' . self::SQL_WHERE . ' ' .  implode(' ', $this->_parts[self::WHERE]);
         }
 
         return $sql;
     }

◆ _tableCols()

_tableCols	(	$correlationName,
		$cols,
		$afterCorrelationName = `null`
	)

protected

Adds to the internal table-to-column mapping array.

Parameters

string	$tbl	The table/join the columns come from.
array \| string	$cols	The list of columns; preferably as an array, but possibly as a string containing one column.
	bool\|string	True if it should be prepended, a correlation name if it should be inserted

Returns: void

Definition at line 950 of file Select.php.

     {
         if (!is_array($cols)) {
             $cols = array($cols);
         }
 
         if ($correlationName == null) {
             $correlationName = '';
         }
 
         $columnValues = array();
 
         foreach (array_filter($cols) as $alias => $col) {
             $currentCorrelationName = $correlationName;
             if (is_string($col)) {
                 // Check for a column matching "<column> AS <alias>" and extract the alias name
                 $col = trim(str_replace("\n", ' ', $col));
                 if (preg_match('/^(.+)\s+' . self::SQL_AS . '\s+(.+)$/i', $col, $m)) {
                     $col = $m[1];
                     $alias = $m[2];
                 }
                 // Check for columns that look like functions and convert to Zend_Db_Expr
                 if (preg_match(self::REGEX_COLUMN_EXPR, $col)) {
                     $col = new Zend_Db_Expr($col);
                 } elseif (preg_match('/(.+)\.(.+)/', $col, $m)) {
                     $currentCorrelationName = $m[1];
                     $col = $m[2];
                 }
             }
             $columnValues[] = array($currentCorrelationName, $col, is_string($alias) ? $alias : null);
         }
 
         if ($columnValues) {
 
             // should we attempt to prepend or insert these values?
             if ($afterCorrelationName === true || is_string($afterCorrelationName)) {
                 $tmpColumns = $this->_parts[self::COLUMNS];
                 $this->_parts[self::COLUMNS] = array();
             } else {
                 $tmpColumns = array();
             }
 
             // find the correlation name to insert after
             if (is_string($afterCorrelationName)) {
                 while ($tmpColumns) {
                     $this->_parts[self::COLUMNS][] = $currentColumn = array_shift($tmpColumns);
                     if ($currentColumn[0] == $afterCorrelationName) {
                         break;
                     }
                 }
             }
 
             // apply current values to current stack
             foreach ($columnValues as $columnValue) {
                 array_push($this->_parts[self::COLUMNS], $columnValue);
             }
 
             // finish ensuring that all previous values are applied (if they exist)
             while ($tmpColumns) {
                 array_push($this->_parts[self::COLUMNS], array_shift($tmpColumns));
             }
         }
     }

◆ _where()

_where	(	$condition,
		$value = `null`,
		$type = `null`,
		$bool = `true`
	)

protected

Internal function for creating the where clause

Parameters

string	$condition
mixed	$value	optional
string	$type	optional
boolean	$bool	true = AND, false = OR

Returns: string clause

Definition at line 1023 of file Select.php.

     {
         if (count($this->_parts[self::UNION])) {
             #require_once 'Zend/Db/Select/Exception.php';
             throw new Zend_Db_Select_Exception("Invalid use of where clause with " . self::SQL_UNION);
         }
 
         if ($value !== null) {
             $condition = $this->_adapter->quoteInto($condition, $value, $type);
         }
 
         $cond = "";
         if ($this->_parts[self::WHERE]) {
             if ($bool === true) {
                 $cond = self::SQL_AND . ' ';
             } else {
                 $cond = self::SQL_OR . ' ';
             }
         }
 
         return $cond . "($condition)";
     }

◆ assemble()

assemble ( )

Converts this object to an SQL SELECT string.

Returns: string|null This object as a SELECT string. (or null if a string cannot be produced.)

Definition at line 724 of file Select.php.

     {
         $sql = self::SQL_SELECT;
         foreach (array_keys(self::$_partsInit) as $part) {
             $method = '_render' . ucfirst($part);
             if (method_exists($this, $method)) {
                 $sql = $this->$method($sql);
             }
         }
         return $sql;
     }

◆ bind()

bind ( $bind )

Set bind variables

Parameters

mixed $bind

Returns: Zend_Db_Select

Definition at line 206 of file Select.php.

     {
         $this->_bind = $bind;
 
         return $this;
     }

◆ columns()

columns	(	$cols = `'*'`,
		$correlationName = `null`
	)

Specifies the columns used in the FROM clause.

The parameter can be a single string or Zend_Db_Expr object, or else an array of strings or Zend_Db_Expr objects.

Parameters

array \| string \| Zend_Db_Expr	$cols	The columns to select from this table.
string	$correlationName	Correlation name of target table. OPTIONAL

Returns: Zend_Db_Select This Zend_Db_Select object.

See also: Zend_Db_Select_Exception

Definition at line 264 of file Select.php.

     {
         if ($correlationName === null && count($this->_parts[self::FROM])) {
             $correlationNameKeys = array_keys($this->_parts[self::FROM]);
             $correlationName = current($correlationNameKeys);
         }
 
         if (!array_key_exists($correlationName, $this->_parts[self::FROM])) {
             #require_once 'Zend/Db/Select/Exception.php';
             throw new Zend_Db_Select_Exception("No table has been specified for the FROM clause");
         }
 
         $this->_tableCols($correlationName, $cols);
 
         return $this;
     }

◆ distinct()

distinct ( $flag = true )

Makes the query SELECT DISTINCT.

Parameters

bool $flag Whether or not the SELECT is DISTINCT (default true).

Returns: Zend_Db_Select This Zend_Db_Select object.

Definition at line 219 of file Select.php.

     {
         $this->_parts[self::DISTINCT] = (bool) $flag;
         return $this;
     }

◆ forUpdate()

forUpdate ( $flag = true )

Makes the query SELECT FOR UPDATE.

Parameters

bool $flag Whether or not the SELECT is FOR UPDATE (default true).

Returns: Zend_Db_Select This Zend_Db_Select object.

Definition at line 675 of file Select.php.

     {
         $this->_parts[self::FOR_UPDATE] = (bool) $flag;
         return $this;
     }

◆ from()

from	(	$name,
		$cols = `'*'`,
		$schema = `null`
	)

Adds a FROM table and optional columns to the query.

The first parameter $name can be a simple string, in which case the correlation name is generated automatically. If you want to specify the correlation name, the first parameter must be an associative array in which the key is the correlation name, and the value is the physical table name. For example, array('alias' => 'table'). The correlation name is prepended to all columns fetched for this table.

The second parameter can be a single string or Zend_Db_Expr object, or else an array of strings or Zend_Db_Expr objects.

The first parameter can be null or an empty string, in which case no correlation name is generated or prepended to the columns named in the second parameter.

Parameters

array \| string \| Zend_Db_Expr	$name	The table name or an associative array relating correlation name to table name.
array \| string \| Zend_Db_Expr	$cols	The columns to select from this table.
string	$schema	The schema name to specify, if any.

Returns: Zend_Db_Select This Zend_Db_Select object.

Definition at line 249 of file Select.php.

     {
         return $this->_join(self::FROM, $name, null, $cols, $schema);
     }

◆ getAdapter()

getAdapter ( )

Gets the Zend_Db_Adapter_Abstract for this particular Zend_Db_Select object.

Returns: Zend_Db_Adapter_Abstract

Definition at line 758 of file Select.php.

     {
         return $this->_adapter;
     }

◆ getBind()

getBind ( )

Get bind variables

Returns: array

Definition at line 195 of file Select.php.

     {
         return $this->_bind;
     }

◆ getPart()

getPart ( $part )

Get part of the structured information for the current query.

Parameters

string $part

Returns: mixed

Exceptions

Zend_Db_Select_Exception

Definition at line 688 of file Select.php.

     {
         $part = strtolower($part);
         if (!array_key_exists($part, $this->_parts)) {
             #require_once 'Zend/Db/Select/Exception.php';
             throw new Zend_Db_Select_Exception("Invalid Select part '$part'");
         }
         return $this->_parts[$part];
     }

◆ group()

group ( $spec )

Adds grouping to the query.

Parameters

array | string $spec The column(s) to group by.

Returns: Zend_Db_Select This Zend_Db_Select object.

Definition at line 526 of file Select.php.

     {
         if (!is_array($spec)) {
             $spec = array($spec);
         }
 
         foreach ($spec as $val) {
             // Remove comments from SQL statement
             $noComments = preg_replace(self::REGEX_SQL_COMMENTS, '$1', (string) $val);
             if (preg_match(self::REGEX_COLUMN_EXPR_GROUP, $noComments)) {
                 $val = new Zend_Db_Expr($val);
             }
             $this->_parts[self::GROUP][] = $val;
         }
 
         return $this;
     }

◆ having()

having	(	$cond,
		$value = `null`,
		$type = `null`
	)

Adds a HAVING condition to the query by AND.

If a value is passed as the second param, it will be quoted and replaced into the condition wherever a question-mark appears. See where() for an example

Parameters

string	$cond	The HAVING condition.
mixed	$value	OPTIONAL The value to quote into the condition.
int	$type	OPTIONAL The type of the given value

Returns: Zend_Db_Select This Zend_Db_Select object.

Definition at line 556 of file Select.php.

     {
         if ($value !== null) {
             $cond = $this->_adapter->quoteInto($cond, $value, $type);
         }
 
         if ($this->_parts[self::HAVING]) {
             $this->_parts[self::HAVING][] = self::SQL_AND . " ($cond)";
         } else {
             $this->_parts[self::HAVING][] = "($cond)";
         }
 
         return $this;
     }

◆ join()

join	(	$name,
		$cond,
		$cols = `self::SQL_WILDCARD`,
		$schema = `null`
	)

Adds a JOIN table and columns to the query.

The $name and $cols parameters follow the same logic as described in the from() method.

Parameters

array \| string \| Zend_Db_Expr	$name	The table name.
string	$cond	Join on this condition.
array \| string	$cols	The columns to select from the joined table.
string	$schema	The database name to specify, if any.

Returns: Zend_Db_Select This Zend_Db_Select object.

Definition at line 334 of file Select.php.

     {
         return $this->joinInner($name, $cond, $cols, $schema);
     }

◆ joinCross()

joinCross	(	$name,
		$cols = `self::SQL_WILDCARD`,
		$schema = `null`
	)

Add a CROSS JOIN table and colums to the query. A cross join is a cartesian product; there is no join condition.

The $name and $cols parameters follow the same logic as described in the from() method.

Parameters

array \| string \| Zend_Db_Expr	$name	The table name.
array \| string	$cols	The columns to select from the joined table.
string	$schema	The database name to specify, if any.

Returns: Zend_Db_Select This Zend_Db_Select object.

Definition at line 437 of file Select.php.

     {
         return $this->_join(self::CROSS_JOIN, $name, null, $cols, $schema);
     }

◆ joinFull()

joinFull	(	$name,
		$cond,
		$cols = `self::SQL_WILDCARD`,
		$schema = `null`
	)

Add a FULL OUTER JOIN table and colums to the query. A full outer join is like combining a left outer join and a right outer join. All rows from both tables are included, paired with each other on the same row of the result set if they satisfy the join condition, and otherwise paired with NULLs in place of columns from the other table.

The $name and $cols parameters follow the same logic as described in the from() method.

Parameters

array \| string \| Zend_Db_Expr	$name	The table name.
string	$cond	Join on this condition.
array \| string	$cols	The columns to select from the joined table.
string	$schema	The database name to specify, if any.

Returns: Zend_Db_Select This Zend_Db_Select object.

Definition at line 420 of file Select.php.

     {
         return $this->_join(self::FULL_JOIN, $name, $cond, $cols, $schema);
     }

◆ joinInner()

joinInner	(	$name,
		$cond,
		$cols = `self::SQL_WILDCARD`,
		$schema = `null`
	)

Add an INNER JOIN table and colums to the query Rows in both tables are matched according to the expression in the $cond argument. The result set is comprised of all cases where rows from the left table match rows from the right table.

The $name and $cols parameters follow the same logic as described in the from() method.

Parameters

array \| string \| Zend_Db_Expr	$name	The table name.
string	$cond	Join on this condition.
array \| string	$cols	The columns to select from the joined table.
string	$schema	The database name to specify, if any.

Returns: Zend_Db_Select This Zend_Db_Select object.

Definition at line 355 of file Select.php.

     {
         return $this->_join(self::INNER_JOIN, $name, $cond, $cols, $schema);
     }

◆ joinLeft()

joinLeft	(	$name,
		$cond,
		$cols = `self::SQL_WILDCARD`,
		$schema = `null`
	)

Add a LEFT OUTER JOIN table and colums to the query All rows from the left operand table are included, matching rows from the right operand table included, and the columns from the right operand table are filled with NULLs if no row exists matching the left table.

The $name and $cols parameters follow the same logic as described in the from() method.

Parameters

array \| string \| Zend_Db_Expr	$name	The table name.
string	$cond	Join on this condition.
array \| string	$cols	The columns to select from the joined table.
string	$schema	The database name to specify, if any.

Returns: Zend_Db_Select This Zend_Db_Select object.

Definition at line 376 of file Select.php.

     {
         return $this->_join(self::LEFT_JOIN, $name, $cond, $cols, $schema);
     }

◆ joinNatural()

joinNatural	(	$name,
		$cols = `self::SQL_WILDCARD`,
		$schema = `null`
	)

Add a NATURAL JOIN table and colums to the query. A natural join assumes an equi-join across any column(s) that appear with the same name in both tables. Only natural inner joins are supported by this API, even though SQL permits natural outer joins as well.

The $name and $cols parameters follow the same logic as described in the from() method.

Parameters

array \| string \| Zend_Db_Expr	$name	The table name.
array \| string	$cols	The columns to select from the joined table.
string	$schema	The database name to specify, if any.

Returns: Zend_Db_Select This Zend_Db_Select object.

Definition at line 457 of file Select.php.

     {
         return $this->_join(self::NATURAL_JOIN, $name, null, $cols, $schema);
     }

◆ joinRight()

joinRight	(	$name,
		$cond,
		$cols = `self::SQL_WILDCARD`,
		$schema = `null`
	)

Add a RIGHT OUTER JOIN table and colums to the query. Right outer join is the complement of left outer join. All rows from the right operand table are included, matching rows from the left operand table included, and the columns from the left operand table are filled with NULLs if no row exists matching the right table.

The $name and $cols parameters follow the same logic as described in the from() method.

Parameters

array \| string \| Zend_Db_Expr	$name	The table name.
string	$cond	Join on this condition.
array \| string	$cols	The columns to select from the joined table.
string	$schema	The database name to specify, if any.

Returns: Zend_Db_Select This Zend_Db_Select object.

Definition at line 398 of file Select.php.

     {
         return $this->_join(self::RIGHT_JOIN, $name, $cond, $cols, $schema);
     }

◆ limit()

limit	(	$count = `null`,
		$offset = `null`
	)

Sets a limit count and offset to the query.

Parameters

int	$count	OPTIONAL The number of rows to return.
int	$offset	OPTIONAL Start returning after this many rows.

Returns: Zend_Db_Select This Zend_Db_Select object.

Definition at line 646 of file Select.php.

     {
         $this->_parts[self::LIMIT_COUNT]  = (int) $count;
         $this->_parts[self::LIMIT_OFFSET] = (int) $offset;
         return $this;
     }

◆ limitPage()

limitPage	(	$page,
		$rowCount
	)

Sets the limit and count by page number.

Parameters

int	$page	Limit results to this page number.
int	$rowCount	Use this many rows per page.

Returns: Zend_Db_Select This Zend_Db_Select object.

Definition at line 660 of file Select.php.

     {
         $page     = ($page > 0)     ? $page     : 1;
         $rowCount = ($rowCount > 0) ? $rowCount : 1;
         $this->_parts[self::LIMIT_COUNT]  = (int) $rowCount;
         $this->_parts[self::LIMIT_OFFSET] = (int) $rowCount * ($page - 1);
         return $this;
     }

◆ order()

order ( $spec )

Adds a row order to the query.

Parameters

mixed $spec The column(s) and direction to order by.

Returns: Zend_Db_Select This Zend_Db_Select object.

Definition at line 604 of file Select.php.

     {
         if (!is_array($spec)) {
             $spec = array($spec);
         }
 
         // force 'ASC' or 'DESC' on each order spec, default is ASC.
         foreach ($spec as $val) {
             if ($val instanceof Zend_Db_Expr) {
                 $expr = $val->__toString();
                 if (empty($expr)) {
                     continue;
                 }
                 $this->_parts[self::ORDER][] = $val;
             } else {
                 if (empty($val)) {
                     continue;
                 }
                 $direction = self::SQL_ASC;
                 if (preg_match('/(.*\W)(' . self::SQL_ASC . '|' . self::SQL_DESC . ')\b/si', $val, $matches)) {
                     $val = trim($matches[1]);
                     $direction = $matches[2];
                 }
                 // Remove comments from SQL statement
                 $noComments = preg_replace(self::REGEX_SQL_COMMENTS, '$1', (string) $val);
                 if (preg_match(self::REGEX_COLUMN_EXPR_ORDER, $noComments)) {
                     $val = new Zend_Db_Expr($val);
                 }
                 $this->_parts[self::ORDER][] = array($val, $direction);
             }
         }
 
         return $this;
     }

◆ orHaving()

orHaving	(	$cond,
		$value = `null`,
		$type = `null`
	)

Adds a HAVING condition to the query by OR.

Otherwise identical to orHaving().

Parameters

string	$cond	The HAVING condition.
mixed	$value	OPTIONAL The value to quote into the condition.
int	$type	OPTIONAL The type of the given value

Returns: Zend_Db_Select This Zend_Db_Select object.

See also: having()

Definition at line 583 of file Select.php.

     {
         if ($value !== null) {
             $cond = $this->_adapter->quoteInto($cond, $value, $type);
         }
 
         if ($this->_parts[self::HAVING]) {
             $this->_parts[self::HAVING][] = self::SQL_OR . " ($cond)";
         } else {
             $this->_parts[self::HAVING][] = "($cond)";
         }
 
         return $this;
     }

◆ orWhere()

orWhere	(	$cond,
		$value = `null`,
		$type = `null`
	)

Adds a WHERE condition to the query by OR.

Otherwise identical to where().

Parameters

string	$cond	The WHERE condition.
mixed	$value	OPTIONAL The value to quote into the condition.
int	$type	OPTIONAL The type of the given value

Returns: Zend_Db_Select This Zend_Db_Select object.

See also: where()

Definition at line 513 of file Select.php.

     {
         $this->_parts[self::WHERE][] = $this->_where($cond, $value, $type, false);
 
         return $this;
     }

◆ query()

query	(	$fetchMode = `null`,
		$bind = `array()`
	)

Executes the current select object and returns the result

Parameters

integer	$fetchMode	OPTIONAL
mixed	$bind	An array of data to bind to the placeholders.

Returns: PDO_Statement|Zend_Db_Statement

Definition at line 705 of file Select.php.

     {
         if (!empty($bind)) {
             $this->bind($bind);
         }
 
         $stmt = $this->_adapter->query($this);
         if ($fetchMode == null) {
             $fetchMode = $this->_adapter->getFetchMode();
         }
         $stmt->setFetchMode($fetchMode);
         return $stmt;
     }

◆ reset()

reset ( $part = null )

Clear parts of the Select object, or an individual part.

Parameters

string $part OPTIONAL

Returns: Zend_Db_Select

Definition at line 742 of file Select.php.

     {
         if ($part == null) {
             $this->_parts = self::$_partsInit;
         } elseif (array_key_exists($part, self::$_partsInit)) {
             $this->_parts[$part] = self::$_partsInit[$part];
         }
         return $this;
     }

◆ union()

union	(	$select = `array()`,
		$type = `self::SQL_UNION`
	)

Adds a UNION clause to the query.

The first parameter has to be an array of Zend_Db_Select or sql query strings.

$sql1 = $db->select(); $sql2 = "SELECT ..."; $select = $db->select() ->union(array($sql1, $sql2)) ->order("id");

Parameters

array $select Array of select clauses for the union.

Returns: Zend_Db_Select This Zend_Db_Select object.

Definition at line 301 of file Select.php.

     {
         if (!is_array($select)) {
             #require_once 'Zend/Db/Select/Exception.php';
             throw new Zend_Db_Select_Exception(
                 "union() only accepts an array of Zend_Db_Select instances of sql query strings."
             );
         }
 
         if (!in_array($type, self::$_unionTypes)) {
             #require_once 'Zend/Db/Select/Exception.php';
             throw new Zend_Db_Select_Exception("Invalid union type '{$type}'");
         }
 
         foreach ($select as $target) {
             $this->_parts[self::UNION][] = array($target, $type);
         }
 
         return $this;
     }

◆ where()

where	(	$cond,
		$value = `null`,
		$type = `null`
	)

Adds a WHERE condition to the query by AND.

If a value is passed as the second param, it will be quoted and replaced into the condition wherever a question-mark appears. Array values are quoted and comma-separated.

// simplest but non-secure $select->where("id = $id");

// secure (ID is quoted but matched anyway) $select->where('id = ?', $id);

// alternatively, with named binding $select->where('id = :id');

Note that it is more correct to use named bindings in your queries for values other than strings. When you use named bindings, don't forget to pass the values when actually making a query:

$db->fetchAll($select, array('id' => 5));

Parameters

string	$cond	The WHERE condition.
mixed	$value	OPTIONAL The value to quote into the condition.
int	$type	OPTIONAL The type of the given value

Returns: Zend_Db_Select This Zend_Db_Select object.

Definition at line 494 of file Select.php.

     {
         $this->_parts[self::WHERE][] = $this->_where($cond, $value, $type, true);
 
         return $this;
     }

Field Documentation

◆ $_adapter

$_adapter

protected

Definition at line 117 of file Select.php.

◆ $_bind

$_bind = array()

protected

Definition at line 110 of file Select.php.

◆ $_joinTypes

$_joinTypes

staticprotected

Initial value:

= array(
        self::INNER_JOIN,
        self::LEFT_JOIN,
        self::RIGHT_JOIN,
        self::FULL_JOIN,
        self::CROSS_JOIN,
        self::NATURAL_JOIN,
    )

Definition at line 145 of file Select.php.

◆ $_parts

$_parts = array()

protected

Definition at line 170 of file Select.php.

◆ $_partsInit

$_partsInit

staticprotected

Initial value:

= array(
        self::DISTINCT     => false,
        self::COLUMNS      => array(),
        self::UNION        => array(),
        self::FROM         => array(),
        self::WHERE        => array(),
        self::GROUP        => array(),
        self::HAVING       => array(),
        self::ORDER        => array(),
        self::LIMIT_COUNT  => null,
        self::LIMIT_OFFSET => null,
        self::FOR_UPDATE   => false
    )

Definition at line 126 of file Select.php.

◆ $_tableCols

$_tableCols = array()

protected

Definition at line 177 of file Select.php.

◆ $_unionTypes

$_unionTypes

staticprotected

Initial value:

= array(
        self::SQL_UNION,
        self::SQL_UNION_ALL
    )

Definition at line 159 of file Select.php.

◆ COLUMNS

const COLUMNS = 'columns'

Definition at line 48 of file Select.php.

◆ CROSS_JOIN

const CROSS_JOIN = 'cross join'

Definition at line 63 of file Select.php.

◆ DISTINCT

const DISTINCT = 'distinct'

Definition at line 47 of file Select.php.

◆ FOR_UPDATE

const FOR_UPDATE = 'forupdate'

Definition at line 57 of file Select.php.

◆ FROM

const FROM = 'from'

Definition at line 49 of file Select.php.

◆ FULL_JOIN

const FULL_JOIN = 'full join'

Definition at line 62 of file Select.php.

◆ GROUP

const GROUP = 'group'

Definition at line 52 of file Select.php.

◆ HAVING

const HAVING = 'having'

Definition at line 53 of file Select.php.

◆ INNER_JOIN

const INNER_JOIN = 'inner join'

Definition at line 59 of file Select.php.

◆ LEFT_JOIN

const LEFT_JOIN = 'left join'

Definition at line 60 of file Select.php.

◆ LIMIT_COUNT

const LIMIT_COUNT = 'limitcount'

Definition at line 55 of file Select.php.

◆ LIMIT_OFFSET

const LIMIT_OFFSET = 'limitoffset'

Definition at line 56 of file Select.php.

◆ NATURAL_JOIN

const NATURAL_JOIN = 'natural join'

Definition at line 64 of file Select.php.

◆ ORDER

const ORDER = 'order'

Definition at line 54 of file Select.php.

◆ REGEX_COLUMN_EXPR

const REGEX_COLUMN_EXPR = '/^([\w]*\s*$([^\($]|(?1))*\))$/'

Definition at line 84 of file Select.php.

◆ REGEX_COLUMN_EXPR_GROUP

const REGEX_COLUMN_EXPR_GROUP = '/^([\w]+\s*$([^\($]|(?1))*\))$/'

Definition at line 86 of file Select.php.

◆ REGEX_COLUMN_EXPR_ORDER

const REGEX_COLUMN_EXPR_ORDER = '/^([\w]+\s*$([^\($]|(?1))*\))$/'

Definition at line 85 of file Select.php.

◆ REGEX_SQL_COMMENTS

const REGEX_SQL_COMMENTS

Initial value:

= '@
    (([\'"]).*?[^\\\]\2) # $1 : Skip single & double quoted expressions
    |(                   # $3 : Match comments
        (?:\#|--).*?$    # - Single line comments
        |                # - Multi line (nested) comments
         /\*             #   . comment open marker
            (?: [^/*]    #   . non comment-marker characters
                |/(?!\*) #   . ! not a comment open
                |\*(?!/) #   . ! not a comment close
                |(?R)    #   . recursive case
            )*           #   . repeat eventually
        \*\/             #   . comment close marker
    )\s*                 # Trim after comments
    |(?<=;)\s+           # Trim after semi-colon
    @msx'

Definition at line 89 of file Select.php.

◆ RIGHT_JOIN

const RIGHT_JOIN = 'right join'

Definition at line 61 of file Select.php.

◆ SQL_AND

const SQL_AND = 'AND'

Definition at line 77 of file Select.php.

◆ SQL_AS

const SQL_AS = 'AS'

Definition at line 78 of file Select.php.

◆ SQL_ASC

const SQL_ASC = 'ASC'

Definition at line 81 of file Select.php.

◆ SQL_DESC

const SQL_DESC = 'DESC'

Definition at line 82 of file Select.php.

◆ SQL_DISTINCT

const SQL_DISTINCT = 'DISTINCT'

Definition at line 72 of file Select.php.

◆ SQL_FOR_UPDATE

const SQL_FOR_UPDATE = 'FOR UPDATE'

Definition at line 76 of file Select.php.

◆ SQL_FROM

const SQL_FROM = 'FROM'

Definition at line 70 of file Select.php.

◆ SQL_GROUP_BY

const SQL_GROUP_BY = 'GROUP BY'

Definition at line 73 of file Select.php.

◆ SQL_HAVING

const SQL_HAVING = 'HAVING'

Definition at line 75 of file Select.php.

◆ SQL_ON

const SQL_ON = 'ON'

Definition at line 80 of file Select.php.

◆ SQL_OR

const SQL_OR = 'OR'

Definition at line 79 of file Select.php.

◆ SQL_ORDER_BY

const SQL_ORDER_BY = 'ORDER BY'

Definition at line 74 of file Select.php.

◆ SQL_SELECT

const SQL_SELECT = 'SELECT'

Definition at line 67 of file Select.php.

◆ SQL_UNION

const SQL_UNION = 'UNION'

Definition at line 68 of file Select.php.

◆ SQL_UNION_ALL

const SQL_UNION_ALL = 'UNION ALL'

Definition at line 69 of file Select.php.

◆ SQL_WHERE

const SQL_WHERE = 'WHERE'

Definition at line 71 of file Select.php.

◆ SQL_WILDCARD

const SQL_WILDCARD = '*'

Definition at line 66 of file Select.php.

◆ UNION

const UNION = 'union'

Definition at line 50 of file Select.php.

◆ WHERE

const WHERE = 'where'

Definition at line 51 of file Select.php.

The documentation for this class was generated from the following file:

vendor/magento/zendframework1/library/Zend/Db/Select.php

Public Member Functions

Data Fields

Protected Member Functions

Protected Attributes

Static Protected Attributes

Detailed Description

Constructor & Destructor Documentation

◆ __construct()

Member Function Documentation

◆ __call()

◆ __toString()

◆ _getDummyTable()

◆ _getQuotedSchema()

◆ _getQuotedTable()

◆ _join()

◆ _joinUsing()

◆ _renderColumns()

◆ _renderDistinct()

◆ _renderForupdate()

◆ _renderFrom()

◆ _renderGroup()

◆ _renderHaving()

◆ _renderLimitoffset()

◆ _renderOrder()

◆ _renderUnion()

◆ _renderWhere()

◆ _tableCols()

◆ _where()

◆ assemble()

◆ bind()

◆ columns()

◆ distinct()

◆ forUpdate()

◆ from()

◆ getAdapter()

◆ getBind()

◆ getPart()

◆ group()

◆ having()

◆ join()

◆ joinCross()

◆ joinFull()

◆ joinInner()

◆ joinLeft()

◆ joinNatural()

◆ joinRight()

◆ limit()

◆ limitPage()

◆ order()

◆ orHaving()

◆ orWhere()

◆ query()

◆ reset()

◆ union()

◆ where()

Field Documentation

◆ $_adapter

◆ $_bind

◆ $_joinTypes

◆ $_parts

◆ $_partsInit

◆ $_tableCols

◆ $_unionTypes

◆ COLUMNS

◆ CROSS_JOIN

◆ DISTINCT

◆ FOR_UPDATE

◆ FROM

◆ FULL_JOIN

◆ GROUP

◆ HAVING

◆ INNER_JOIN

◆ LEFT_JOIN

◆ LIMIT_COUNT

◆ LIMIT_OFFSET

◆ NATURAL_JOIN

◆ ORDER

◆ REGEX_COLUMN_EXPR

◆ REGEX_COLUMN_EXPR_GROUP

◆ REGEX_COLUMN_EXPR_ORDER