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

 if (\Bitrix\Main\Loader::includeModule('iblock'))
{
   $parameters = [
      'sel ect' => ['ID', 'NAME'],
      'filter' => [
         'IBLOCK_ID' => 5,
         [
            'LOGIC' => 'OR',
            [">=LEFT_MARGIN" => 1, "<=RIGHT_MARGIN" => "16"],
            [">=LEFT_MARGIN" => 31, "<=RIGHT_MARGIN" => "32"],
         ]
      ]
   ];
   $r = \Bitrix\Iblock\SectionTable::getList($parameters);
   while ($s = $r->fetch())
   {
      echo "<pre>"; print_r($s); echo "</pre>";
   }
}
echo "<pre>"; print_r(\Bitrix\Iblock\SectionTable::query()->getLastQuery()); echo "</pre>";
 

 SELECT 
   `iblock_section`.`ID` AS `ID`,
   `iblock_section`.`NAME` AS `NAME`
FR OM `b_iblock_section` `iblock_section` 

WHERE `iblock_section`.`IBLOCK_ID` = 5
AND (
   (
      `iblock_section`.`LEFT_MARGIN` >= 1
      AND `iblock_section`.`RIGHT_MARGIN` <= 16
   )
   OR (
      `iblock_section`.`LEFT_MARGIN` >= 31
      AND `iblock_section`.`RIGHT_MARGIN` <= 32
   )
)