SegmentDataBuilder::checkBlockers

static function checkBlockers()
{
	$query = "
SELECT b.ID, b.GROUP_ID
FROM b_sender_group_state b
INNER JOIN (
    SELECT GROUP_ID, FILTER_ID
    FROM b_sender_group_state
    GROUP BY GROUP_ID, FILTER_ID
    HAVING COUNT(*) > 1
) d ON b.GROUP_ID = d.GROUP_ID AND b.FILTER_ID = d.FILTER_ID;
";

	$dbResult = BitrixMainApplication::getConnection()->query($query);
	$groups = [];
	while ($row = $dbResult->fetch()) {
		$groupId = $row['GROUP_ID'];
		if (in_array($groupId, $groups))
		{
			continue;
		}
		$id = $row['ID'];
		GroupStateTable::delete($id);
		$groups[] = $groupId;
		RuntimeSegmentDataClearJob::addEventAgent($groupId);
	}
}