100chuk (Все сообщения пользователя)

SEL ECT DISTINCT
   BE.DETAIL_PICTURE as DETAIL_PICTURE,
   BE.ID as ID,
   BE.IBLOCK_ID as IBLOCK_ID,
   BE.IBLOCK_SECTION_ID as IBLOCK_SECTION_ID,
   BE.NAME as NAME,
   IF(
      EXTRACT(HOUR_SECOND FR OM
            BE.ACTIVE_FROM)>0,
      DATE_FORMAT(
         BE.ACTIVE_FROM,
         '%d.%m.%Y %H:%i:%s'
      ),
      DATE_FORMAT(
         BE.ACTIVE_FROM,
         '%d.%m.%Y'
      )
   ) as ACTIVE_FROM,
   B.DETAIL_PAGE_URL as DETAIL_PAGE_URL,
   BE.DETAIL_TEXT as DETAIL_TEXT,
   BE.DETAIL_TEXT_TYPE as DETAIL_TEXT_TYPE,
   BE.PREVIEW_TEXT as PREVIEW_TEXT,
   BE.PREVIEW_TEXT_TYPE as PREVIEW_TEXT_TYPE,
   BE.PREVIEW_PICTURE as PREVIEW_PICTURE,
   FPS0. *,
   L.DIR as LANG_DIR,
   BE.SORT as SORT,
   BE.CODE as CODE,
   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
FR OM
   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 b_iblock_element_prop_s121 FPS0 ON
      FPS0.IBLOCK_ELEMENT_ID = BE.ID
   LEFT JOIN b_iblock_property FP0 ON
      FP0.IBLOCK_ID = B.ID
      AND FP0.CODE = 'CAT_VO'
   LEFT JOIN b_iblock_property FP1 ON
      FP1.IBLOCK_ID = B.ID
      AND FP1.CODE = 'ARTICLE'
   LEFT JOIN b_iblock_element_prop_m121 FPV0 ON
      FPV0.IBLOCK_PROPERTY_ID = FP0.ID
      AND FPV0.IBLOCK_ELEMENT_ID = BE.ID
   LEFT JOIN b_iblock_element_prop_m121 FPV1 ON
      FPV1.IBLOCK_PROPERTY_ID = FP1.ID
      AND FPV1.IBLOCK_ELEMENT_ID = BE.ID
WH ERE
   1 = 1
   AND (
      (BE.IBLOCK_ID = '121')
      AND (
         EXISTS (
            SELECT
               IBLOCK_ID
            FR OM
               b_iblock_site
            WHERE
               IBLOCK_ID = B.ID
               AND (SITE_ID = 'vo')
         )
      )
      AND (BE.ACTIVE = 'Y')
      AND (
         (
            BE.ACTIVE_TO >= now()
            OR BE.ACTIVE_TO IS NULL
         )
         AND (
            BE.ACTIVE_FROM <= now()
            OR BE.ACTIVE_FROM IS NULL
         )
      )
      AND (
         BE.ID IS NULL
         OR NOT (
            BE.ID IN ('353983', '353934', '353998', '353987', '353978', '353957', '353951', '353945', '353939', '353927', '353914', '353905', '353901', '353898', '353892', '353887', '353884', '353881', '353875', '353811', '353767', '353680', '353604', '353608', '352904', '352677', '352241', '353869', '353844', '353837', '353829', '352060', '345659')
         )
      )
      AND (FPV0.VALUE_ENUM IS NOT NULL)
      AND (FPS0.PROPERTY_521 IS NULL)
      AND (FPV1.VALUE_ENUM IS NULL)
   )
   AND (
      BE.WF_STATUS_ID = 1
      AND BE.WF_PARENT_ELEMENT_ID IS NULL
   )
   AND (
      B.ID IN (
         SELECT
            IBLOCK_ID
         FROM
            b_iblock_group IBG
         WHERE
            IBG.GROUP_ID IN (2)
            AND IBG.PERMISSION >= 'R'
            AND (
               IBG.PERMISSION = 'X'
               OR B.ACTIVE = 'Y'
            )
      )
      OR (
         B.RIGHTS_MODE = 'E'
         AND EXISTS (
            SELECT
               ER.ELEMENT_ID
            FROM
               b_iblock_element_right ER
               INNER JOIN b_iblock_right IBR ON
                  IBR.ID = ER.RIGHT_ID
               INNER JOIN b_user_access UA ON
                  UA.ACCESS_CODE = IBR.GROUP_CODE
                  AND UA.USER_ID = 0
            WHERE
               ER.ELEMENT_ID = BE.ID
               AND IBR.OP_EREAD = 'Y'
         )
      )
   )
ORDER BY
   BE.ACTIVE_FROM DESC,
   BE.SORT ASC,
   BE.ID DESC
LIM IT 5568,
12