я убрала его в вызове компонента постраничную навигацию, вроде заработало... сейчас другая проблема в том же логе появилась.SEL ECT 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 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 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,DATE_FORMAT(BE.TIMESTAMP_X, '%d.%m.%Y %H:%i:%s') as TIMESTAMP_X,BE.MODIFIED_BY as MODIFIED_BY,BE.TAGS as TAGS,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, FPV0.VALUE as PROPERTY_CML2_DAYS_DELIVERY_VALUE, FPV0.ID as PROPERTY_CML2_DAYS_DELIVERY_VALUE_ID,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_FROM as CATALOG_QUANTITY_FROM_1, CAT_P1.QUANTITY_TO as CATALOG_QUANTITY_TO_1, 'ZAKUPOCHNYEYUNIMANN' as CATALOG_GROUP_NAME_1, 'Y' as CATALOG_CAN_ACCESS_1, 'Y' as CATALOG_CAN_BUY_1, CAT_P1.EXTRA_ID as CATALOG_EXTRA_ID_1, 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_FROM as CATALOG_QUANTITY_FROM_2, CAT_P2.QUANTITY_TO as CATALOG_QUANTITY_TO_2, 'ZAKUPOCHNYEYUNIMANN_+6%' as CATALOG_GROUP_NAME_2, 'N' as CATALOG_CAN_ACCESS_2, 'N' 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_FROM as CATALOG_QUANTITY_FROM_3, CAT_P3.QUANTITY_TO as CATALOG_QUANTITY_TO_3, 'ZAKUPOCHNYEYUNIMANN_+8%' as CATALOG_GROUP_NAME_3, 'N' as CATALOG_CAN_ACCESS_3, 'N' as CATALOG_CAN_BUY_3, CAT_P3.EXTRA_ID as CATALOG_EXTRA_ID_3, CAT_P4.ID as CATALOG_PRICE_ID_4, CAT_P4.CATALOG_GROUP_ID as CATALOG_GROUP_ID_4, CAT_P4.PRICE as CATALOG_PRICE_4, CAT_P4.CURRENCY as CATALOG_CURRENCY_4, CAT_P4.QUANTITY_FROM as CATALOG_QUANTITY_FROM_4, CAT_P4.QUANTITY_TO as CATALOG_QUANTITY_TO_4, 'ZAKUPOCHNYEYUNIMANN_+10%' as CATALOG_GROUP_NAME_4, 'N' as CATALOG_CAN_ACCESS_4, 'N' as CATALOG_CAN_BUY_4, CAT_P4.EXTRA_ID as CATALOG_EXTRA_ID_4, CAT_P5.ID as CATALOG_PRICE_ID_5, CAT_P5.CATALOG_GROUP_ID as CATALOG_GROUP_ID_5, CAT_P5.PRICE as CATALOG_PRICE_5, CAT_P5.CURRENCY as CATALOG_CURRENCY_5, CAT_P5.QUANTITY_FROM as CATALOG_QUANTITY_FROM_5, CAT_P5.QUANTITY_TO as CATALOG_QUANTITY_TO_5, 'ZAKUPOCHNYEYUNIMANN_+12%' as CATALOG_GROUP_NAME_5, 'N' as CATALOG_CAN_ACCESS_5, 'N' as CATALOG_CAN_BUY_5, CAT_P5.EXTRA_ID as CATALOG_EXTRA_ID_5, CAT_P6.ID as CATALOG_PRICE_ID_6, CAT_P6.CATALOG_GROUP_ID as CATALOG_GROUP_ID_6, CAT_P6.PRICE as CATALOG_PRICE_6, CAT_P6.CURRENCY as CATALOG_CURRENCY_6, CAT_P6.QUANTITY_FROM as CATALOG_QUANTITY_FROM_6, CAT_P6.QUANTITY_TO as CATALOG_QUANTITY_TO_6, 'ZAKUPOCHNYEYUNIMANN_+15%' as CATALOG_GROUP_NAME_6, 'N' as CATALOG_CAN_ACCESS_6, 'N' as CATALOG_CAN_BUY_6, CAT_P6.EXTRA_ID as CATALOG_EXTRA_ID_6, CAT_P7.ID as CATALOG_PRICE_ID_7, CAT_P7.CATALOG_GROUP_ID as CATALOG_GROUP_ID_7, CAT_P7.PRICE as CATALOG_PRICE_7, CAT_P7.CURRENCY as CATALOG_CURRENCY_7, CAT_P7.QUANTITY_FROM as CATALOG_QUANTITY_FROM_7, CAT_P7.QUANTITY_TO as CATALOG_QUANTITY_TO_7, 'ZAKUPOCHNYEYUNIMANN_+18%' as CATALOG_GROUP_NAME_7, 'N' as CATALOG_CAN_ACCESS_7, 'N' as CATALOG_CAN_BUY_7, CAT_P7.EXTRA_ID as CATALOG_EXTRA_ID_7, CAT_P8.ID as CATALOG_PRICE_ID_8, CAT_P8.CATALOG_GROUP_ID as CATALOG_GROUP_ID_8, CAT_P8.PRICE as CATALOG_PRICE_8, CAT_P8.CURRENCY as CATALOG_CURRENCY_8, CAT_P8.QUANTITY_FROM as CATALOG_QUANTITY_FROM_8, CAT_P8.QUANTITY_TO as CATALOG_QUANTITY_TO_8, 'ZAKUPOCHNYEYUNIMANN_+22%' as CATALOG_GROUP_NAME_8, 'N' as CATALOG_CAN_ACCESS_8, 'N' as CATALOG_CAN_BUY_8, CAT_P8.EXTRA_ID as CATALOG_EXTRA_ID_8, CAT_P9.ID as CATALOG_PRICE_ID_9, CAT_P9.CATALOG_GROUP_ID as CATALOG_GROUP_ID_9, CAT_P9.PRICE as CATALOG_PRICE_9, CAT_P9.CURRENCY as CATALOG_CURRENCY_9, CAT_P9.QUANTITY_FROM as CATALOG_QUANTITY_FROM_9, CAT_P9.QUANTITY_TO as CATALOG_QUANTITY_TO_9, 'ZAKUPOCHNYEYUNIMANN_+35%' as CATALOG_GROUP_NAME_9, 'N' as CATALOG_CAN_ACCESS_9, 'N' as CATALOG_CAN_BUY_9, CAT_P9.EXTRA_ID as CATALOG_EXTRA_ID_9, CAT_P10.ID as CATALOG_PRICE_ID_10, CAT_P10.CATALOG_GROUP_ID as CATALOG_GROUP_ID_10, CAT_P10.PRICE as CATALOG_PRICE_10, CAT_P10.CURRENCY as CATALOG_CURRENCY_10, CAT_P10.QUANTITY_FROM as CATALOG_QUANTITY_FROM_10, CAT_P10.QUANTITY_TO as CATALOG_QUANTITY_TO_10, 'YUNIMANN' as CATALOG_GROUP_NAME_10, 'Y' as CATALOG_CAN_ACCESS_10, 'Y' as CATALOG_CAN_BUY_10, CAT_P10.EXTRA_ID as CATALOG_EXTRA_ID_10, CAT_P11.ID as CATALOG_PRICE_ID_11, CAT_P11.CATALOG_GROUP_ID as CATALOG_GROUP_ID_11, CAT_P11.PRICE as CATALOG_PRICE_11, CAT_P11.CURRENCY as CATALOG_CURRENCY_11, CAT_P11.QUANTITY_FROM as CATALOG_QUANTITY_FROM_11, CAT_P11.QUANTITY_TO as CATALOG_QUANTITY_TO_11, 'YUNIMANN_+6%' as CATALOG_GROUP_NAME_11, 'N' as CATALOG_CAN_ACCESS_11, 'N' as CATALOG_CAN_BUY_11, CAT_P11.EXTRA_ID as CATALOG_EXTRA_ID_11, CAT_P12.ID as CATALOG_PRICE_ID_12, CAT_P12.CATALOG_GROUP_ID as CATALOG_GROUP_ID_12, CAT_P12.PRICE as CATALOG_PRICE_12, CAT_P12.CURRENCY as CATALOG_CURRENCY_12, CAT_P12.QUANTITY_FROM as CATALOG_QUANTITY_FROM_12, CAT_P12.QUANTITY_TO as CATALOG_QUANTITY_TO_12, 'YUNIMANN_+8%' as CATALOG_GROUP_NAME_12, 'N' as CATALOG_CAN_ACCESS_12, 'N' as CATALOG_CAN_BUY_12, CAT_P12.EXTRA_ID as CATALOG_EXTRA_ID_12, CAT_P13.ID as CATALOG_PRICE_ID_13, CAT_P13.CATALOG_GROUP_ID as CATALOG_GROUP_ID_13, CAT_P13.PRICE as CATALOG_PRICE_13, CAT_P13.CURRENCY as CATALOG_CURRENCY_13, CAT_P13.QUANTITY_FROM as CATALOG_QUANTITY_FROM_13, CAT_P13.QUANTITY_TO as CATALOG_QUANTITY_TO_13, 'YUNIMANN_+10%' as CATALOG_GROUP_NAME_13, 'N' as CATALOG_CAN_ACCESS_13, 'N' as CATALOG_CAN_BUY_13, CAT_P13.EXTRA_ID as CATALOG_EXTRA_ID_13, CAT_P14.ID as CATALOG_PRICE_ID_14, CAT_P14.CATALOG_GROUP_ID as CATALOG_GROUP_ID_14, CAT_P14.PRICE as CATALOG_PRICE_14, CAT_P14.CURRENCY as CATALOG_CURRENCY_14, CAT_P14.QUANTITY_FROM as CATALOG_QUANTITY_FROM_14, CAT_P14.QUANTITY_TO as CATALOG_QUANTITY_TO_14, 'YUNIMANN_+12%' as CATALOG_GROUP_NAME_14, 'N' as CATALOG_CAN_ACCESS_14, 'N' as CATALOG_CAN_BUY_14, CAT_P14.EXTRA_ID as CATALOG_EXTRA_ID_14, CAT_P15.ID as CATALOG_PRICE_ID_15, CAT_P15.CATALOG_GROUP_ID as CATALOG_GROUP_ID_15, CAT_P15.PRICE as CATALOG_PRICE_15, CAT_P15.CURRENCY as CATALOG_CURRENCY_15, CAT_P15.QUANTITY_FROM as CATALOG_QUANTITY_FROM_15, CAT_P15.QUANTITY_TO as CATALOG_QUANTITY_TO_15, 'YUNIMANN_+15%' as CATALOG_GROUP_NAME_15, 'N' as CATALOG_CAN_ACCESS_15, 'N' as CATALOG_CAN_BUY_15, CAT_P15.EXTRA_ID as CATALOG_EXTRA_ID_15, CAT_P16.ID as CATALOG_PRICE_ID_16, CAT_P16.CATALOG_GROUP_ID as CATALOG_GROUP_ID_16, CAT_P16.PRICE as CATALOG_PRICE_16, CAT_P16.CURRENCY as CATALOG_CURRENCY_16, CAT_P16.QUANTITY_FROM as CATALOG_QUANTITY_FROM_16, CAT_P16.QUANTITY_TO as CATALOG_QUANTITY_TO_16, 'YUNIMANN_+18%' as CATALOG_GROUP_NAME_16, 'N' as CATALOG_CAN_ACCESS_16, 'N' as CATALOG_CAN_BUY_16, CAT_P16.EXTRA_ID as CATALOG_EXTRA_ID_16, CAT_P17.ID as CATALOG_PRICE_ID_17, CAT_P17.CATALOG_GROUP_ID as CATALOG_GROUP_ID_17, CAT_P17.PRICE as CATALOG_PRICE_17, CAT_P17.CURRENCY as CATALOG_CURRENCY_17, CAT_P17.QUANTITY_FROM as CATALOG_QUANTITY_FROM_17, CAT_P17.QUANTITY_TO as CATALOG_QUANTITY_TO_17, 'YUNIMANN_+22%' as CATALOG_GROUP_NAME_17, 'N' as CATALOG_CAN_ACCESS_17, 'N' as CATALOG_CAN_BUY_17, CAT_P17.EXTRA_ID as CATALOG_EXTRA_ID_17, CAT_P18.ID as CATALOG_PRICE_ID_18, CAT_P18.CATALOG_GROUP_ID as CATALOG_GROUP_ID_18, CAT_P18.PRICE as CATALOG_PRICE_18, CAT_P18.CURRENCY as CATALOG_CURRENCY_18, CAT_P18.QUANTITY_FROM as CATALOG_QUANTITY_FROM_18, CAT_P18.QUANTITY_TO as CATALOG_QUANTITY_TO_18, 'YUNIMANN_+35%' as CATALOG_GROUP_NAME_18, 'N' as CATALOG_CAN_ACCESS_18, 'N' as CATALOG_CAN_BUY_18, CAT_P18.EXTRA_ID as CATALOG_EXTRA_ID_18, CAT_P19.ID as CATALOG_PRICE_ID_19, CAT_P19.CATALOG_GROUP_ID as CATALOG_GROUP_ID_19, CAT_P19.PRICE as CATALOG_PRICE_19, CAT_P19.CURRENCY as CATALOG_CURRENCY_19, CAT_P19.QUANTITY_FROM as CATALOG_QUANTITY_FROM_19, CAT_P19.QUANTITY_TO as CATALOG_QUANTITY_TO_19, 'ZAKUPOCHNYEAVTOMEDON_M_OOO' as CATALOG_GROUP_NAME_19, 'Y' as CATALOG_CAN_ACCESS_19, 'Y' as CATALOG_CAN_BUY_19, CAT_P19.EXTRA_ID as CATALOG_EXTRA_ID_19, CAT_P20.ID as CATALOG_PRICE_ID_20, CAT_P20.CATALOG_GROUP_ID as CATALOG_GROUP_ID_20, CAT_P20.PRICE as CATALOG_PRICE_20, CAT_P20.CURRENCY as CATALOG_CURRENCY_20, CAT_P20.QUANTITY_FROM as CATALOG_QUANTITY_FROM_20, CAT_P20.QUANTITY_TO as CATALOG_QUANTITY_TO_20, 'ZAKUPOCHNYEAVTOMEDON_M_OOO_+6%' as CATALOG_GROUP_NAME_20, 'N' as CATALOG_CAN_ACCESS_20, 'N' as CATALOG_CAN_BUY_20, CAT_P20.EXTRA_ID as CATALOG_EXTRA_ID_20, CAT_P21.ID as CATALOG_PRICE_ID_21, CAT_P21.CATALOG_GROUP_ID as CATALOG_GROUP_ID_21, CAT_P21.PRICE as CATALOG_PRICE_21, CAT_P21.CURRENCY as CATALOG_CURRENCY_21, CAT_P21.QUANTITY_FROM as CATALOG_QUANTITY_FROM_21, CAT_P21.QUANTITY_TO as CATALOG_QUANTITY_TO_21, 'ZAKUPOCHNYEAVTOMEDON_M_OOO_+8%' as CATALOG_GROUP_NAME_21, 'N' as CATALOG_CAN_ACCESS_21, 'N' as CATALOG_CAN_BUY_21, CAT_P21.EXTRA_ID as CATALOG_EXTRA_ID_21, CAT_P22.ID as CATALOG_PRICE_ID_22, CAT_P22.CATALOG_GROUP_ID as CATALOG_GROUP_ID_22, CAT_P22.PRICE as CATALOG_PRICE_22, CAT_P22.CURRENCY as CATALOG_CURRENCY_22, CAT_P22.QUANTITY_FROM as CATALOG_QUANTITY_FROM_22, CAT_P22.QUANTITY_TO as CATALOG_QUANTITY_TO_22, 'ZAKUPOCHNYEAVTOMEDON_M_OOO_+10%' as CATALOG_GROUP_NAME_22, 'N' as CATALOG_CAN_ACCESS_22, 'N' as CATALOG_CAN_BUY_22, CAT_P22.EXTRA_ID as CATALOG_EXTRA_ID_22, CAT_P23.ID as CATALOG_PRICE_ID_23, CAT_P23.CATALOG_GROUP_ID as CATALOG_GROUP_ID_23, CAT_P23.PRICE as CATALOG_PRICE_23, CAT_P23.CURRENCY as CATALOG_CURRENCY_23, CAT_P23.QUANTITY_FROM as CATALOG_QUANTITY_FROM_23, CAT_P23.QUANTITY_TO as CATALOG_QUANTITY_TO_23, 'ZAKUPOCHNYEAVTOMEDON_M_OOO_+12%' as CATALOG_GROUP_NAME_23, 'N' as CATALOG_CAN_ACCESS_23, 'N' as CATALOG_CAN_BUY_23, CAT_P23.EXTRA_ID as CATALOG_EXTRA_ID_23, CAT_P24.ID as CATALOG_PRICE_ID_24, CAT_P24.CATALOG_GROUP_ID as CATALOG_GROUP_ID_24, CAT_P24.PRICE as CATALOG_PRICE_24, CAT_P24.CURRENCY as CATALOG_CURRENCY_24, CAT_P24.QUANTITY_FROM as CATALOG_QUANTITY_FROM_24, CAT_P24.QUANTITY_TO as CATALOG_QUANTITY_TO_24, 'ZAKUPOCHNYEAVTOMEDON_M_OOO_+15%' as CATALOG_GROUP_NAME_24, 'N' as CATALOG_CAN_ACCESS_24, 'N' as CATALOG_CAN_BUY_24, CAT_P24.EXTRA_ID as CATALOG_EXTRA_ID_24, CAT_P25.ID as CATALOG_PRICE_ID_25, CAT_P25.CATALOG_GROUP_ID as CATALOG_GROUP_ID_25, CAT_P25.PRICE as CATALOG_PRICE_25, CAT_P25.CURRENCY as CATALOG_CURRENCY_25, CAT_P25.QUANTITY_FROM as CATALOG_QUANTITY_FROM_25, CAT_P25.QUANTITY_TO as CATALOG_QUANTITY_TO_25, 'ZAKUPOCHNYEAVTOMEDON_M_OOO_+18%' as CATALOG_GROUP_NAME_25, 'N' as CATALOG_CAN_ACCESS_25, 'N' as CATALOG_CAN_BUY_25, CAT_P25.EXTRA_ID as CATALOG_EXTRA_ID_25, CAT_P26.ID as CATALOG_PRICE_ID_26, CAT_P26.CATALOG_GROUP_ID as CATALOG_GROUP_ID_26, CAT_P26.PRICE as CATALOG_PRICE_26, CAT_P26.CURRENCY as CATALOG_CURRENCY_26, CAT_P26.QUANTITY_FROM as CATALOG_QUANTITY_FROM_26, CAT_P26.QUANTITY_TO as CATALOG_QUANTITY_TO_26, 'ZAKUPOCHNYEAVTOMEDON_M_OOO_+22%' as CATALOG_GROUP_NAME_26, 'N' as CATALOG_CAN_ACCESS_26, 'N' as CATALOG_CAN_BUY_26, CAT_P26.EXTRA_ID as CATALOG_EXTRA_ID_26, CAT_P27.ID as CATALOG_PRICE_ID_27, CAT_P27.CATALOG_GROUP_ID as CATALOG_GROUP_ID_27, CAT_P27.PRICE as CATALOG_PRICE_27, CAT_P27.CURRENCY as CATALOG_CURRENCY_27, CAT_P27.QUANTITY_FROM as CATALOG_QUANTITY_FROM_27, CAT_P27.QUANTITY_TO as CATALOG_QUANTITY_TO_27, 'ZAKUPOCHNYEAVTOMEDON_M_OOO_+35%' as CATALOG_GROUP_NAME_27, 'N' as CATALOG_CAN_ACCESS_27, 'N' as CATALOG_CAN_BUY_27, CAT_P27.EXTRA_ID as CATALOG_EXTRA_ID_27, CAT_P28.ID as CATALOG_PRICE_ID_28, CAT_P28.CATALOG_GROUP_ID as CATALOG_GROUP_ID_28, CAT_P28.PRICE as CATALOG_PRICE_28, CAT_P28.CURRENCY as CATALOG_CURRENCY_28, CAT_P28.QUANTITY_FROM as CATALOG_QUANTITY_FROM_28, CAT_P28.QUANTITY_TO as CATALOG_QUANTITY_TO_28, 'ZAKUPOCHNYESHATE_M_PLYUS_OOO' as CATALOG_GROUP_NAME_28, 'Y' as CATALOG_CAN_ACCESS_28, 'Y' as CATALOG_CAN_BUY_28, CAT_P28.EXTRA_ID as CATALOG_EXTRA_ID_28, CAT_P29.ID as CATALOG_PRICE_ID_29, CAT_P29.CATALOG_GROUP_ID as CATALOG_GROUP_ID_29, CAT_P29.PRICE as CATALOG_PRICE_29, CAT_P29.CURRENCY as CATALOG_CURRENCY_29, CAT_P29.QUANTITY_FROM as CATALOG_QUANTITY_FROM_29, CAT_P29.QUANTITY_TO as CATALOG_QUANTITY_TO_29, 'ZAKUPOCHNYESHATE_M_PLYUS_OOO_+6%' as CATALOG_GROUP_NAME_29, 'N' as CATALOG_CAN_ACCESS_29, 'N' as CATALOG_CAN_BUY_29, CAT_P29.EXTRA_ID as CATALOG_EXTRA_ID_29, CAT_P30.ID as CATALOG_PRICE_ID_30, CAT_P30.CATALOG_GROUP_ID as CATALOG_GROUP_ID_30, CAT_P30.PRICE as CATALOG_PRICE_30, CAT_P30.CURRENCY as CATALOG_CURRENCY_30, CAT_P30.QUANTITY_FROM as CATALOG_QUANTITY_FROM_30, CAT_P30.QUANTITY_TO as CATALOG_QUANTITY_TO_30, 'ZAKUPOCHNYESHATE_M_PLYUS_OOO_+8%' as CATALOG_GROUP_NAME_30, 'N' as CATALOG_CAN_ACCESS_30, 'N' as CATALOG_CAN_BUY_30, CAT_P30.EXTRA_ID as CATALOG_EXTRA_ID_30, CAT_P31.ID as CATALOG_PRICE_ID_31, CAT_P31.CATALOG_GROUP_ID as CATALOG_GROUP_ID_31, CAT_P31.PRICE as CATALOG_PRICE_31, CAT_P31.CURRENCY as CATALOG_CURRENCY_31, CAT_P31.QUANTITY_FROM as CATALOG_QUANTITY_FROM_31, CAT_P31.QUANTITY_TO as CATALOG_QUANTITY_TO_31, 'ZAKUPOCHNYESHATE_M_PLYUS_OOO_+10%' as CATALOG_GROUP_NAME_31, 'N' as CATALOG_CAN_ACCESS_31, 'N' as CATALOG_CAN_BUY_31, CAT_P31.EXTRA_ID as CATALOG_EXTRA_ID_31, CAT_P32.ID as CATALOG_PRICE_ID_32, CAT_P32.CATALOG_GROUP_ID as CATALOG_GROUP_ID_32, CAT_P32.PRICE as CATALOG_PRICE_32, CAT_P32.CURRENCY as CATALOG_CURRENCY_32, CAT_P32.QUANTITY_FROM as CATALOG_QUANTITY_FROM_32, CAT_P32.QUANTITY_TO as CATALOG_QUANTITY_TO_32, 'ZAKUPOCHNYESHATE_M_PLYUS_OOO_+12%' as CATALOG_GROUP_NAME_32, 'Y' as CATALOG_CAN_ACCESS_32, 'Y' as CATALOG_CAN_BUY_32, CAT_P32.EXTRA_ID as CATALOG_EXTRA_ID_32, CAT_P33.ID as CATALOG_PRICE_ID_33, CAT_P33.CATALOG_GROUP_ID as CATALOG_GROUP_ID_33, CAT_P33.PRICE as CATALOG_PRICE_33, CAT_P33.CURRENCY as CATALOG_CURRENCY_33, CAT_P33.QUANTITY_FROM as CATALOG_QUANTITY_FROM_33, CAT_P33.QUANTITY_TO as CATALOG_QUANTITY_TO_33, 'ZAKUPOCHNYESHATE_M_PLYUS_OOO_+15%' as CATALOG_GROUP_NAME_33, 'N' as CATALOG_CAN_ACCESS_33, 'N' as CATALOG_CAN_BUY_33, CAT_P33.EXTRA_ID as CATALOG_EXTRA_ID_33, CAT_P34.ID as CATALOG_PRICE_ID_34, CAT_P34.CATALOG_GROUP_ID as CATALOG_GROUP_ID_34, CAT_P34.PRICE as CATALOG_PRICE_34, CAT_P34.CURRENCY as CATALOG_CURRENCY_34, CAT_P34.QUANTITY_FROM as CATALOG_QUANTITY_FROM_34, CAT_P34.QUANTITY_TO as CATALOG_QUANTITY_TO_34, 'ZAKUPOCHNYESHATE_M_PLYUS_OOO_+18%' as CATALOG_GROUP_NAME_34, 'N' as CATALOG_CAN_ACCESS_34, 'N' as CATALOG_CAN_BUY_34, CAT_P34.EXTRA_ID as CATALOG_EXTRA_ID_34, CAT_P35.ID as CATALOG_PRICE_ID_35, CAT_P35.CATALOG_GROUP_ID as CATALOG_GROUP_ID_35, CAT_P35.PRICE as CATALOG_PRICE_35, CAT_P35.CURRENCY as CATALOG_CURRENCY_35, CAT_P35.QUANTITY_FROM as CATALOG_QUANTITY_FROM_35, CAT_P35.QUANTITY_TO as CATALOG_QUANTITY_TO_35, 'ZAKUPOCHNYESHATE_M_PLYUS_OOO_+22%' as CATALOG_GROUP_NAME_35, 'N' as CATALOG_CAN_ACCESS_35, 'N' as CATALOG_CAN_BUY_35, CAT_P35.EXTRA_ID as CATALOG_EXTRA_ID_35, CAT_P36.ID as CATALOG_PRICE_ID_36, CAT_P36.CATALOG_GROUP_ID as CATALOG_GROUP_ID_36, CAT_P36.PRICE as CATALOG_PRICE_36, CAT_P36.CURRENCY as CATALOG_CURRENCY_36, CAT_P36.QUANTITY_FROM as CATALOG_QUANTITY_FROM_36, CAT_P36.QUANTITY_TO as CATALOG_QUANTITY_TO_36, 'ZAKUPOCHNYESHATE_M_PLYUS_OOO_+35%' as CATALOG_GROUP_NAME_36, 'N' as CATALOG_CAN_ACCESS_36, 'N' as CATALOG_CAN_BUY_36, CAT_P36.EXTRA_ID as CATALOG_EXTRA_ID_36, CAT_P37.ID as CATALOG_PRICE_ID_37, CAT_P37.CATALOG_GROUP_ID as CATALOG_GROUP_ID_37, CAT_P37.PRICE as CATALOG_PRICE_37, CAT_P37.CURRENCY as CATALOG_CURRENCY_37, CAT_P37.QUANTITY_FROM as CATALOG_QUANTITY_FROM_37, CAT_P37.QUANTITY_TO as CATALOG_QUANTITY_TO_37, 'ZAKUPOCHNYEAVTOTSENTR_ZLATA_OOO' as CATALOG_GROUP_NAME_37, 'Y' as CATALOG_CAN_ACCESS_37, 'Y' as CATALOG_CAN_BUY_37, CAT_P37.EXTRA_ID as CATALOG_EXTRA_ID_37, CAT_P38.ID as CATALOG_PRICE_ID_38, CAT_P38.CATALOG_GROUP_ID as CATALOG_GROUP_ID_38, CAT_P38.PRICE as CATALOG_PRICE_38, CAT_P38.CURRENCY as CATALOG_CURRENCY_38, CAT_P38.QUANTITY_FROM as CATALOG_QUANTITY_FROM_38, CAT_P38.QUANTITY_TO as CATALOG_QUANTITY_TO_38, 'ZAKUPOCHNYEAVTOTSENTR_ZLATA_OOO_+6%' as CATALOG_GROUP_NAME_38, 'N' as CATALOG_CAN_ACCESS_38, 'N' as CATALOG_CAN_BUY_38, CAT_P38.EXTRA_ID as CATALOG_EXTRA_ID_38, CAT_P39.ID as CATALOG_PRICE_ID_39, CAT_P39.CATALOG_GROUP_ID as CATALOG_GROUP_ID_39, CAT_P39.PRICE as CATALOG_PRICE_39, CAT_P39.CURRENCY as CATALOG_CURRENCY_39, CAT_P39.QUANTITY_FROM as CATALOG_QUANTITY_FROM_39, CAT_P39.QUANTITY_TO as CATALOG_QUANTITY_TO_39, 'ZAKUPOCHNYEAVTOTSENTR_ZLATA_OOO_+8%' as CATALOG_GROUP_NAME_39, 'Y' as CATALOG_CAN_ACCESS_39, 'Y' as CATALOG_CAN_BUY_39, CAT_P39.EXTRA_ID as CATALOG_EXTRA_ID_39, CAT_P40.ID as CATALOG_PRICE_ID_40, CAT_P40.CATALOG_GROUP_ID as CATALOG_GROUP_ID_40, CAT_P40.PRICE as CATALOG_PRICE_40, CAT_P40.CURRENCY as CATALOG_CURRENCY_40, CAT_P40.QUANTITY_FROM as CATALOG_QUANTITY_FROM_40, CAT_P40.QUANTITY_TO as CATALOG_QUANTITY_TO_40, 'ZAKUPOCHNYEAVTOTSENTR_ZLATA_OOO_+10%' as CATALOG_GROUP_NAME_40, 'Y' as CATALOG_CAN_ACCESS_40, 'Y' as CATALOG_CAN_BUY_40, CAT_P40.EXTRA_ID as CATALOG_EXTRA_ID_40, CAT_P41.ID as CATALOG_PRICE_ID_41, CAT_P41.CATALOG_GROUP_ID as CATALOG_GROUP_ID_41, CAT_P41.PRICE as CATALOG_PRICE_41, CAT_P41.CURRENCY as CATALOG_CURRENCY_41, CAT_P41.QUANTITY_FROM as CATALOG_QUANTITY_FROM_41, CAT_P41.QUANTITY_TO as CATALOG_QUANTITY_TO_41, 'ZAKUPOCHNYEAVTOTSENTR_ZLATA_OOO_+12%' as CATALOG_GROUP_NAME_41, 'N' as CATALOG_CAN_ACCESS_41, 'N' as CATALOG_CAN_BUY_41, CAT_P41.EXTRA_ID as CATALOG_EXTRA_ID_41, CAT_P42.ID as CATALOG_PRICE_ID_42, CAT_P42.CATALOG_GROUP_ID as CATALOG_GROUP_ID_42, CAT_P42.PRICE as CATALOG_PRICE_42, CAT_P42.CURRENCY as CATALOG_CURRENCY_42, CAT_P42.QUANTITY_FROM as CATALOG_QUANTITY_FROM_42, CAT_P42.QUANTITY_TO as CATALOG_QUANTITY_TO_42, 'ZAKUPOCHNYEAVTOTSENTR_ZLATA_OOO_+15%' as CATALOG_GROUP_NAME_42, 'N' as CATALOG_CAN_ACCESS_42, 'N' as CATALOG_CAN_BUY_42, CAT_P42.EXTRA_ID as CATALOG_EXTRA_ID_42, CAT_P43.ID as CATALOG_PRICE_ID_43, CAT_P43.CATALOG_GROUP_ID as CATALOG_GROUP_ID_43, CAT_P43.PRICE as CATALOG_PRICE_43, CAT_P43.CURRENCY as CATALOG_CURRENCY_43, CAT_P43.QUANTITY_FROM as CATALOG_QUANTITY_FROM_43, CAT_P43.QUANTITY_TO as CATALOG_QUANTITY_TO_43, 'ZAKUPOCHNYEAVTOTSENTR_ZLATA_OOO_+18%' as CATALOG_GROUP_NAME_43, 'N' as CATALOG_CAN_ACCESS_43, 'N' as CATALOG_CAN_BUY_43, CAT_P43.EXTRA_ID as CATALOG_EXTRA_ID_43, CAT_P44.ID as CATALOG_PRICE_ID_44, CAT_P44.CATALOG_GROUP_ID as CATALOG_GROUP_ID_44, CAT_P44.PRICE as CATALOG_PRICE_44, CAT_P44.CURRENCY as CATALOG_CURRENCY_44, CAT_P44.QUANTITY_FROM as CATALOG_QUANTITY_FROM_44, CAT_P44.QUANTITY_TO as CATALOG_QUANTITY_TO_44, 'ZAKUPOCHNYEAVTOTSENTR_ZLATA_OOO_+22%' as CATALOG_GROUP_NAME_44, 'N' as CATALOG_CAN_ACCESS_44, 'N' as CATALOG_CAN_BUY_44, CAT_P44.EXTRA_ID as CATALOG_EXTRA_ID_44, CAT_P45.ID as CATALOG_PRICE_ID_45, CAT_P45.CATALOG_GROUP_ID as CATALOG_GROUP_ID_45, CAT_P45.PRICE as CATALOG_PRICE_45, CAT_P45.CURRENCY as CATALOG_CURRENCY_45, CAT_P45.QUANTITY_FROM as CATALOG_QUANTITY_FROM_45, CAT_P45.QUANTITY_TO as CATALOG_QUANTITY_TO_45, 'ZAKUPOCHNYEAVTOTSENTR_ZLATA_OOO_+35%' as CATALOG_GROUP_NAME_45, 'N' as CATALOG_CAN_ACCESS_45, 'N' as CATALOG_CAN_BUY_45, CAT_P45.EXTRA_ID as CATALOG_EXTRA_ID_45, CAT_PR.QUANTITY as CATALOG_QUANTITY, IF (CAT_PR.QUANTITY_TRACE = 'D', 'N', CAT_PR.QUANTITY_TRACE) as CATALOG_QUANTITY_TRACE, CAT_PR.QUANTITY_TRACE as CATALOG_QUANTITY_TRACE_ORIG, IF (CAT_PR.CAN_BUY_ZERO = 'D', 'Y', CAT_PR.CAN_BUY_ZERO) as CATALOG_CAN_BUY_ZERO, IF (CAT_PR.NEGATIVE_AMOUNT_TRACE = 'D', 'Y', CAT_PR.NEGATIVE_AMOUNT_TRACE) as CATALOG_NEGATIVE_AMOUNT_TRACE, IF ( CAT_PR.QUANTITY > 0 OR IF (CAT_PR.QUANTITY_TRACE = 'D', 'N', CAT_PR.QUANTITY_TRACE) = 'N' OR IF (CAT_PR.CAN_BUY_ZERO = 'D', 'Y', CAT_PR.CAN_BUY_ZERO) = 'Y', 'Y', 'N' ) as CATALOG_AVAILABLE, 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, CAT_PR.PURCHASING_PRICE as CATALOG_PURCHASING_PRICE, CAT_PR.PURCHASING_CURRENCY as CATALOG_PURCHASING_CURRENCY 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 LEFT JOIN b_iblock_property FP0 ON FP0.IBLOCK_ID = B.ID AND FP0.CODE='CML2_DAYS_DELIVERY' LEFT JOIN b_iblock_property FP1 ON FP1.IBLOCK_ID = B.ID AND FP1.CODE='INDEKS' LEFT JOIN b_iblock_property FP2 ON FP2.IBLOCK_ID = B.ID AND FP2.CODE='BREND' 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_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_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_price CAT_P4 ON (CAT_P4.PRODUCT_ID = BE.ID AND CAT_P4.CATALOG_GROUP_ID = 4) AND ((CAT_P4.QUANTITY_FROM <= 1 OR CAT_P4.QUANTITY_FROM IS NULL) AND (CAT_P4.QUANTITY_TO >= 1 OR CAT_P4.QUANTITY_TO IS NULL)) LEFT JOIN b_catalog_price CAT_P5 ON (CAT_P5.PRODUCT_ID = BE.ID AND CAT_P5.CATALOG_GROUP_ID = 5) AND ((CAT_P5.QUANTITY_FROM <= 1 OR CAT_P5.QUANTITY_FROM IS NULL) AND (CAT_P5.QUANTITY_TO >= 1 OR CAT_P5.QUANTITY_TO IS NULL)) LEFT JOIN b_catalog_price CAT_P6 ON (CAT_P6.PRODUCT_ID = BE.ID AND CAT_P6.CATALOG_GROUP_ID = 6) AND ((CAT_P6.QUANTITY_FROM <= 1 OR CAT_P6.QUANTITY_FROM IS NULL) AND (CAT_P6.QUANTITY_TO >= 1 OR CAT_P6.QUANTITY_TO IS NULL)) LEFT JOIN b_catalog_price CAT_P7 ON (CAT_P7.PRODUCT_ID = BE.ID AND CAT_P7.CATALOG_GROUP_ID = 7) AND ((CAT_P7.QUANTITY_FROM <= 1 OR CAT_P7.QUANTITY_FROM IS NULL) AND (CAT_P7.QUANTITY_TO >= 1 OR CAT_P7.QUANTITY_TO IS NULL)) LEFT JOIN b_catalog_price CAT_P8 ON (CAT_P8.PRODUCT_ID = BE.ID AND CAT_P8.CATALOG_GROUP_ID = 8) AND ((CAT_P8.QUANTITY_FROM <= 1 OR CAT_P8.QUANTITY_FROM IS NULL) AND (CAT_P8.QUANTITY_TO >= 1 OR CAT_P8.QUANTITY_TO IS NULL)) LEFT JOIN b_catalog_price CAT_P9 ON (CAT_P9.PRODUCT_ID = BE.ID AND CAT_P9.CATALOG_GROUP_ID = 9) AND ((CAT_P9.QUANTITY_FROM <= 1 OR CAT_P9.QUANTITY_FROM IS NULL) AND (CAT_P9.QUANTITY_TO >= 1 OR CAT_P9.QUANTITY_TO IS NULL)) LEFT JOIN b_catalog_price CAT_P10 ON (CAT_P10.PRODUCT_ID = BE.ID AND CAT_P10.CATALOG_GROUP_ID = 10) AND ((CAT_P10.QUANTITY_FROM <= 1 OR CAT_P10.QUANTITY_FROM IS NULL) AND (CAT_P10.QUANTITY_TO >= 1 OR CAT_P10.QUANTITY_TO IS NULL)) LEFT JOIN b_catalog_price CAT_P11 ON (CAT_P11.PRODUCT_ID = BE.ID AND CAT_P11.CATALOG_GROUP_ID = 11) AND ((CAT_P11.QUANTITY_FROM <= 1 OR CAT_P11.QUANTITY_FROM IS NULL) AND (CAT_P11.QUANTITY_TO >= 1 OR CAT_P11.QUANTITY_TO IS NULL)) LEFT JOIN b_catalog_price CAT_P12 ON (CAT_P12.PRODUCT_ID = BE.ID AND CAT_P12.CATALOG_GROUP_ID = 12) AND ((CAT_P12.QUANTITY_FROM <= 1 OR CAT_P12.QUANTITY_FROM IS NULL) AND (CAT_P12.QUANTITY_TO >= 1 OR CAT_P12.QUANTITY_TO IS NULL)) LEFT JOIN b_catalog_price CAT_P13 ON (CAT_P13.PRODUCT_ID = BE.ID AND CAT_P13.CATALOG_GROUP_ID = 13) AND ((CAT_P13.QUANTITY_FROM <= 1 OR CAT_P13.QUANTITY_FROM IS NULL) AND (CAT_P13.QUANTITY_TO >= 1 OR CAT_P13.QUANTITY_TO IS NULL)) LEFT JOIN b_catalog_price CAT_P14 ON (CAT_P14.PRODUCT_ID = BE.ID AND CAT_P14.CATALOG_GROUP_ID = 14) AND ((CAT_P14.QUANTITY_FROM <= 1 OR CAT_P14.QUANTITY_FROM IS NULL) AND (CAT_P14.QUANTITY_TO >= 1 OR CAT_P14.QUANTITY_TO IS NULL)) LEFT JOIN b_catalog_price CAT_P15 ON (CAT_P15.PRODUCT_ID = BE.ID AND CAT_P15.CATALOG_GROUP_ID = 15) AND ((CAT_P15.QUANTITY_FROM <= 1 OR CAT_P15.QUANTITY_FROM IS NULL) AND (CAT_P15.QUANTITY_TO >= 1 OR CAT_P15.QUANTITY_TO IS NULL)) LEFT JOIN b_catalog_price CAT_P16 ON (CAT_P16.PRODUCT_ID = BE.ID AND CAT_P16.CATALOG_GROUP_ID = 16) AND ((CAT_P16.QUANTITY_FROM <= 1 OR CAT_P16.QUANTITY_FROM IS NULL) AND (CAT_P16.QUANTITY_TO >= 1 OR CAT_P16.QUANTITY_TO IS NULL)) LEFT JOIN b_catalog_price CAT_P17 ON (CAT_P17.PRODUCT_ID = BE.ID AND CAT_P17.CATALOG_GROUP_ID = 17) AND ((CAT_P17.QUANTITY_FROM <= 1 OR CAT_P17.QUANTITY_FROM IS NULL) AND (CAT_P17.QUANTITY_TO >= 1 OR CAT_P17.QUANTITY_TO IS NULL)) LEFT JOIN b_catalog_price CAT_P18 ON (CAT_P18.PRODUCT_ID = BE.ID AND CAT_P18.CATALOG_GROUP_ID = 18) AND ((CAT_P18.QUANTITY_FROM <= 1 OR CAT_P18.QUANTITY_FROM IS NULL) AND (CAT_P18.QUANTITY_TO >= 1 OR CAT_P18.QUANTITY_TO IS NULL)) LEFT JOIN b_catalog_price CAT_P19 ON (CAT_P19.PRODUCT_ID = BE.ID AND CAT_P19.CATALOG_GROUP_ID = 19) AND ((CAT_P19.QUANTITY_FROM <= 1 OR CAT_P19.QUANTITY_FROM IS NULL) AND (CAT_P19.QUANTITY_TO >= 1 OR CAT_P19.QUANTITY_TO IS NULL)) LEFT JOIN b_catalog_price CAT_P20 ON (CAT_P20.PRODUCT_ID = BE.ID AND CAT_P20.CATALOG_GROUP_ID = 20) AND ((CAT_P20.QUANTITY_FROM <= 1 OR CAT_P20.QUANTITY_FROM IS NULL) AND (CAT_P20.QUANTITY_TO >= 1 OR CAT_P20.QUANTITY_TO IS NULL)) LEFT JOIN b_catalog_price CAT_P21 ON (CAT_P21.PRODUCT_ID = BE.ID AND CAT_P21.CATALOG_GROUP_ID = 21) AND ((CAT_P21.QUANTITY_FROM <= 1 OR CAT_P21.QUANTITY_FROM IS NULL) AND (CAT_P21.QUANTITY_TO >= 1 OR CAT_P21.QUANTITY_TO IS NULL)) LEFT JOIN b_catalog_price CAT_P22 ON (CAT_P22.PRODUCT_ID = BE.ID AND CAT_P22.CATALOG_GROUP_ID = 22) AND ((CAT_P22.QUANTITY_FROM <= 1 OR CAT_P22.QUANTITY_FROM IS NULL) AND (CAT_P22.QUANTITY_TO >= 1 OR CAT_P22.QUANTITY_TO IS NULL)) LEFT JOIN b_catalog_price CAT_P23 ON (CAT_P23.PRODUCT_ID = BE.ID AND CAT_P23.CATALOG_GROUP_ID = 23) AND ((CAT_P23.QUANTITY_FROM <= 1 OR CAT_P23.QUANTITY_FROM IS NULL) AND (CAT_P23.QUANTITY_TO >= 1 OR CAT_P23.QUANTITY_TO IS NULL)) LEFT JOIN b_catalog_price CAT_P24 ON (CAT_P24.PRODUCT_ID = BE.ID AND CAT_P24.CATALOG_GROUP_ID = 24) AND ((CAT_P24.QUANTITY_FROM <= 1 OR CAT_P24.QUANTITY_FROM IS NULL) AND (CAT_P24.QUANTITY_TO >= 1 OR CAT_P24.QUANTITY_TO IS NULL)) LEFT JOIN b_catalog_price CAT_P25 ON (CAT_P25.PRODUCT_ID = BE.ID AND CAT_P25.CATALOG_GROUP_ID = 25) AND ((CAT_P25.QUANTITY_FROM <= 1 OR CAT_P25.QUANTITY_FROM IS NULL) AND (CAT_P25.QUANTITY_TO >= 1 OR CAT_P25.QUANTITY_TO IS NULL)) LEFT JOIN b_catalog_price CAT_P26 ON (CAT_P26.PRODUCT_ID = BE.ID AND CAT_P26.CATALOG_GROUP_ID = 26) AND ((CAT_P26.QUANTITY_FROM <= 1 OR CAT_P26.QUANTITY_FROM IS NULL) AND (CAT_P26.QUANTITY_TO >= 1 OR CAT_P26.QUANTITY_TO IS NULL)) LEFT JOIN b_catalog_price CAT_P27 ON (CAT_P27.PRODUCT_ID = BE.ID AND CAT_P27.CATALOG_GROUP_ID = 27) AND ((CAT_P27.QUANTITY_FROM <= 1 OR CAT_P27.QUANTITY_FROM IS NULL) AND (CAT_P27.QUANTITY_TO >= 1 OR CAT_P27.QUANTITY_TO IS NULL)) LEFT JOIN b_catalog_price CAT_P28 ON (CAT_P28.PRODUCT_ID = BE.ID AND CAT_P28.CATALOG_GROUP_ID = 28) AND ((CAT_P28.QUANTITY_FROM <= 1 OR CAT_P28.QUANTITY_FROM IS NULL) AND (CAT_P28.QUANTITY_TO >= 1 OR CAT_P28.QUANTITY_TO IS NULL)) LEFT JOIN b_catalog_price CAT_P29 ON (CAT_P29.PRODUCT_ID = BE.ID AND CAT_P29.CATALOG_GROUP_ID = 29) AND ((CAT_P29.QUANTITY_FROM <= 1 OR CAT_P29.QUANTITY_FROM IS NULL) AND (CAT_P29.QUANTITY_TO >= 1 OR CAT_P29.QUANTITY_TO IS NULL)) LEFT JOIN b_catalog_price CAT_P30 ON (CAT_P30.PRODUCT_ID = BE.ID AND CAT_P30.CATALOG_GROUP_ID = 30) AND ((CAT_P30.QUANTITY_FROM <= 1 OR CAT_P30.QUANTITY_FROM IS NULL) AND (CAT_P30.QUANTITY_TO >= 1 OR CAT_P30.QUANTITY_TO IS NULL)) LEFT JOIN b_catalog_price CAT_P31 ON (CAT_P31.PRODUCT_ID = BE.ID AND CAT_P31.CATALOG_GROUP_ID = 31) AND ((CAT_P31.QUANTITY_FROM <= 1 OR CAT_P31.QUANTITY_FROM IS NULL) AND (CAT_P31.QUANTITY_TO >= 1 OR CAT_P31.QUANTITY_TO IS NULL)) LEFT JOIN b_catalog_price CAT_P32 ON (CAT_P32.PRODUCT_ID = BE.ID AND CAT_P32.CATALOG_GROUP_ID = 32) AND ((CAT_P32.QUANTITY_FROM <= 1 OR CAT_P32.QUANTITY_FROM IS NULL) AND (CAT_P32.QUANTITY_TO >= 1 OR CAT_P32.QUANTITY_TO IS NULL)) LEFT JOIN b_catalog_price CAT_P33 ON (CAT_P33.PRODUCT_ID = BE.ID AND CAT_P33.CATALOG_GROUP_ID = 33) AND ((CAT_P33.QUANTITY_FROM <= 1 OR CAT_P33.QUANTITY_FROM IS NULL) AND (CAT_P33.QUANTITY_TO >= 1 OR CAT_P33.QUANTITY_TO IS NULL)) LEFT JOIN b_catalog_price CAT_P34 ON (CAT_P34.PRODUCT_ID = BE.ID AND CAT_P34.CATALOG_GROUP_ID = 34) AND ((CAT_P34.QUANTITY_FROM <= 1 OR CAT_P34.QUANTITY_FROM IS NULL) AND (CAT_P34.QUANTITY_TO >= 1 OR CAT_P34.QUANTITY_TO IS NULL)) LEFT JOIN b_catalog_price CAT_P35 ON (CAT_P35.PRODUCT_ID = BE.ID AND CAT_P35.CATALOG_GROUP_ID = 35) AND ((CAT_P35.QUANTITY_FROM <= 1 OR CAT_P35.QUANTITY_FROM IS NULL) AND (CAT_P35.QUANTITY_TO >= 1 OR CAT_P35.QUANTITY_TO IS NULL)) LEFT JOIN b_catalog_price CAT_P36 ON (CAT_P36.PRODUCT_ID = BE.ID AND CAT_P36.CATALOG_GROUP_ID = 36) AND ((CAT_P36.QUANTITY_FROM <= 1 OR CAT_P36.QUANTITY_FROM IS NULL) AND (CAT_P36.QUANTITY_TO >= 1 OR CAT_P36.QUANTITY_TO IS NULL)) LEFT JOIN b_catalog_price CAT_P37 ON (CAT_P37.PRODUCT_ID = BE.ID AND CAT_P37.CATALOG_GROUP_ID = 37) AND ((CAT_P37.QUANTITY_FROM <= 1 OR CAT_P37.QUANTITY_FROM IS NULL) AND (CAT_P37.QUANTITY_TO >= 1 OR CAT_P37.QUANTITY_TO IS NULL)) LEFT JOIN b_catalog_price CAT_P38 ON (CAT_P38.PRODUCT_ID = BE.ID AND CAT_P38.CATALOG_GROUP_ID = 38) AND ((CAT_P38.QUANTITY_FROM <= 1 OR CAT_P38.QUANTITY_FROM IS NULL) AND (CAT_P38.QUANTITY_TO >= 1 OR CAT_P38.QUANTITY_TO IS NULL)) LEFT JOIN b_catalog_price CAT_P39 ON (CAT_P39.PRODUCT_ID = BE.ID AND CAT_P39.CATALOG_GROUP_ID = 39) AND ((CAT_P39.QUANTITY_FROM <= 1 OR CAT_P39.QUANTITY_FROM IS NULL) AND (CAT_P39.QUANTITY_TO >= 1 OR CAT_P39.QUANTITY_TO IS NULL)) LEFT JOIN b_catalog_price CAT_P40 ON (CAT_P40.PRODUCT_ID = BE.ID AND CAT_P40.CATALOG_GROUP_ID = 40) AND ((CAT_P40.QUANTITY_FROM <= 1 OR CAT_P40.QUANTITY_FROM IS NULL) AND (CAT_P40.QUANTITY_TO >= 1 OR CAT_P40.QUANTITY_TO IS NULL)) LEFT JOIN b_catalog_price CAT_P41 ON (CAT_P41.PRODUCT_ID = BE.ID AND CAT_P41.CATALOG_GROUP_ID = 41) AND ((CAT_P41.QUANTITY_FROM <= 1 OR CAT_P41.QUANTITY_FROM IS NULL) AND (CAT_P41.QUANTITY_TO >= 1 OR CAT_P41.QUANTITY_TO IS NULL)) LEFT JOIN b_catalog_price CAT_P42 ON (CAT_P42.PRODUCT_ID = BE.ID AND CAT_P42.CATALOG_GROUP_ID = 42) AND ((CAT_P42.QUANTITY_FROM <= 1 OR CAT_P42.QUANTITY_FROM IS NULL) AND (CAT_P42.QUANTITY_TO >= 1 OR CAT_P42.QUANTITY_TO IS NULL)) LEFT JOIN b_catalog_price CAT_P43 ON (CAT_P43.PRODUCT_ID = BE.ID AND CAT_P43.CATALOG_GROUP_ID = 43) AND ((CAT_P43.QUANTITY_FROM <= 1 OR CAT_P43.QUANTITY_FROM IS NULL) AND (CAT_P43.QUANTITY_TO >= 1 OR CAT_P43.QUANTITY_TO IS NULL)) LEFT JOIN b_catalog_price CAT_P44 ON (CAT_P44.PRODUCT_ID = BE.ID AND CAT_P44.CATALOG_GROUP_ID = 44) AND ((CAT_P44.QUANTITY_FROM <= 1 OR CAT_P44.QUANTITY_FROM IS NULL) AND (CAT_P44.QUANTITY_TO >= 1 OR CAT_P44.QUANTITY_TO IS NULL)) LEFT JOIN b_catalog_price CAT_P45 ON (CAT_P45.PRODUCT_ID = BE.ID AND CAT_P45.CATALOG_GROUP_ID = 45) AND ((CAT_P45.QUANTITY_FROM <= 1 OR CAT_P45.QUANTITY_FROM IS NULL) AND (CAT_P45.QUANTITY_TO >= 1 OR CAT_P45.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
