Олег Фахрутдин (Все сообщения пользователя)

SEL ECT 
    e.ID AS 'ID',
    e.NAME AS 'Название',
    e.CODE AS 'Символьный код',
    e.ACTIVE AS 'Активен',
    
    -- Полный путь раздела через рекурсию
    (SELECT GROUP_CONCAT(s2.NAME ORDER BY s2.DEPTH_LEVEL SEPARATOR ' / ')
     FR OM b_iblock_section s2
     WHERE s2.LEFT_MARGIN <= s.LEFT_MARGIN 
        AND s2.RIGHT_MARGIN >= s.RIGHT_MARGIN
        AND s2.IBLOCK_ID = 5) AS 'Полный путь раздела',
    
    s.NAME AS 'Текущий раздел',
    s.DEPTH_LEVEL AS 'Уровень',
    
    e.DATE_CREATE AS 'Дата создания',
    e.TIMESTAMP_X AS 'Дата изменения',
    e.SORT AS 'Сортировка'
    
FR OM b_iblock_element e
LEFT JOIN b_iblock_section s ON e.IBLOCK_SECTION_ID = s.ID AND s.IBLOCK_ID = 5
WH ERE e.IBLOCK_ID = 5
    AND e.ACTIVE = 'Y'
ORDER BY 
    s.LEFT_MARGIN,
    e.SORT,
    e.NAME;

$searchFilter = array(    
'QUERY' => $this->request->get('searchString'),
"LOGIC" => "AND",
    array(
        "=MODULE_ID" => "iblock",
        "=PARAM2" => array(IBLOCK_CATALOG_ID),
        "ITEM_ID" => $arElementsProductsIDs
    ),
    array(
        "=MODULE_ID" => "iblock",
        "!=PARAM2" => array(IBLOCK_CATALOG_ID),
    )
);

$subQuery = new \Bitrix\Main\Entity\Query(Price\ValuesTable::getEntity());
$rs = Price\ValuesTable::getList([
    'filter' => [
        'packing_id' => [50, 60]
    ],
    'sel ect' => array('*'),
    'filter' => [
        'packing_id' => new \Bitrix\Main\DB\SqlEx * pression('(SELECT t.packing_id (SELECT pe.packing_id, MAX(pe.value) FR OM '.$subQuery->getEntity()->getDBTableName().' pe WHERE pe.packing_id   = '.strtolower($subQuery->getEntity()->getCode()).'.packing_id) t)')
    ]
]);

$bbCode = (new CTextParser())->convertHTMLToBB($html);

<?
// текущая страница: /work/page/?test_string 
$page = $APPLICATION->GetCurPage(); // результат - /work/page/ 
if(!empty($_GET))
{
    LocalRedirect($page);
}
?>

$sql='SEL ECT
   bie.ACTIVE,bsb.*
FR OM
   b_sale_basket bsb
INNER JOIN b_iblock_element bie on bie.ID=bsb.PRODUCT_ID and bie.ACTIVE=\'N\'
WHERE
   bsb.ORDER_ID IS NULL';
$db_res = $DB->Query($sql, false, "File: ".__FILE__."<br>Line: ".__LINE__);
while ($ar_res = $db_res->Fetch())
{
   CSaleBasket::Delete($ar_res["ID"]);
}

SEL ECT bcp.*
FR OM b_catalog_product bcp 
LEFT JOIN b_catalog_measure_ratio bcmr ON bcmr.PRODUCT_ID=bcp.ID
WHERE bcmr.PRODUCT_ID IS NULL

if (!isset($arItem["MEASURE_RATIO"]))
{
    $arItem["MEASURE_RATIO"] = 1;
}

$arFilter['IBLOCK_ID'] = 25;
$arFilter['ACTIVE'] = 'Y';
$arFilter['PROPERTY_MATERIAL_COUNTERTOPS'] = array(66157);//такого свойства нет в инфоблоке
$res = CIBlockElement::GetList(Array(), $arFilter, false, array("nTopCount" => 1));
$results = $res->Fetch();
echo($results);//должно быть пустым

'exception_handling' =>
  array (
    'value' =>
    array (
      'debug' => true,
      'handled_errors_types' => 4437,
      'exception_errors_types' => 4437,
      'ignore_silence' => false,
      'assertion_throws_exception' => true,
      'assertion_error_type' => 256,
      'log' => NULL,
    ),
    'readonly' => false,
  ),

<?$APPLICATION->IncludeComponent(
   "bitrix:advertising.banner",
   "center_default",
   Array(
      "CACHE_TIME" => "3600",
      "CACHE_TYPE" => "Y",//кешируем
      "NOINDEX" => "N",
      "TYPE" => "CENTER_DEFAULT"
   )
);?>

Array
(
    [region] => Array
        (
            [id] => 213
            [name] => Москва
            [type] => CITY
            [parent] => Array
                (
                    [id] => 1
                    [name] => Москва и Московская область
                    [type] => SUBJECT_FEDERATION
                    [parent] => Array
                        (
                            [id] => 3
                            [name] => Центральный федеральный округ
                            [type] => COUNTRY_DISTRICT
                            [parent] => Array
                                (
                                    [id] => 225
                                    [name] => Россия
                                    [type] => COUNTRY
                                )

                        )

                )

        )

)

$cacheManager = \Bitrix\Main\Application::getInstance()->getManagedCache();
$cacheManager->clean("CSaleYMLocations");