Руслан Пучков (Все сообщения пользователя)

[root@host ~]# journalctl -xe
-- The start-up result is done.

[root@host ~]# php -v
PHP 7.0.31 (cli) (built: Jul 17 2018 15:30:29) ( NTS )
Copyright (c) 1997-2017 The PHP Group
Zend Engine v3.0.0, Copyright (c) 1998-2017 Zend Technologies
    with Zend OPcache v7.0.31, Copyright (c) 1999-2017, by Zend Technologies
    with Xdebug v2.6.1, Copyright (c) 2002-2018, by Derick Rethans

use Bitrix\Main\Application;

$sectResultID=604;
$elemResult=315245;

$reqleft="sel ect BE.ID as ID,BE.NAME as NAME,BE.CODE as CODE fr om b_iblock_element BE where id = (select min(id) fr om b_iblock_element wh ere b_iblock_element.ACTIVE='Y' and id > ".$elemResult;
if (!empty($sectResultID))
{
$reqleft.=" and b_iblock_element.IBLOCK_SECTION_ID=".$sectResultID;
}
$reqleft.=" ORDER BY b_iblock_element.ID desc ";
$reqleft.=" )";

$resleft = Application::getConnection()
->query($reqleft)
->fetchAll();