Effective::getExpiredTasksCountForNow

static function getExpiredTasksCountForNow($userId, $groupId = 0)
{
	$query = new Query(TaskTable::getEntity());

	$query->setSelect([new EntityExpressionField('COUNT', 'COUNT(%s)', 'ID')]);
	$query->registerRuntimeField('TM', new EntityReferenceField(
		'TM',
		MemberTable::getEntity(),
		Join::on('this.ID', 'ref.TASK_ID')
			->where('ref.USER_ID', $userId)
			->whereIn('ref.TYPE', ['R', 'A']),
		['join_type' => 'inner']
	));
	$query
		->where(
			Query::filter()
				->logic('or')
				->where(
					Query::filter()
						->where('TM.TYPE', 'R')
						->whereColumn('CREATED_BY', '<>', 'RESPONSIBLE_ID')
				)
				->where(
					Query::filter()
						->where('TM.TYPE', 'A')
						->where('CREATED_BY', '<>', $userId)
						->where('RESPONSIBLE_ID', '<>', $userId)
				)
		)
		->where('CLOSED_DATE', NULL)
		->where('DEADLINE', '<', Deadline::getExpiredTime())
		->where('STATUS', '<', Status::SUPPOSEDLY_COMPLETED)
		->where(($groupId? Query::filter()->where('GROUP_ID', $groupId) : []));

	$count = $query->exec()->fetch();

	return $count['COUNT'];
}