sql дичь

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