ThemePickerGroup::getCount

private function getCount(): int
{
	$result = 0;

	$sitesList = $this->getSites();
	if (!empty($sitesList))
	{
		$query = new Query(WorkgroupTable::getEntity());
		$query->registerRuntimeField(
			'',
			new ReferenceField('WGS',
				WorkgroupSiteTable::getEntity(),
				[
					'=ref.GROUP_ID' => 'this.ID',
				],
				[ 'join_type' => 'INNER' ]
			)
		);
		$query->addFilter('@WGS.SITE_ID', $sitesList);
		$query->addSelect(Query::expr()->countDistinct('ID'), 'CNT');
		if ($resultFields = $query->exec()->fetch())
		{
			$result = $resultFields['CNT'];
		}
	}

	return $result;
}