Таблицы модуля «Информационные блоки» в 1С-Битрикс: руководство по использованию

<?php
require_once $_SERVER['DOCUMENT_ROOT'].'/bitrix/modules/main/include/prolog_admin.php';

$res = \Bitrix\Main\Application::getConnection()->query("
    SELECT 
        e.NAME as ELEMENT_NAME,
        s.NAME as SECTION_NAME
    FROM 
        b_iblock_element e
        INNER JOIN b_iblock i ON e.IBLOCK_ID = i.ID
        LEFT JOIN b_iblock_section_element se ON e.ID = se.IBLOCK_ELEMENT_ID
        LEFT JOIN b_iblock_section s ON se.IBLOCK_SECTION_ID = s.ID
    WHERE 
        i.CODE = 'news'
        AND e.ACTIVE = 'Y'
    ORDER BY 
        e.TIMESTAMP_X DESC
");

while ($row = $res->fetch()) {
    echo "Элемент: {$row['ELEMENT_NAME']}, Раздел: {$row['SECTION_NAME']}<br>";
}

require_once $_SERVER['DOCUMENT_ROOT'].'/bitrix/modules/main/include/epilog_admin.php';
?>