public SelectInterface::__clone() Clone magic method. Select queries have dependent objects that must be deep-cloned. The connection object itself, however, should not be cloned as that would duplicate the connection itself. File core/lib/Drupal/Core/Database/Query/SelectInterface.php, line 634 Class SelectInterface Interface definition for a Select Query object. Namespace Drupal\Core\Database\Query Code public function __clone();

public SelectionInterface::countReferenceableEntities($match = NULL, $match_operator = 'CONTAINS') Counts entities that are referenceable. Return value int The number of referenceable entities. File core/lib/Drupal/Core/Entity/EntityReferenceSelection/SelectionInterface.php, line 33 Class SelectionInterface Interface definition for Entity Reference Selection plugins. Namespace Drupal\Core\Entity\EntityReferenceSelection Code public function countReferenceableEntities($match = NULL, $m

public SelectionInterface::entityQueryAlter(SelectInterface $query) Allows the selection to alter the SelectQuery generated by EntityFieldQuery. Parameters \Drupal\Core\Database\Query\SelectInterface $query: A Select Query object. File core/lib/Drupal/Core/Entity/EntityReferenceSelection/SelectionInterface.php, line 49 Class SelectionInterface Interface definition for Entity Reference Selection plugins. Namespace Drupal\Core\Entity\EntityReferenceSelection Code public function entityQ

public SelectInterface::__toString() Returns a string representation of how the query will be executed in SQL. Return value string The Select Query object expressed as a string. File core/lib/Drupal/Core/Database/Query/SelectInterface.php, line 658 Class SelectInterface Interface definition for a Select Query object. Namespace Drupal\Core\Database\Query Code public function __toString();

public SelectInterface::rightJoin($table, $alias = NULL, $condition = NULL, $arguments = array()) Right Outer Join against another table in the database. Parameters $table: The table against which to join. May be a string or another SelectQuery object. If a query object is passed, it will be used as a subselect. Unless the table name starts with the database / schema name and a dot it will be prefixed. $alias: The alias for the table. In most cases this should be the first letter of the table,

public SelectInterface::range($start = NULL, $length = NULL) Restricts a query to a given range in the result set. If this method is called with no parameters, will remove any range directives that have been set. Parameters $start: The first record from the result set to return. If NULL, removes any range directives that are set. $length: The number of records to return from the result set. Return value \Drupal\Core\Database\Query\SelectInterface The called object. File core/lib/Drupal/Core/D

public SelectInterface::preExecute(SelectInterface $query = NULL) Generic preparation and validation for a SELECT query. Return value TRUE if the validation was successful, FALSE if not. File core/lib/Drupal/Core/Database/Query/SelectInterface.php, line 512 Class SelectInterface Interface definition for a Select Query object. Namespace Drupal\Core\Database\Query Code public function preExecute(SelectInterface $query = NULL);

public SelectInterface::orderBy($field, $direction = 'ASC') Orders the result set by a given field. If called multiple times, the query will order by each specified field in the order this method is called. If the query uses DISTINCT or GROUP BY conditions, fields or expressions that are used for the order must be selected to be compatible with some databases like PostgreSQL. The PostgreSQL driver can handle simple cases automatically but it is suggested to explicitly specify them. Additionally

public SelectInterface::orderRandom() Orders the result set by a random value. This may be stacked with other orderBy() calls. If so, the query will order by each specified field, including this one, in the order called. Although this method may be called multiple times on the same query, doing so is not particularly useful. Note: The method used by most drivers may not scale to very large result sets. If you need to work with extremely large data sets, you may create your own database driver b

public SelectInterface::join($table, $alias = NULL, $condition = NULL, $arguments = array()) Default Join against another table in the database. This method is a convenience method for innerJoin(). Parameters $table: The table against which to join. May be a string or another SelectQuery object. If a query object is passed, it will be used as a subselect. Unless the table name starts with the database / schema name and a dot it will be prefixed. $alias: The alias for the table. In most cases t