View difference between Paste ID: 9c2WMgnN and yMt1cSqJ

 SELECT
    BE.ID as ID,
    BE.IBLOCK_ID as IBLOCK_ID,
    BE.CODE as CODE,
    BE.XML_ID as XML_ID,
    BE.NAME as NAME,
    BE.ACTIVE as ACTIVE,
    IF(
       EXTRACT(HOUR_SECOND FROM
             BE.ACTIVE_FROM)>0,
       DATE_FORMAT(
          BE.ACTIVE_FROM,
          '%d.%m.%Y %H:%i:%s'
       ),
       DATE_FORMAT(
          BE.ACTIVE_FROM,
          '%d.%m.%Y'
       )
    ) as DATE_ACTIVE_FROM,
    IF(
       EXTRACT(HOUR_SECOND
       FROM
          BE.ACTIVE_TO)>0,
       DATE_FORMAT(
          BE.ACTIVE_TO,
          '%d.%m.%Y %H:%i:%s'
       ),
       DATE_FORMAT(
          BE.ACTIVE_TO,
          '%d.%m.%Y'
       )
    ) as DATE_ACTIVE_TO,
    BE.SORT as SORT,
    BE.PREVIEW_TEXT as PREVIEW_TEXT,
    BE.PREVIEW_TEXT_TYPE as PREVIEW_TEXT_TYPE,
    BE.DETAIL_TEXT as DETAIL_TEXT,
    BE.DETAIL_TEXT_TYPE as DETAIL_TEXT_TYPE,
    DATE_FORMAT(
       BE.DATE_CREATE,
       '%d.%m.%Y %H:%i:%s'
    ) as DATE_CREATE,
    BE.CREATED_BY as CREATED_BY,
    BE.TAGS as TAGS,
    DATE_FORMAT(
       BE.TIMESTAMP_X,
       '%d.%m.%Y %H:%i:%s'
    ) as TIMESTAMP_X,
    BE.MODIFIED_BY as MODIFIED_BY,
    BE.IBLOCK_SECTION_ID as IBLOCK_SECTION_ID,
    B.DETAIL_PAGE_URL as DETAIL_PAGE_URL,
    BE.DETAIL_PICTURE as DETAIL_PICTURE,
    BE.PREVIEW_PICTURE as PREVIEW_PICTURE,
    L.DIR as LANG_DIR,
    BE.XML_ID as EXTERNAL_ID,
    B.IBLOCK_TYPE_ID as IBLOCK_TYPE_ID,
    B.CODE as IBLOCK_CODE,
    B.XML_ID as IBLOCK_EXTERNAL_ID,
    B.LID as LID,
    CAT_PR.QUANTITY as CATALOG_QUANTITY,
    CAT_PR.QUANTITY_RESERVED as CATALOG_QUANTITY_RESERVED,
    IF (
       CAT_PR.QUANTITY_TRACE = 'D',
       'Y',
       CAT_PR.QUANTITY_TRACE
    ) as CATALOG_QUANTITY_TRACE,
    CAT_PR.QUANTITY_TRACE as CATALOG_QUANTITY_TRACE_ORIG,
    IF (
       CAT_PR.CAN_BUY_ZERO = 'D',
       'N',
       CAT_PR.CAN_BUY_ZERO
    ) as CATALOG_CAN_BUY_ZERO,
    CAT_PR.CAN_BUY_ZERO as CATALOG_CAN_BUY_ZERO_ORIG,
    IF (
       CAT_PR.NEGATIVE_AMOUNT_TRACE = 'D',
       'N',
       CAT_PR.NEGATIVE_AMOUNT_TRACE
    ) as CATALOG_NEGATIVE_AMOUNT_TRACE,
    CAT_PR.NEGATIVE_AMOUNT_TRACE as CATALOG_NEGATIVE_AMOUNT_ORIG,
    IF (
       CAT_PR.SUBSCRIBE = 'D',
       'Y',
       CAT_PR.SUBSCRIBE
    ) as CATALOG_SUBSCRIBE,
    CAT_PR.SUBSCRIBE as CATALOG_SUBSCRIBE_ORIG,
    CAT_PR.AVAILABLE as CATALOG_AVAILABLE,
    CAT_PR.WEIGHT as CATALOG_WEIGHT,
    CAT_PR.WIDTH as CATALOG_WIDTH,
    CAT_PR.LENGTH as CATALOG_LENGTH,
    CAT_PR.HEIGHT as CATALOG_HEIGHT,
    CAT_PR.MEASURE as CATALOG_MEASURE,
    CAT_VAT.RATE as CATALOG_VAT,
    CAT_PR.VAT_ID as CATALOG_VAT_ID,
    CAT_PR.VAT_INCLUDED as CATALOG_VAT_INCLUDED,
    CAT_PR.PRICE_TYPE as CATALOG_PRICE_TYPE,
    CAT_PR.RECUR_SCHEME_TYPE as CATALOG_RECUR_SCHEME_TYPE,
    CAT_PR.RECUR_SCHEME_LENGTH as CATALOG_RECUR_SCHEME_LENGTH,
    CAT_PR.TRIAL_PRICE_ID as CATALOG_TRIAL_PRICE_ID,
    CAT_PR.WITHOUT_ORDER as CATALOG_WITHOUT_ORDER,
    CAT_PR.SELECT_BEST_PRICE as CATALOG_SELECT_BEST_PRICE,
    CAT_PR.PURCHASING_PRICE as CATALOG_PURCHASING_PRICE,
    CAT_PR.PURCHASING_CURRENCY as CATALOG_PURCHASING_CURRENCY,
    CAT_PR.TYPE as CATALOG_TYPE,
    CAT_PR.BUNDLE as CATALOG_BUNDLE
 FROM
    b_iblock B
    INNER JOIN b_lang L ON
       B.LID = L.LID
    INNER JOIN b_iblock_element BE ON
       BE.IBLOCK_ID = B.ID
    INNER JOIN (
       SELECT DISTINCT
          BSE.IBLOCK_ELEMENT_ID
       FROM
          b_iblock_section_element BSE
          INNER JOIN b_iblock_section BS ON
             BSE.IBLOCK_SECTION_ID = BS.ID
       WHERE
          (
             (BS.ACTIVE = 'Y')
             AND (BS.GLOBAL_ACTIVE = 'Y')
          )
    ) BES ON
       BES.IBLOCK_ELEMENT_ID = BE.ID
    LEFT JOIN b_catalog_product CAT_PR ON
       (CAT_PR.ID = BE.ID)
    LEFT JOIN b_catalog_iblock CAT_IB ON
       (
          (
             CAT_PR.VAT_ID IS NULL
             OR CAT_PR.VAT_ID = 0
          )
          AND CAT_IB.IBLOCK_ID = BE.IBLOCK_ID
       )
    LEFT JOIN b_catalog_vat CAT_VAT ON
       (
          CAT_VAT.ID = IF(
             (
                CAT_PR.VAT_ID IS NULL
                OR CAT_PR.VAT_ID = 0
             ),
             CAT_IB.VAT_ID,
             CAT_PR.VAT_ID
          )
       )
 WHERE
    1 = 1
    AND (
       (CAT_PR.AVAILABLE = 'Y')
       AND (
          BE.DETAIL_PICTURE > '0'
       )
       AND (
          BE.ID IN ('511479', '713728', '503959', '676597', '700604', '685279', '78559', '9090', '400411', '681104', '714597', '78559', '683514', '702980', '9090', '4789', '270791', '679352', '424141', '424141', '693726', '62213', '679315', '725319', '681104', '331890', '694693', '675057', '278770', '77997', '681104', '377433', '87376', '683763', '87423', '692741', '679305', '679349', '23867', '691735')
       )
       AND (
          EXISTS (
             SELECT
                IBLOCK_ID
             FROM
                b_iblock_site
             WHERE
                IBLOCK_ID = B.ID
                AND (SITE_ID = 's1')
          )
       )
       AND (
          (
             BE.ACTIVE_TO >= now()
             OR BE.ACTIVE_TO IS NULL
          )
          AND (
             BE.ACTIVE_FROM <= now()
             OR BE.ACTIVE_FROM IS NULL
          )
       )
       AND (BE.ACTIVE = 'Y')
       AND (BE.IBLOCK_ID = '13')
    )
    AND (
       BE.WF_STATUS_ID = 1
       AND BE.WF_PARENT_ELEMENT_ID IS NULL
    )
 ORDER BY
    BE.SORT ASC,
    BE.ID DESC
 LIMIT 20