SEL ECT DISTINCT BE.ID as ID
,BE.NAME as NAME
,BE.CODE as CODE
,DATE_FORMAT(BE.DATE_CREATE, '%d.%m.%Y %H:%i:%s') as DATE_CREATE
,IF(EXTRACT(HOUR_SECOND
FR OM
BE.ACTIVE_FR OM)>0, DATE_FORMAT(BE.ACTIVE_FROM, '%d.%m.%Y %H:%i:%s'), DATE_FORMAT(BE.ACTIVE_FROM, '%d.%m.%Y')) as ACTIVE_FR OM
,BE.CREATED_BY as CREATED_BY
,BE.IBLOCK_ID as IBLOCK_ID
,BE.IBLOCK_SECTION_ID as IBLOCK_SECTION_ID
,B.DETAIL_PAGE_URL as DETAIL_PAGE_URL
,BE.DETAIL_TEXT as DETAIL_TEXT
,BE.DETAIL_TEXT_TYPE as DETAIL_TEXT_TYPE
,BE.DETAIL_PICTURE as DETAIL_PICTURE
,BE.PREVIEW_TEXT as PREVIEW_TEXT
,BE.PREVIEW_TEXT_TYPE as PREVIEW_TEXT_TYPE
,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_P1.ID as CATALOG_PRICE_ID_1
, CAT_P1.CATALOG_GROUP_ID as CATALOG_GROUP_ID_1
, CAT_P1.PRICE as CATALOG_PRICE_1
, CAT_P1.CURRENCY as CATALOG_CURRENCY_1
, CAT_P1.QUANTITY_FR OM as CATALOG_QUANTITY_FROM_1
, CAT_P1.QUANTITY_TO as CATALOG_QUANTITY_TO_1
, 'Розничная цена' as CATALOG_GROUP_NAME_1
, 'N' as CATALOG_CAN_ACCESS_1
, 'N' as CATALOG_CAN_BUY_1
, CAT_P1.EXTRA_ID as CATALOG_EXTRA_ID_1
, 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
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 b_iblock_property FP0 ON FP0.IBLOCK_ID = B.ID AND FP0.CODE='AVAILABILE'
INNER JOIN b_iblock_property FP1 ON FP1.IBLOCK_ID = B.ID AND FP1.CODE='FIRMA'
INNER JOIN b_iblock_property FP2 ON FP2.IBLOCK_ID = B.ID AND FP2.CODE='SIZES'
INNER JOIN b_iblock_property FP3 ON FP3.IBLOCK_ID = B.ID AND FP3.CODE='SEASON'
INNER JOIN b_iblock_element_property FPV0 ON FPV0.IBLOCK_PROPERTY_ID = FP0.ID AND FPV0.IBLOCK_ELEMENT_ID = BE.ID
INNER JOIN b_iblock_element_property FPV1 ON FPV1.IBLOCK_PROPERTY_ID = FP1.ID AND FPV1.IBLOCK_ELEMENT_ID = BE.ID
INNER JOIN b_iblock_element_property FPV2 ON FPV2.IBLOCK_PROPERTY_ID = FP2.ID AND FPV2.IBLOCK_ELEMENT_ID = BE.ID
INNER JOIN b_iblock_element_property FPV3 ON FPV3.IBLOCK_PROPERTY_ID = FP3.ID AND FPV3.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
INNER JOIN b_iblock_group IBG ON IBG.IBLOCK_ID = B.ID
WH ERE
((((BS.SITE_ID='s1')))) AND (( IBG.GROUP_ID IN (2) AND IBG.PERMISSION >= 'R' AND (IBG.PERMISSION='X' OR B.ACTIVE='Y') )) AND ((((B.ID = '3')))) 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 (26, 8, 12, 16))) ) BES ON BES.IBLOCK_ELEMENT_ID = BE.ID
LEFT JOIN b_catalog_price CAT_P1 ON (CAT_P1.PRODUCT_ID = BE.ID AND CAT_P1.CATALOG_GROUP_ID = 1) AND ((CAT_P1.QUANTITY_FROM <= 1 OR CAT_P1.QUANTITY_FROM IS NULL) AND (CAT_P1.QUANTITY_TO >= 1 OR CAT_P1.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 IN ('11', '4')))) AND (((FPV1.VALUE_NUM IN ('454', '2930', '143', '787', '3106', '1610', '139', '1668', '260', '2344', '136', '172', '647', '563', '5409', '4049', '2609', '607', '3967', '992', '773', '1161', '2970', '2361', '6060', '1046', '1986', '212', '2547', '496', '1137', '4385', '675', '179', '1551', '3040', '1514', '1212', '3648', '1861', '903', '661', '5220', '3385', '182', '4152', '175', '2291', '2076', '530', '5498', '444', '1876', '2736', '5992', '674', '4258', '436', '5610', '3233', '1105', '4796', '2808', '5176', '5408', '418', '460', '3926', '807', '3870', '932', '670', '1571')))) AND ((((FPV2.VALUE_ENUM = '13')))) AND (((FPV3.VALUE_ENUM IN ('25', '26', '9', '27', '10', '28')))) AND ((((BE.IBLOCK_ID = '3')))) 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 (((BE.WF_STATUS_ID=1 AND BE.WF_PARENT_ELEMENT_ID IS NULL)))
ORDER BY
BE.ID desc
LIM IT 144, 24 |