TaskProvider::buildCountQuery

private function buildCountQuery(): string
{
	$select[] = "COUNT(".($this->canUseOptimization ? "DISTINCT " : "")."T.ID) AS CNT";
	foreach ($this->arGroup as $key)
	{
		if (array_key_exists($key, $this->arSqlSelect))
		{
			$select[] = $this->arSqlSelect[$key];
		}
	}

	$strSql = "
		SELECT
			". implode(",n", $select) ."
		FROM b_tasks T
		" . implode("n", $this->arJoins) . "
		" . implode("n", $this->relatedJoins) . "
		" . $this->obUserFieldsSql->GetJoin("T.ID") . "
		" . (count($this->arSqlSearch) ? "WHERE " . implode(" AND ", $this->arSqlSearch) : "") . "
		" . $this->strGroupBy;

	return $strSql;
}