Форумы портала PHP.SU

PHP:
скопировать код в буфер обмена
 SELECT DISTINCT
   BE.ID as ID,
   BE.NAME as NAME,
   BE.IBLOCK_SECTION_ID as IBLOCK_SECTION_ID,
   BE.IBLOCK_ID as IBLOCK_ID,
   B.DETAIL_PAGE_URL as DETAIL_PAGE_URL,
   BE.DETAIL_PICTURE as DETAIL_PICTURE,
   BE.DETAIL_TEXT as DETAIL_TEXT,
   FPV0.VALUE as PROPERTY_PRICE_VALUE,
   FPV0.ID as PROPERTY_PRICE_VALUE_ID,
   FPV1.VALUE as PROPERTY_URL_VALUE,
   FPV1.ID as PROPERTY_URL_VALUE_ID,
   FPV2.VALUE as PROPERTY_VENDOR_VALUE,
   FPV2.ID as PROPERTY_VENDOR_VALUE_ID,
   FPV3.VALUE as PROPERTY_OLD_PRICE_VALUE,
   FPV3.ID as PROPERTY_OLD_PRICE_VALUE_ID,
   FPEN0.VALUE as PROPERTY_SHOP_VALUE,
   FPEN0.ID as PROPERTY_SHOP_ENUM_ID,
   FPV4.ID as PROPERTY_SHOP_VALUE_ID,
   FPV5.VALUE as PROPERTY_SIZE_VALUE,
   FPV5.ID as PROPERTY_SIZE_VALUE_ID,
   FPV6.VALUE as PROPERTY_COLOR_VALUE,
   FPV6.ID as PROPERTY_COLOR_VALUE_ID,
   FPV7.VALUE as PROPERTY_PICTURE_VALUE,
   FPV7.ID as PROPERTY_PICTURE_VALUE_ID,
   L.DIR as LANG_DIR,
   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,
   BE.DETAIL_TEXT_TYPE as DETAIL_TEXT_TYPE
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
   LEFT JOIN b_iblock_property FP0 ON
      FP0.IBLOCK_ID = B.ID
      AND FP0.CODE = 'PRICE'
   LEFT JOIN b_iblock_property FP1 ON
      FP1.IBLOCK_ID = B.ID
      AND FP1.CODE = 'URL'
   LEFT JOIN b_iblock_property FP2 ON
      FP2.IBLOCK_ID = B.ID
      AND FP2.CODE = 'VENDOR'
   LEFT JOIN b_iblock_property FP3 ON
      FP3.IBLOCK_ID = B.ID
      AND FP3.CODE = 'OLD_PRICE'
   LEFT JOIN b_iblock_property FP4 ON
      FP4.IBLOCK_ID = B.ID
      AND FP4.CODE = 'SHOP'
   LEFT JOIN b_iblock_property FP5 ON
      FP5.IBLOCK_ID = B.ID
      AND FP5.CODE = 'SIZE'
   LEFT JOIN b_iblock_property FP6 ON
      FP6.IBLOCK_ID = B.ID
      AND FP6.CODE = 'COLOR'
   LEFT JOIN b_iblock_property FP7 ON
      FP7.IBLOCK_ID = B.ID
      AND FP7.CODE = 'PICTURE'
   LEFT JOIN b_iblock_element_property FPV0 ON
      FPV0.IBLOCK_PROPERTY_ID = FP0.ID
      AND FPV0.IBLOCK_ELEMENT_ID = BE.ID
   LEFT JOIN b_iblock_element_property FPV1 ON
      FPV1.IBLOCK_PROPERTY_ID = FP1.ID
      AND FPV1.IBLOCK_ELEMENT_ID = BE.ID
   LEFT JOIN b_iblock_element_property FPV2 ON
      FPV2.IBLOCK_PROPERTY_ID = FP2.ID
      AND FPV2.IBLOCK_ELEMENT_ID = BE.ID
   LEFT JOIN b_iblock_element_property FPV3 ON
      FPV3.IBLOCK_PROPERTY_ID = FP3.ID
      AND FPV3.IBLOCK_ELEMENT_ID = BE.ID
   LEFT JOIN b_iblock_element_property FPV4 ON
      FPV4.IBLOCK_PROPERTY_ID = FP4.ID
      AND FPV4.IBLOCK_ELEMENT_ID = BE.ID
   LEFT JOIN b_iblock_element_property FPV5 ON
      FPV5.IBLOCK_PROPERTY_ID = FP5.ID
      AND FPV5.IBLOCK_ELEMENT_ID = BE.ID
   LEFT JOIN b_iblock_element_property FPV6 ON
      FPV6.IBLOCK_PROPERTY_ID = FP6.ID
      AND FPV6.IBLOCK_ELEMENT_ID = BE.ID
   LEFT JOIN b_iblock_element_property FPV7 ON
      FPV7.IBLOCK_PROPERTY_ID = FP7.ID
      AND FPV7.IBLOCK_ELEMENT_ID = BE.ID
   LEFT JOIN b_iblock_property_enum FPEN0 ON
      FPEN0.PROPERTY_ID = FPV4.IBLOCK_PROPERTY_ID
      AND FPV4.VALUE_ENUM = FPEN0.ID
WHERE
   1 = 1
   AND (
      (BE.ID = '730902')
      AND (BE.IBLOCK_ID = '1')
      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.WF_STATUS_ID = 1
      AND BE.WF_PARENT_ELEMENT_ID IS NULL
   )