Алексей Алексеев (Все сообщения пользователя)

\Bitrix\Main\UserAuthActionTable::addLogoutAction($userId);

global $USER;
$USER->SetParam("AUTH_ACTION_SKIP_LOGOUT", true);
\Bitrix\Main\UserAuthActionTable::addLogoutAction($USER->GetID());

use Bitrix\Sale\Internals\ServiceRestrictionTable;
use Bitrix\Main\ORM\Fields\ArrayField;

$restrictionsEntity = ServiceRestrictionTable::getEntity();

// Поле с правильной десериализацией значения.
$restrictionsEntity->addField(
    (new ArrayField('PARAMS'))->configureSerializationPhp(),
    'PARAMS_AS_ARRAY'
);

$restriction = ServiceRestrictionTable::getList([
    'select' => [
        'PARAMS_AS_ARRAY'
    ]
])->fetchObject();

$params = $restriction->getParamsAsArray();

use Bitrix\Iblock\InheritedProperty;
......
$ipropValues = new InheritedProperty\ElementValues($arFields['IBLOCK_ID'], $arFields['ID']);
$ipropValues->clearValues(); 

\Bitrix\Main\Loader::includeModule('iblock');
\Bitrix\Main\Application::getConnection()->startTracker(true);
$elements = \Bitrix\Iblock\ElementTable::getList([
            'filter' => [
      'ROOT.ID' => 947, // Раздел, в котором ищем включая подразделы.
      '==LINK.ADDITIONAL_PROPERTY_ID' => NULL, // Основная привязка элементов к группам.
      'ACTIVE' => 'Y' // Активные элементы.
            ],
            'sel ect' => [
      'ID',
            ],
       'group' => [
      'ID'
       ],
            'runtime' => [
                'LINK' => [
                    'data_type' => \Bitrix\Iblock\SectionElementTable::class,
                    'reference' => [
                        '=this.ID' => 'ref.IBLOCK_ELEMENT_ID',
                    ],
          'join_type' => 'inner',
                ],
                'PARENT' => [
                    'data_type' => \Bitrix\Iblock\SectionTable::class,
                    'reference' => [
                        '=this.LINK.IBLOCK_SECTION_ID' => 'ref.ID',
                    ],
          'join_type' => 'inner',
                ],
                'ROOT' => [
                    'data_type' => \Bitrix\Iblock\SectionTable::class,
                    'reference' => [
                        '=this.PARENT.IBLOCK_ID' => 'ref.IBLOCK_ID',
                        '<=ref.LEFT_MARGIN' => 'this.PARENT.LEFT_MARGIN',
                        '>=ref.RIGHT_MARGIN' => 'this.PARENT.RIGHT_MARGIN',
                    ], 
                    'join_type' => 'inner',
                ],
            ]
        ]);

\Bitrix\Main\Application::getConnection()->stopTracker();

var_dump($elements->fetch());

print_r(\Bitrix\Main\Application::getConnection()->getTracker());

SELECT 
   `iblock_element`.`ID` AS `ID`
FR OM `b_iblock_element` `iblock_element` 
INNER JOIN `b_iblock_section_element` `iblock_element_link` ON `iblock_element`.`ID` = `iblock_element_link`.`IBLOCK_ELEMENT_ID`
INNER JOIN `b_iblock_section` `iblock_element_parent` ON `iblock_element_link`.`IBLOCK_SECTION_ID` = `iblock_element_parent`.`ID`
INNER JOIN `b_iblock_section` `iblock_element_root` ON `iblock_element_parent`.`IBLOCK_ID` = `iblock_element_root`.`IBLOCK_ID`
AND `iblock_element_root`.`LEFT_MARGIN` <= `iblock_element_parent`.`LEFT_MARGIN`
AND `iblock_element_root`.`RIGHT_MARGIN` >= `iblock_element_parent`.`RIGHT_MARGIN`
WHERE `iblock_element_root`.`ID` = 947
AND `iblock_element_link`.`ADDITIONAL_PROPERTY_ID` IS NULL
AND UPPER(`iblock_element`.`ACTIVE`) like upper('Y')
GROUP BY `iblock_element`.`ID`