function 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 728

Class

Select

Query builder for SELECT statements.

Namespace

Code

public function countQuery() {
    $count = $this->prepareCountQuery();
    $query = $this->connection
        ->select($count, NULL, $this->queryOptions);
    $query->addExpression('COUNT(*)');
    return $query;
}