Select::$tables

The tables against which to JOIN. This property is a nested array. Each entry is an array representing a single table against which to join. The structure of each entry is: array( 'type' => $join_type (one of INNER, LEFT OUTER, RIGHT OUTER), 'table' => $table, 'alias' => $alias_of_the_table, 'condition' => $join_condition (string or Condition object), 'arguments' => $array_of_arguments_for_placeholders_in_the condition. 'all_fields' => TRUE to SELECT $alias.*, FALSE or NULL ot

Select::$range

The range limiters for this query. Type: array File core/lib/Drupal/Core/Database/Query/Select.php, line 94 Class Select Query builder for SELECT statements. Namespace Drupal\Core\Database\Query Code protected $range;

Select::$prepared

Indicates if preExecute() has already been called. Type: bool File core/lib/Drupal/Core/Database/Query/Select.php, line 113 Class Select Query builder for SELECT statements. Namespace Drupal\Core\Database\Query Code protected $prepared = FALSE;

Select::$order

The fields by which to order this query. This is an associative array. The keys are the fields to order, and the value is the direction to order, either ASC or DESC. Type: array File core/lib/Drupal/Core/Database/Query/Select.php, line 66 Class Select Query builder for SELECT statements. Namespace Drupal\Core\Database\Query Code protected $order = array();

Select::$having

The conditional object for the HAVING clause. Type: \Drupal\Core\Database\Query\Condition File core/lib/Drupal/Core/Database/Query/Select.php, line 80 Class Select Query builder for SELECT statements. Namespace Drupal\Core\Database\Query Code protected $having;

Select::$group

The fields by which to group. Type: array File core/lib/Drupal/Core/Database/Query/Select.php, line 73 Class Select Query builder for SELECT statements. Namespace Drupal\Core\Database\Query Code protected $group = array();

Select::$forUpdate

The FOR UPDATE status File core/lib/Drupal/Core/Database/Query/Select.php, line 118 Class Select Query builder for SELECT statements. Namespace Drupal\Core\Database\Query Code protected $forUpdate = FALSE;

Select::$fields

The fields to SELECT. Type: array File core/lib/Drupal/Core/Database/Query/Select.php, line 23 Class Select Query builder for SELECT statements. Namespace Drupal\Core\Database\Query Code protected $fields = array();

Select::$expressions

The expressions to SELECT as virtual fields. Type: array File core/lib/Drupal/Core/Database/Query/Select.php, line 30 Class Select Query builder for SELECT statements. Namespace Drupal\Core\Database\Query Code protected $expressions = array();

Select::$distinct

Whether or not this query should be DISTINCT Type: bool File core/lib/Drupal/Core/Database/Query/Select.php, line 87 Class Select Query builder for SELECT statements. Namespace Drupal\Core\Database\Query Code protected $distinct = FALSE;