• Модуль: tasks
  • Путь к файлу: ~/bitrix/modules/tasks/lib/internals/counter/collector/usercollector.php
  • Класс: BitrixTasksInternalsCounterCollectorUserCollector
  • Вызов: UserCollector::getJoinForRecountComments
private function getJoinForRecountComments(): array
{
	return [
		"
			LEFT JOIN b_tasks_viewed TV ON TV.TASK_ID = T.ID AND TV.USER_ID = {$this->userId}
			INNER JOIN b_tasks_member TM ON TM.TASK_ID = T.ID AND TM.USER_ID = {$this->userId}
			INNER JOIN b_forum_message FM ON FM.TOPIC_ID = T.FORUM_TOPIC_ID
			LEFT JOIN b_uts_forum_message BUF ON BUF.VALUE_ID = FM.ID
		",
		Counter::getJoinForRecountCommentsByType(Enum::USER_NAME, ['userId' => $this->userId])
	];
}