• Акции

MySQL Query Error: SELECT 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 FROM 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,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_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, 'Скидка 25%' as CATALOG_GROUP_NAME_8, 'Y' 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, 'Цена для дилеров' 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, 'Розничная, руб' 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_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, 'Закупочная' as CATALOG_GROUP_NAME_12, 'Y' as CATALOG_CAN_ACCESS_12, 'Y' 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, 'Оптовая, руб (Дилер)' 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, 'Закупочная EUR' as CATALOG_GROUP_NAME_14, 'Y' as CATALOG_CAN_ACCESS_14, 'Y' 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, 'Розничная, (EUR)' as CATALOG_GROUP_NAME_15, 'Y' as CATALOG_CAN_ACCESS_15, 'Y' 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, 'Себестоимость, (EUR)' as CATALOG_GROUP_NAME_16, 'Y' as CATALOG_CAN_ACCESS_16, 'Y' 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, 'Акция' as CATALOG_GROUP_NAME_17, 'Y' as CATALOG_CAN_ACCESS_17, 'Y' 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, '' 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, '' as CATALOG_GROUP_NAME_19, 'N' as CATALOG_CAN_ACCESS_19, 'N' 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, '' 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, '' 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, '' 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, '' 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, '' 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, '' 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, '' 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, '' 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, '' as CATALOG_GROUP_NAME_28, 'N' as CATALOG_CAN_ACCESS_28, 'N' 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, '' 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, '' 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, '' 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, '' as CATALOG_GROUP_NAME_32, 'N' as CATALOG_CAN_ACCESS_32, 'N' 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, '' 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, '' 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, '' 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, '' 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, '' as CATALOG_GROUP_NAME_37, 'N' as CATALOG_CAN_ACCESS_37, 'N' 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, '' 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, '' as CATALOG_GROUP_NAME_39, 'N' as CATALOG_CAN_ACCESS_39, 'N' 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, '' as CATALOG_GROUP_NAME_40, 'N' as CATALOG_CAN_ACCESS_40, 'N' 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, '' 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, '' 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, '' 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, '' 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, '' 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_P46.ID as CATALOG_PRICE_ID_46, CAT_P46.CATALOG_GROUP_ID as CATALOG_GROUP_ID_46, CAT_P46.PRICE as CATALOG_PRICE_46, CAT_P46.CURRENCY as CATALOG_CURRENCY_46, CAT_P46.QUANTITY_FROM as CATALOG_QUANTITY_FROM_46, CAT_P46.QUANTITY_TO as CATALOG_QUANTITY_TO_46, '' as CATALOG_GROUP_NAME_46, 'N' as CATALOG_CAN_ACCESS_46, 'N' as CATALOG_CAN_BUY_46, CAT_P46.EXTRA_ID as CATALOG_EXTRA_ID_46, CAT_P47.ID as CATALOG_PRICE_ID_47, CAT_P47.CATALOG_GROUP_ID as CATALOG_GROUP_ID_47, CAT_P47.PRICE as CATALOG_PRICE_47, CAT_P47.CURRENCY as CATALOG_CURRENCY_47, CAT_P47.QUANTITY_FROM as CATALOG_QUANTITY_FROM_47, CAT_P47.QUANTITY_TO as CATALOG_QUANTITY_TO_47, '' as CATALOG_GROUP_NAME_47, 'N' as CATALOG_CAN_ACCESS_47, 'N' as CATALOG_CAN_BUY_47, CAT_P47.EXTRA_ID as CATALOG_EXTRA_ID_47, CAT_P48.ID as CATALOG_PRICE_ID_48, CAT_P48.CATALOG_GROUP_ID as CATALOG_GROUP_ID_48, CAT_P48.PRICE as CATALOG_PRICE_48, CAT_P48.CURRENCY as CATALOG_CURRENCY_48, CAT_P48.QUANTITY_FROM as CATALOG_QUANTITY_FROM_48, CAT_P48.QUANTITY_TO as CATALOG_QUANTITY_TO_48, '' as CATALOG_GROUP_NAME_48, 'N' as CATALOG_CAN_ACCESS_48, 'N' as CATALOG_CAN_BUY_48, CAT_P48.EXTRA_ID as CATALOG_EXTRA_ID_48, CAT_P49.ID as CATALOG_PRICE_ID_49, CAT_P49.CATALOG_GROUP_ID as CATALOG_GROUP_ID_49, CAT_P49.PRICE as CATALOG_PRICE_49, CAT_P49.CURRENCY as CATALOG_CURRENCY_49, CAT_P49.QUANTITY_FROM as CATALOG_QUANTITY_FROM_49, CAT_P49.QUANTITY_TO as CATALOG_QUANTITY_TO_49, '' as CATALOG_GROUP_NAME_49, 'N' as CATALOG_CAN_ACCESS_49, 'N' as CATALOG_CAN_BUY_49, CAT_P49.EXTRA_ID as CATALOG_EXTRA_ID_49, CAT_P50.ID as CATALOG_PRICE_ID_50, CAT_P50.CATALOG_GROUP_ID as CATALOG_GROUP_ID_50, CAT_P50.PRICE as CATALOG_PRICE_50, CAT_P50.CURRENCY as CATALOG_CURRENCY_50, CAT_P50.QUANTITY_FROM as CATALOG_QUANTITY_FROM_50, CAT_P50.QUANTITY_TO as CATALOG_QUANTITY_TO_50, '' as CATALOG_GROUP_NAME_50, 'N' as CATALOG_CAN_ACCESS_50, 'N' as CATALOG_CAN_BUY_50, CAT_P50.EXTRA_ID as CATALOG_EXTRA_ID_50, CAT_P51.ID as CATALOG_PRICE_ID_51, CAT_P51.CATALOG_GROUP_ID as CATALOG_GROUP_ID_51, CAT_P51.PRICE as CATALOG_PRICE_51, CAT_P51.CURRENCY as CATALOG_CURRENCY_51, CAT_P51.QUANTITY_FROM as CATALOG_QUANTITY_FROM_51, CAT_P51.QUANTITY_TO as CATALOG_QUANTITY_TO_51, '' as CATALOG_GROUP_NAME_51, 'N' as CATALOG_CAN_ACCESS_51, 'N' as CATALOG_CAN_BUY_51, CAT_P51.EXTRA_ID as CATALOG_EXTRA_ID_51, CAT_P52.ID as CATALOG_PRICE_ID_52, CAT_P52.CATALOG_GROUP_ID as CATALOG_GROUP_ID_52, CAT_P52.PRICE as CATALOG_PRICE_52, CAT_P52.CURRENCY as CATALOG_CURRENCY_52, CAT_P52.QUANTITY_FROM as CATALOG_QUANTITY_FROM_52, CAT_P52.QUANTITY_TO as CATALOG_QUANTITY_TO_52, '' as CATALOG_GROUP_NAME_52, 'N' as CATALOG_CAN_ACCESS_52, 'N' as CATALOG_CAN_BUY_52, CAT_P52.EXTRA_ID as CATALOG_EXTRA_ID_52, CAT_P53.ID as CATALOG_PRICE_ID_53, CAT_P53.CATALOG_GROUP_ID as CATALOG_GROUP_ID_53, CAT_P53.PRICE as CATALOG_PRICE_53, CAT_P53.CURRENCY as CATALOG_CURRENCY_53, CAT_P53.QUANTITY_FROM as CATALOG_QUANTITY_FROM_53, CAT_P53.QUANTITY_TO as CATALOG_QUANTITY_TO_53, '' as CATALOG_GROUP_NAME_53, 'N' as CATALOG_CAN_ACCESS_53, 'N' as CATALOG_CAN_BUY_53, CAT_P53.EXTRA_ID as CATALOG_EXTRA_ID_53, CAT_P54.ID as CATALOG_PRICE_ID_54, CAT_P54.CATALOG_GROUP_ID as CATALOG_GROUP_ID_54, CAT_P54.PRICE as CATALOG_PRICE_54, CAT_P54.CURRENCY as CATALOG_CURRENCY_54, CAT_P54.QUANTITY_FROM as CATALOG_QUANTITY_FROM_54, CAT_P54.QUANTITY_TO as CATALOG_QUANTITY_TO_54, '' as CATALOG_GROUP_NAME_54, 'N' as CATALOG_CAN_ACCESS_54, 'N' as CATALOG_CAN_BUY_54, CAT_P54.EXTRA_ID as CATALOG_EXTRA_ID_54, CAT_P55.ID as CATALOG_PRICE_ID_55, CAT_P55.CATALOG_GROUP_ID as CATALOG_GROUP_ID_55, CAT_P55.PRICE as CATALOG_PRICE_55, CAT_P55.CURRENCY as CATALOG_CURRENCY_55, CAT_P55.QUANTITY_FROM as CATALOG_QUANTITY_FROM_55, CAT_P55.QUANTITY_TO as CATALOG_QUANTITY_TO_55, '' as CATALOG_GROUP_NAME_55, 'N' as CATALOG_CAN_ACCESS_55, 'N' as CATALOG_CAN_BUY_55, CAT_P55.EXTRA_ID as CATALOG_EXTRA_ID_55, CAT_P56.ID as CATALOG_PRICE_ID_56, CAT_P56.CATALOG_GROUP_ID as CATALOG_GROUP_ID_56, CAT_P56.PRICE as CATALOG_PRICE_56, CAT_P56.CURRENCY as CATALOG_CURRENCY_56, CAT_P56.QUANTITY_FROM as CATALOG_QUANTITY_FROM_56, CAT_P56.QUANTITY_TO as CATALOG_QUANTITY_TO_56, '' as CATALOG_GROUP_NAME_56, 'N' as CATALOG_CAN_ACCESS_56, 'N' as CATALOG_CAN_BUY_56, CAT_P56.EXTRA_ID as CATALOG_EXTRA_ID_56, CAT_P57.ID as CATALOG_PRICE_ID_57, CAT_P57.CATALOG_GROUP_ID as CATALOG_GROUP_ID_57, CAT_P57.PRICE as CATALOG_PRICE_57, CAT_P57.CURRENCY as CATALOG_CURRENCY_57, CAT_P57.QUANTITY_FROM as CATALOG_QUANTITY_FROM_57, CAT_P57.QUANTITY_TO as CATALOG_QUANTITY_TO_57, '' as CATALOG_GROUP_NAME_57, 'N' as CATALOG_CAN_ACCESS_57, 'N' as CATALOG_CAN_BUY_57, CAT_P57.EXTRA_ID as CATALOG_EXTRA_ID_57, 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', 'N', CAT_PR.CAN_BUY_ZERO) as CATALOG_CAN_BUY_ZERO, IF (CAT_PR.NEGATIVE_AMOUNT_TRACE = 'D', 'N', 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', 'N', 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 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_catalog_price CAT_P8 ON (CAT_P8.PRODUCT_ID = BE.ID AND CAT_P8.CATALOG_GROUP_ID = 8) LEFT JOIN b_catalog_price CAT_P9 ON (CAT_P9.PRODUCT_ID = BE.ID AND CAT_P9.CATALOG_GROUP_ID = 9) 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_P12 ON (CAT_P12.PRODUCT_ID = BE.ID AND CAT_P12.CATALOG_GROUP_ID = 12) LEFT JOIN b_catalog_price CAT_P13 ON (CAT_P13.PRODUCT_ID = BE.ID AND CAT_P13.CATALOG_GROUP_ID = 13) LEFT JOIN b_catalog_price CAT_P14 ON (CAT_P14.PRODUCT_ID = BE.ID AND CAT_P14.CATALOG_GROUP_ID = 14) LEFT JOIN b_catalog_price CAT_P15 ON (CAT_P15.PRODUCT_ID = BE.ID AND CAT_P15.CATALOG_GROUP_ID = 15) LEFT JOIN b_catalog_price CAT_P16 ON (CAT_P16.PRODUCT_ID = BE.ID AND CAT_P16.CATALOG_GROUP_ID = 16) 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) LEFT JOIN b_catalog_price CAT_P19 ON (CAT_P19.PRODUCT_ID = BE.ID AND CAT_P19.CATALOG_GROUP_ID = 19) LEFT JOIN b_catalog_price CAT_P20 ON (CAT_P20.PRODUCT_ID = BE.ID AND CAT_P20.CATALOG_GROUP_ID = 20) LEFT JOIN b_catalog_price CAT_P21 ON (CAT_P21.PRODUCT_ID = BE.ID AND CAT_P21.CATALOG_GROUP_ID = 21) LEFT JOIN b_catalog_price CAT_P22 ON (CAT_P22.PRODUCT_ID = BE.ID AND CAT_P22.CATALOG_GROUP_ID = 22) LEFT JOIN b_catalog_price CAT_P23 ON (CAT_P23.PRODUCT_ID = BE.ID AND CAT_P23.CATALOG_GROUP_ID = 23) LEFT JOIN b_catalog_price CAT_P24 ON (CAT_P24.PRODUCT_ID = BE.ID AND CAT_P24.CATALOG_GROUP_ID = 24) LEFT JOIN b_catalog_price CAT_P25 ON (CAT_P25.PRODUCT_ID = BE.ID AND CAT_P25.CATALOG_GROUP_ID = 25) LEFT JOIN b_catalog_price CAT_P26 ON (CAT_P26.PRODUCT_ID = BE.ID AND CAT_P26.CATALOG_GROUP_ID = 26) LEFT JOIN b_catalog_price CAT_P27 ON (CAT_P27.PRODUCT_ID = BE.ID AND CAT_P27.CATALOG_GROUP_ID = 27) LEFT JOIN b_catalog_price CAT_P28 ON (CAT_P28.PRODUCT_ID = BE.ID AND CAT_P28.CATALOG_GROUP_ID = 28) LEFT JOIN b_catalog_price CAT_P29 ON (CAT_P29.PRODUCT_ID = BE.ID AND CAT_P29.CATALOG_GROUP_ID = 29) LEFT JOIN b_catalog_price CAT_P30 ON (CAT_P30.PRODUCT_ID = BE.ID AND CAT_P30.CATALOG_GROUP_ID = 30) LEFT JOIN b_catalog_price CAT_P31 ON (CAT_P31.PRODUCT_ID = BE.ID AND CAT_P31.CATALOG_GROUP_ID = 31) LEFT JOIN b_catalog_price CAT_P32 ON (CAT_P32.PRODUCT_ID = BE.ID AND CAT_P32.CATALOG_GROUP_ID = 32) LEFT JOIN b_catalog_price CAT_P33 ON (CAT_P33.PRODUCT_ID = BE.ID AND CAT_P33.CATALOG_GROUP_ID = 33) LEFT JOIN b_catalog_price CAT_P34 ON (CAT_P34.PRODUCT_ID = BE.ID AND CAT_P34.CATALOG_GROUP_ID = 34) LEFT JOIN b_catalog_price CAT_P35 ON (CAT_P35.PRODUCT_ID = BE.ID AND CAT_P35.CATALOG_GROUP_ID = 35) LEFT JOIN b_catalog_price CAT_P36 ON (CAT_P36.PRODUCT_ID = BE.ID AND CAT_P36.CATALOG_GROUP_ID = 36) LEFT JOIN b_catalog_price CAT_P37 ON (CAT_P37.PRODUCT_ID = BE.ID AND CAT_P37.CATALOG_GROUP_ID = 37) LEFT JOIN b_catalog_price CAT_P38 ON (CAT_P38.PRODUCT_ID = BE.ID AND CAT_P38.CATALOG_GROUP_ID = 38) LEFT JOIN b_catalog_price CAT_P39 ON (CAT_P39.PRODUCT_ID = BE.ID AND CAT_P39.CATALOG_GROUP_ID = 39) LEFT JOIN b_catalog_price CAT_P40 ON (CAT_P40.PRODUCT_ID = BE.ID AND CAT_P40.CATALOG_GROUP_ID = 40) LEFT JOIN b_catalog_price CAT_P41 ON (CAT_P41.PRODUCT_ID = BE.ID AND CAT_P41.CATALOG_GROUP_ID = 41) LEFT JOIN b_catalog_price CAT_P42 ON (CAT_P42.PRODUCT_ID = BE.ID AND CAT_P42.CATALOG_GROUP_ID = 42) LEFT JOIN b_catalog_price CAT_P43 ON (CAT_P43.PRODUCT_ID = BE.ID AND CAT_P43.CATALOG_GROUP_ID = 43) LEFT JOIN b_catalog_price CAT_P44 ON (CAT_P44.PRODUCT_ID = BE.ID AND CAT_P44.CATALOG_GROUP_ID = 44) LEFT JOIN b_catalog_price CAT_P45 ON (CAT_P45.PRODUCT_ID = BE.ID AND CAT_P45.CATALOG_GROUP_ID = 45) LEFT JOIN b_catalog_price CAT_P46 ON (CAT_P46.PRODUCT_ID = BE.ID AND CAT_P46.CATALOG_GROUP_ID = 46) LEFT JOIN b_catalog_price CAT_P47 ON (CAT_P47.PRODUCT_ID = BE.ID AND CAT_P47.CATALOG_GROUP_ID = 47) LEFT JOIN b_catalog_price CAT_P48 ON (CAT_P48.PRODUCT_ID = BE.ID AND CAT_P48.CATALOG_GROUP_ID = 48) LEFT JOIN b_catalog_price CAT_P49 ON (CAT_P49.PRODUCT_ID = BE.ID AND CAT_P49.CATALOG_GROUP_ID = 49) LEFT JOIN b_catalog_price CAT_P50 ON (CAT_P50.PRODUCT_ID = BE.ID AND CAT_P50.CATALOG_GROUP_ID = 50) LEFT JOIN b_catalog_price CAT_P51 ON (CAT_P51.PRODUCT_ID = BE.ID AND CAT_P51.CATALOG_GROUP_ID = 51) LEFT JOIN b_catalog_price CAT_P52 ON (CAT_P52.PRODUCT_ID = BE.ID AND CAT_P52.CATALOG_GROUP_ID = 52) LEFT JOIN b_catalog_price CAT_P53 ON (CAT_P53.PRODUCT_ID = BE.ID AND CAT_P53.CATALOG_GROUP_ID = 53) LEFT JOIN b_catalog_price CAT_P54 ON (CAT_P54.PRODUCT_ID = BE.ID AND CAT_P54.CATALOG_GROUP_ID = 54) LEFT JOIN b_catalog_price CAT_P55 ON (CAT_P55.PRODUCT_ID = BE.ID AND CAT_P55.CATALOG_GROUP_ID = 55) LEFT JOIN b_catalog_price CAT_P56 ON (CAT_P56.PRODUCT_ID = BE.ID AND CAT_P56.CATALOG_GROUP_ID = 56) LEFT JOIN b_catalog_price CAT_P57 ON (CAT_P57.PRODUCT_ID = BE.ID AND CAT_P57.CATALOG_GROUP_ID = 57) 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)) WHERE 1=1 AND ( ((((BE.IBLOCK_ID = '8')))) AND (EXISTS ( SELECT IBLOCK_ID FROM b_iblock_site WHERE IBLOCK_ID = B.ID AND (((SITE_ID='s1'))) )) 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 ( ((((CAT_P57.PRICE > '0')))) OR ((((CAT_P9.PRICE > '0')))) OR ((((CAT_P18.PRICE > '0')))) OR ((((CAT_P8.PRICE > '0')))) OR ((((CAT_P17.PRICE > '0')))) OR ((((CAT_P19.PRICE > '0')))) OR ((((CAT_P20.PRICE > '0')))) OR ((((CAT_P21.PRICE > '0')))) OR ((((CAT_P12.PRICE > '0')))) OR ((((CAT_P14.PRICE > '0')))) OR ((((CAT_P22.PRICE > '0')))) OR ((((CAT_P23.PRICE > '0')))) OR ((((CAT_P24.PRICE > '0')))) OR ((((CAT_P25.PRICE > '0')))) OR ((((CAT_P26.PRICE > '0')))) OR ((((CAT_P27.PRICE > '0')))) OR ((((CAT_P28.PRICE > '0')))) OR ((((CAT_P29.PRICE > '0')))) OR ((((CAT_P30.PRICE > '0')))) OR ((((CAT_P31.PRICE > '0')))) OR ((((CAT_P32.PRICE > '0')))) OR ((((CAT_P33.PRICE > '0')))) OR ((((CAT_P34.PRICE > '0')))) OR ((((CAT_P35.PRICE > '0')))) OR ((((CAT_P36.PRICE > '0')))) OR ((((CAT_P37.PRICE > '0')))) OR ((((CAT_P38.PRICE > '0')))) OR ((((CAT_P13.PRICE > '0')))) OR ((((CAT_P39.PRICE > '0')))) OR ((((CAT_P40.PRICE > '0')))) OR ((((CAT_P41.PRICE > '0')))) OR ((((CAT_P42.PRICE > '0')))) OR ((((CAT_P43.PRICE > '0')))) OR ((((CAT_P44.PRICE > '0')))) OR ((((CAT_P45.PRICE > '0')))) OR ((((CAT_P46.PRICE > '0')))) OR ((((CAT_P15.PRICE > '0')))) OR ((((CAT_P47.PRICE > '0')))) OR ((((CAT_P48.PRICE > '0')))) OR ((((CAT_P16.PRICE > '0')))) OR ((((CAT_P49.PRICE > '0')))) OR ((((CAT_P50.PRICE > '0')))) OR ((((CAT_P51.PRICE > '0')))) OR ((((CAT_P52.PRICE > '0')))) OR ((((CAT_P53.PRICE > '0')))) OR ((((CAT_P54.PRICE > '0')))) OR ((((CAT_P55.PRICE > '0')))) OR ((((CAT_P56.PRICE > '0')))) ) ) 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.ID asc LIMIT 0, 10[Can't create/write to file '/tmp/#sql_1_1.MAI' (Errcode: 28 "No space left on device")]