Select::countQuery

public Select::countQuery()

Get the equivalent COUNT query of this query as a new query object.

Return value

\Drupal\Core\Database\Query\SelectInterface A new SelectQuery object with no fields or expressions besides COUNT(*).

Overrides SelectInterface::countQuery

File

core/lib/Drupal/Core/Database/Query/Select.php, line 703

Class

Select

Query builder for SELECT statements.

Namespace

Drupal\Core\Database\Query

Code

public function countQuery() {
  $count = $this->prepareCountQuery();

  $query = $this->connection->select($count, NULL, $this->queryOptions);
  $query->addExpression('COUNT(*)');

  return $query;
}