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

if (CComponentEngine::ParseComponentPath("/cat/tovar/",  array(
"section" => "#SECTION_CODE#.html",             // сюда шаблон чпу для раздела
"element" => "#SECTION_CODE#/#ELEMENT_CODE#.html"),   // сюда шаблон чпу для элемента
                              $arVariables  ) == 'element')  define('ELEMENT_PAGE', true);

SEL ECT DISTINCT BE.ID as ID,BE.IBLOCK_ID as IBLOCK_ID , CAT_P2.ID as CATALOG_PRICE_ID_2,  CAT_P2.CATALOG_GROUP_ID as CATALOG_GROUP_ID_2,  CAT_P2.PRICE as CATALOG_PRICE_2,  CAT_P2.CURRENCY as CATALOG_CURRENCY_2,  CAT_P2.QUANTITY_FR OM as CATALOG_QUANTITY_FR OM_2,  CAT_P2.QUANTITY_TO as CATALOG_QUANTITY_TO_2,  '?????????????' as CATALOG_GROUP_NAME_2,  'Y' as CATALOG_CAN_ACCESS_2,  'Y' as CATALOG_CAN_BUY_2,  CAT_P2.EXTRA_ID as CATALOG_EXTRA_ID_2, CAT_P3.ID as CATALOG_PRICE_ID_3,  CAT_P3.CATALOG_GROUP_ID as CATALOG_GROUP_ID_3,  CAT_P3.PRICE as CATALOG_PRICE_3,  CAT_P3.CURRENCY as CATALOG_CURRENCY_3,  CAT_P3.QUANTITY_FR OM as CATALOG_QUANTITY_FROM_3,  CAT_P3.QUANTITY_TO as CATALOG_QUANTITY_TO_3,  '???? ??? ???????? ????????' as CATALOG_GROUP_NAME_3,  'Y' as CATALOG_CAN_ACCESS_3,  'Y' as CATALOG_CAN_BUY_3,  CAT_P3.EXTRA_ID as CATALOG_EXTRA_ID_3, CAT_PR.QUANTITY as CATALOG_QUANTITY,  CAT_PR.QUANTITY_TRACE as CATALOG_QUANTITY_TRACE,  CAT_PR.WEIGHT as CATALOG_WEIGHT,  CAT_VAT.RATE as CATALOG_VAT,  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  
         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_s1 FPS0 ON FPS0.IBLOCK_ELEMENT_ID = BE.ID
         INNER JOIN b_iblock_property FP0 ON FP0.IBLOCK_ID = B.ID AND  FP0.CODE='USB'
         INNER JOIN b_iblock_property FP1 ON FP1.IBLOCK_ID = B.ID AND  FP1.CODE='GP'
         INNER JOIN b_iblock_property FP2 ON FP2.IBLOCK_ID = B.ID AND  FP2.CODE='BLUETH'
         INNER JOIN b_iblock_property FP3 ON FP3.IBLOCK_ID = B.ID AND  FP3.CODE='AVOUTPUT'
         INNER JOIN b_iblock_property FP4 ON FP4.IBLOCK_ID = B.ID AND  FP4.CODE='ISO_cn'
         INNER JOIN b_iblock_property FP5 ON FP5.IBLOCK_ID = B.ID AND  FP5.CODE='ID3'
         INNER JOIN b_iblock_property FP6 ON FP6.IBLOCK_ID = B.ID AND  FP6.CODE='TYDITNE'
         INNER JOIN b_iblock_property FP7 ON FP7.IBLOCK_ID = B.ID AND  FP7.CODE='TV_TUN'
         INNER JOIN b_iblock_property FP8 ON FP8.IBLOCK_ID = B.ID AND  FP8.CODE='OTAIO'
         INNER JOIN b_iblock_property FP9 ON FP9.IBLOCK_ID = B.ID AND  FP9.CODE='AUDIO_IN'
         INNER JOIN b_iblock_property FP10 ON FP10.IBLOCK_ID = B.ID AND  FP10.CODE='IPOD_SUP'
         INNER JOIN b_iblock_property FP11 ON FP11.IBLOCK_ID = B.ID AND  FP11.CODE='PLAYER'
         INNER JOIN b_iblock_element_prop_m1 FPV0 ON FPV0.IBLOCK_PROPERTY_ID = FP0.ID AND FPV0.IBLOCK_ELEMENT_ID = BE.ID
         INNER JOIN b_iblock_element_prop_m1 FPV1 ON FPV1.IBLOCK_PROPERTY_ID = FP1.ID AND FPV1.IBLOCK_ELEMENT_ID = BE.ID
         INNER JOIN b_iblock_element_prop_m1 FPV2 ON FPV2.IBLOCK_PROPERTY_ID = FP2.ID AND FPV2.IBLOCK_ELEMENT_ID = BE.ID
         INNER JOIN b_iblock_element_prop_m1 FPV3 ON FPV3.IBLOCK_PROPERTY_ID = FP3.ID AND FPV3.IBLOCK_ELEMENT_ID = BE.ID
         INNER JOIN b_iblock_element_prop_m1 FPV4 ON FPV4.IBLOCK_PROPERTY_ID = FP4.ID AND FPV4.IBLOCK_ELEMENT_ID = BE.ID
         INNER JOIN b_iblock_element_prop_m1 FPV5 ON FPV5.IBLOCK_PROPERTY_ID = FP5.ID AND FPV5.IBLOCK_ELEMENT_ID = BE.ID
         INNER JOIN b_iblock_element_prop_m1 FPV6 ON FPV6.IBLOCK_PROPERTY_ID = FP6.ID AND FPV6.IBLOCK_ELEMENT_ID = BE.ID
         INNER JOIN b_iblock_element_prop_m1 FPV7 ON FPV7.IBLOCK_PROPERTY_ID = FP7.ID AND FPV7.IBLOCK_ELEMENT_ID = BE.ID
         INNER JOIN b_iblock_element_prop_m1 FPV8 ON FPV8.IBLOCK_PROPERTY_ID = FP8.ID AND FPV8.IBLOCK_ELEMENT_ID = BE.ID
         INNER JOIN b_iblock_element_prop_m1 FPV9 ON FPV9.IBLOCK_PROPERTY_ID = FP9.ID AND FPV9.IBLOCK_ELEMENT_ID = BE.ID
         INNER JOIN b_iblock_element_prop_m1 FPV10 ON FPV10.IBLOCK_PROPERTY_ID = FP10.ID AND FPV10.IBLOCK_ELEMENT_ID = BE.ID
         INNER JOIN b_iblock_element_prop_m1 FPV11 ON FPV11.IBLOCK_PROPERTY_ID = FP11.ID AND FPV11.IBLOCK_ELEMENT_ID = BE.ID
          INNER JOIN (
               SEL ECT DISTINCT B.ID
               FR OM b_iblock B
               INNER JOIN b_iblock_site BS ON BS.IBLOCK_ID = B.ID
               
               WH ERE
               ((((BS.SITE_ID='s1')))) AND ((((B.ID = '1')))) AND ((((B.ACTIVE='Y'))))
            ) BB ON BB.ID = BE.IBLOCK_ID
 INNER JOIN (
               SELECT DISTINCT BSE.IBLOCK_ELEMENT_ID
               FR OM b_iblock_section_element BSE
               
               INNER JOIN b_iblock_section BSubS ON BSE.IBLOCK_SECTION_ID = BSubS.ID
               INNER JOIN b_iblock_section BS ON (BSubS.IBLOCK_ID=BS.IBLOCK_ID
                  AND BSubS.LEFT_MARGIN>=BS.LEFT_MARGIN
                  AND BSubS.RIGHT_MARGIN<=BS.RIGHT_MARGIN)
               
               WH ERE ((BS.ID IN (181)))
               ) BES ON BES.IBLOCK_ELEMENT_ID = BE.ID

 
         LEFT JOIN b_catalog_price CAT_P2 ON (CAT_P2.PRODUCT_ID = BE.ID AND CAT_P2.CATALOG_GROUP_ID = 2)  AND   ((CAT_P2.QUANTITY_FROM <= 1 OR CAT_P2.QUANTITY_FROM IS NULL) AND (CAT_P2.QUANTITY_TO >= 1 OR CAT_P2.QUANTITY_TO IS NULL))  
         LEFT JOIN b_catalog_price CAT_P3 ON (CAT_P3.PRODUCT_ID = BE.ID AND CAT_P3.CATALOG_GROUP_ID = 3)  AND   ((CAT_P3.QUANTITY_FROM <= 1 OR CAT_P3.QUANTITY_FROM IS NULL) AND (CAT_P3.QUANTITY_TO >= 1 OR CAT_P3.QUANTITY_TO IS NULL))  
         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)) 

         WH ERE 1=1 
         AND (
         
            ((((FPV0.VALUE_ENUM = '1824'))))
            AND ((((FPV1.VALUE_ENUM = '1833'))))
            AND ((((FPV2.VALUE_ENUM = '1823'))))
            AND ((((FPV3.VALUE_ENUM = '561'))))
            AND ((((FPV4.VALUE_ENUM = '1801'))))
            AND ((((FPV5.VALUE_ENUM = '1805'))))
            AND ((((FPV6.VALUE_ENUM = '1826'))))
            AND ((((FPV7.VALUE_ENUM = '1828'))))
            AND ((((FPV8.VALUE_ENUM = '1825'))))
            AND ((((FPV9.VALUE_ENUM = '1831'))))
            AND ((((FPV10.VALUE_ENUM = '1832'))))
            AND (((FPV11.VALUE_ENUM IN ('563', '564', '565', '1979'))))
            AND ((((FPS0.PROPERTY_1325 >= '0'))))
            AND ((((FPS0.PROPERTY_1325 <= '100'))))
            AND ((((FPS0.PROPERTY_1244 = '1966'))))
            AND ((((CAT_P2.PRICE >= '0'))))
            AND ((((CAT_P2.PRICE <= '20000'))))
            AND ((((BE.IBLOCK_ID = '1'))))
            AND ((((B.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.ACTIVE='Y'))))
            AND ( 1=1 )
            AND ( 1=1 )
         )
         AND (((BE.WF_STATUS_ID=1 AND BE.WF_PARENT_ELEMENT_ID IS NULL)))
         
       ORDER BY BE.ID asc  LIM IT 100