Пользователь 63180

MySQL Query Error: SELECT DISTINCT BE.ID as ID,DATE_FORMAT(BE.TIMESTAMP_X, '%d.%m.%Y %H:%i:%s') as TIMESTAMP_X,BE.MODIFIED_BY as MODIFIED_BY,DATE_FORMAT(BE.DATE_CREATE, '%d.%m.%Y %H:%i:%s') as DATE_CREATE,BE.CREATED_BY as CREATED_BY,BE.IBLOCK_ID as IBLOCK_ID,BE.ACTIVE as ACTIVE,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,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 ACTIVE_TO,BE.SORT as SORT,BE.NAME as NAME,BE.PREVIEW_PICTURE as PREVIEW_PICTURE,BE.PREVIEW_TEXT as PREVIEW_TEXT,BE.PREVIEW_TEXT_TYPE as PREVIEW_TEXT_TYPE,BE.DETAIL_PICTURE as DETAIL_PICTURE,BE.DETAIL_TEXT as DETAIL_TEXT,BE.DETAIL_TEXT_TYPE as DETAIL_TEXT_TYPE,BE.CODE as CODE,BE.XML_ID as XML_ID, FPV0.VALUE as PROPERTY_CUSTOMERBANKADDRESS_VALUE, FPV0.ID as PROPERTY_CUSTOMERBANKADDRESS_VALUE_ID, FPV1.VALUE as PROPERTY_CUSTOMERADDRESS_VALUE, FPV1.ID as PROPERTY_CUSTOMERADDRESS_VALUE_ID, FPV2.VALUE as PROPERTY_CUSTOMERBIK_VALUE, FPV2.ID as PROPERTY_CUSTOMERBIK_VALUE_ID, FPV3.VALUE as PROPERTY_F_CONTRACT_VALUE, FPV3.ID as PROPERTY_F_CONTRACT_VALUE_ID, FPV4.VALUE as PROPERTY_CUSTOMERINN_VALUE, FPV4.ID as PROPERTY_CUSTOMERINN_VALUE_ID, FPV5.VALUE as PROPERTY_CONTRACTOTHERNOTES_VALUE, FPV5.ID as PROPERTY_CONTRACTOTHERNOTES_VALUE_ID, FPV6.VALUE as PROPERTY_CUSTOMERKS_VALUE, FPV6.ID as PROPERTY_CUSTOMERKS_VALUE_ID, FPV7.VALUE as PROPERTY_CONTRACTCALENDARPLAN_VALUE, FPV7.ID as PROPERTY_CONTRACTCALENDARPLAN_VALUE_ID, FPV8.VALUE as PROPERTY_CUSTOMERKPP_VALUE, FPV8.ID as PROPERTY_CUSTOMERKPP_VALUE_ID, FPV9.VALUE as PROPERTY_CUSTOMERBANK_VALUE, FPV9.ID as PROPERTY_CUSTOMERBANK_VALUE_ID, FPV10.VALUE as PROPERTY_CONTRACTMAINCUSTOMER_VALUE, FPV10.ID as PROPERTY_CONTRACTMAINCUSTOMER_VALUE_ID, FPV11.VALUE as PROPERTY_CONTRACTNDS_VALUE, FPV11.ID as PROPERTY_CONTRACTNDS_VALUE_ID, FPV12.VALUE as PROPERTY_CONTRACTTOTALPRICE_VALUE, FPV12.ID as PROPERTY_CONTRACTTOTALPRICE_VALUE_ID, FPV13.VALUE as PROPERTY_CUSTOMEROKVED_VALUE, FPV13.ID as PROPERTY_CUSTOMEROKVED_VALUE_ID, FPV14.VALUE as PROPERTY_CUSTOMEROKOGU_VALUE, FPV14.ID as PROPERTY_CUSTOMEROKOGU_VALUE_ID, FPV15.VALUE as PROPERTY_CUSTOMEROKPO_VALUE, FPV15.ID as PROPERTY_CUSTOMEROKPO_VALUE_ID, FPV16.VALUE as PROPERTY_CUSTOMEROKFS_VALUE, FPV16.ID as PROPERTY_CUSTOMEROKFS_VALUE_ID, FPV17.VALUE as PROPERTY_CONTRACTNDSNOTE_VALUE, FPV17.ID as PROPERTY_CONTRACTNDSNOTE_VALUE_ID, FPV18.VALUE as PROPERTY_CONTRACTREPORT_VALUE, FPV18.ID as PROPERTY_CONTRACTREPORT_VALUE_ID, FPV19.VALUE as PROPERTY_CONTRACTPAYMENTPROCEDURE_VALUE, FPV19.ID as PROPERTY_CONTRACTPAYMENTPROCEDURE_VALUE_ID, FPV20.VALUE as PROPERTY_CONTRACTTRANSFERRING_VALUE, FPV20.ID as PROPERTY_CONTRACTTRANSFERRING_VALUE_ID, FPV21.VALUE as PROPERTY_CONTRACTSERVICES_VALUE, FPV21.ID as PROPERTY_CONTRACTSERVICES_VALUE_ID, FPV22.VALUE as PROPERTY_CUSTOMERRS_VALUE, FPV22.ID as PROPERTY_CUSTOMERRS_VALUE_ID, FPV23.VALUE as PROPERTY_CONTRACTRESULT_VALUE, FPV23.ID as PROPERTY_CONTRACTRESULT_VALUE_ID, FPV24.VALUE as PROPERTY_CONTRACTSMETA_VALUE, FPV24.ID as PROPERTY_CONTRACTSMETA_VALUE_ID, FPV25.VALUE as PROPERTY_CONTRACTTIMING_VALUE, FPV25.ID as PROPERTY_CONTRACTTIMING_VALUE_ID, FPV26.VALUE as PROPERTY_CONTRACTREPORTTIMING_VALUE, FPV26.ID as PROPERTY_CONTRACTREPORTTIMING_VALUE_ID, FPV27.VALUE as PROPERTY_CONTRACTSTAGESPRICE_VALUE, FPV27.ID as PROPERTY_CONTRACTSTAGESPRICE_VALUE_ID, FPV28.VALUE as PROPERTY_F_BILL_VALUE, FPV28.ID as PROPERTY_F_BILL_VALUE_ID, FPV29.VALUE as PROPERTY_CUSTOMERPHONE_VALUE, FPV29.ID as PROPERTY_CUSTOMERPHONE_VALUE_ID, FPV30.VALUE as PROPERTY_CONTRACTSPECIFICATION_VALUE, FPV30.ID as PROPERTY_CONTRACTSPECIFICATION_VALUE_ID, FPV31.VALUE as PROPERTY_CUSTOMERPERSON_VALUE, FPV31.ID as PROPERTY_CUSTOMERPERSON_VALUE_ID, FPV32.VALUE as PROPERTY_CUSTOMERFAX_VALUE, FPV32.ID as PROPERTY_CUSTOMERFAX_VALUE_ID, FPV33.VALUE as PROPERTY_CONTRACTSTAGES_VALUE, FPV33.ID as PROPERTY_CONTRACTSTAGES_VALUE_ID 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='CUSTOMERBANKADDRESS' LEFT JOIN b_iblock_property FP1 ON FP1.IBLOCK_ID = B.ID AND FP1.CODE='CUSTOMERADDRESS' LEFT JOIN b_iblock_property FP2 ON FP2.IBLOCK_ID = B.ID AND FP2.CODE='CUSTOMERBIK' LEFT JOIN b_iblock_property FP3 ON FP3.IBLOCK_ID = B.ID AND FP3.CODE='F_CONTRACT' LEFT JOIN b_iblock_property FP4 ON FP4.IBLOCK_ID = B.ID AND FP4.CODE='CUSTOMERINN' LEFT JOIN b_iblock_property FP5 ON FP5.IBLOCK_ID = B.ID AND FP5.CODE='CONTRACTOTHERNOTES' LEFT JOIN b_iblock_property FP6 ON FP6.IBLOCK_ID = B.ID AND FP6.CODE='CUSTOMERKS' LEFT JOIN b_iblock_property FP7 ON FP7.IBLOCK_ID = B.ID AND FP7.CODE='CONTRACTCALENDARPLAN' LEFT JOIN b_iblock_property FP8 ON FP8.IBLOCK_ID = B.ID AND FP8.CODE='CUSTOMERKPP' LEFT JOIN b_iblock_property FP9 ON FP9.IBLOCK_ID = B.ID AND FP9.CODE='CUSTOMERBANK' LEFT JOIN b_iblock_property FP10 ON FP10.IBLOCK_ID = B.ID AND FP10.CODE='CONTRACTMAINCUSTOMER' LEFT JOIN b_iblock_property FP11 ON FP11.IBLOCK_ID = B.ID AND FP11.CODE='CONTRACTNDS' LEFT JOIN b_iblock_property FP12 ON FP12.IBLOCK_ID = B.ID AND FP12.CODE='CONTRACTTOTALPRICE' LEFT JOIN b_iblock_property FP13 ON FP13.IBLOCK_ID = B.ID AND FP13.CODE='CUSTOMEROKVED' LEFT JOIN b_iblock_property FP14 ON FP14.IBLOCK_ID = B.ID AND FP14.CODE='CUSTOMEROKOGU' LEFT JOIN b_iblock_property FP15 ON FP15.IBLOCK_ID = B.ID AND FP15.CODE='CUSTOMEROKPO' LEFT JOIN b_iblock_property FP16 ON FP16.IBLOCK_ID = B.ID AND FP16.CODE='CUSTOMEROKFS' LEFT JOIN b_iblock_property FP17 ON FP17.IBLOCK_ID = B.ID AND FP17.CODE='CONTRACTNDSNOTE' LEFT JOIN b_iblock_property FP18 ON FP18.IBLOCK_ID = B.ID AND FP18.CODE='CONTRACTREPORT' LEFT JOIN b_iblock_property FP19 ON FP19.IBLOCK_ID = B.ID AND FP19.CODE='CONTRACTPAYMENTPROCEDURE' LEFT JOIN b_iblock_property FP20 ON FP20.IBLOCK_ID = B.ID AND FP20.CODE='CONTRACTTRANSFERRING' LEFT JOIN b_iblock_property FP21 ON FP21.IBLOCK_ID = B.ID AND FP21.CODE='CONTRACTSERVICES' LEFT JOIN b_iblock_property FP22 ON FP22.IBLOCK_ID = B.ID AND FP22.CODE='CUSTOMERRS' LEFT JOIN b_iblock_property FP23 ON FP23.IBLOCK_ID = B.ID AND FP23.CODE='CONTRACTRESULT' LEFT JOIN b_iblock_property FP24 ON FP24.IBLOCK_ID = B.ID AND FP24.CODE='CONTRACTSMETA' LEFT JOIN b_iblock_property FP25 ON FP25.IBLOCK_ID = B.ID AND FP25.CODE='CONTRACTTIMING' LEFT JOIN b_iblock_property FP26 ON FP26.IBLOCK_ID = B.ID AND FP26.CODE='CONTRACTREPORTTIMING' LEFT JOIN b_iblock_property FP27 ON FP27.IBLOCK_ID = B.ID AND FP27.CODE='CONTRACTSTAGESPRICE' LEFT JOIN b_iblock_property FP28 ON FP28.IBLOCK_ID = B.ID AND FP28.CODE='F_BILL' LEFT JOIN b_iblock_property FP29 ON FP29.IBLOCK_ID = B.ID AND FP29.CODE='CUSTOMERPHONE' LEFT JOIN b_iblock_property FP30 ON FP30.IBLOCK_ID = B.ID AND FP30.CODE='CONTRACTSPECIFICATION' LEFT JOIN b_iblock_property FP31 ON FP31.IBLOCK_ID = B.ID AND FP31.CODE='CUSTOMERPERSON' LEFT JOIN b_iblock_property FP32 ON FP32.IBLOCK_ID = B.ID AND FP32.CODE='CUSTOMERFAX' LEFT JOIN b_iblock_property FP33 ON FP33.IBLOCK_ID = B.ID AND FP33.CODE='CONTRACTSTAGES' 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_element_property FPV8 ON FPV8.IBLOCK_PROPERTY_ID = FP8.ID AND FPV8.IBLOCK_ELEMENT_ID = BE.ID LEFT JOIN b_iblock_element_property FPV9 ON FPV9.IBLOCK_PROPERTY_ID = FP9.ID AND FPV9.IBLOCK_ELEMENT_ID = BE.ID LEFT JOIN b_iblock_element_property FPV10 ON FPV10.IBLOCK_PROPERTY_ID = FP10.ID AND FPV10.IBLOCK_ELEMENT_ID = BE.ID LEFT JOIN b_iblock_element_property FPV11 ON FPV11.IBLOCK_PROPERTY_ID = FP11.ID AND FPV11.IBLOCK_ELEMENT_ID = BE.ID LEFT JOIN b_iblock_element_property FPV12 ON FPV12.IBLOCK_PROPERTY_ID = FP12.ID AND FPV12.IBLOCK_ELEMENT_ID = BE.ID LEFT JOIN b_iblock_element_property FPV13 ON FPV13.IBLOCK_PROPERTY_ID = FP13.ID AND FPV13.IBLOCK_ELEMENT_ID = BE.ID LEFT JOIN b_iblock_element_property FPV14 ON FPV14.IBLOCK_PROPERTY_ID = FP14.ID AND FPV14.IBLOCK_ELEMENT_ID = BE.ID LEFT JOIN b_iblock_element_property FPV15 ON FPV15.IBLOCK_PROPERTY_ID = FP15.ID AND FPV15.IBLOCK_ELEMENT_ID = BE.ID LEFT JOIN b_iblock_element_property FPV16 ON FPV16.IBLOCK_PROPERTY_ID = FP16.ID AND FPV16.IBLOCK_ELEMENT_ID = BE.ID LEFT JOIN b_iblock_element_property FPV17 ON FPV17.IBLOCK_PROPERTY_ID = FP17.ID AND FPV17.IBLOCK_ELEMENT_ID = BE.ID LEFT JOIN b_iblock_element_property FPV18 ON FPV18.IBLOCK_PROPERTY_ID = FP18.ID AND FPV18.IBLOCK_ELEMENT_ID = BE.ID LEFT JOIN b_iblock_element_property FPV19 ON FPV19.IBLOCK_PROPERTY_ID = FP19.ID AND FPV19.IBLOCK_ELEMENT_ID = BE.ID LEFT JOIN b_iblock_element_property FPV20 ON FPV20.IBLOCK_PROPERTY_ID = FP20.ID AND FPV20.IBLOCK_ELEMENT_ID = BE.ID LEFT JOIN b_iblock_element_property FPV21 ON FPV21.IBLOCK_PROPERTY_ID = FP21.ID AND FPV21.IBLOCK_ELEMENT_ID = BE.ID LEFT JOIN b_iblock_element_property FPV22 ON FPV22.IBLOCK_PROPERTY_ID = FP22.ID AND FPV22.IBLOCK_ELEMENT_ID = BE.ID LEFT JOIN b_iblock_element_property FPV23 ON FPV23.IBLOCK_PROPERTY_ID = FP23.ID AND FPV23.IBLOCK_ELEMENT_ID = BE.ID LEFT JOIN b_iblock_element_property FPV24 ON FPV24.IBLOCK_PROPERTY_ID = FP24.ID AND FPV24.IBLOCK_ELEMENT_ID = BE.ID LEFT JOIN b_iblock_element_property FPV25 ON FPV25.IBLOCK_PROPERTY_ID = FP25.ID AND FPV25.IBLOCK_ELEMENT_ID = BE.ID LEFT JOIN b_iblock_element_property FPV26 ON FPV26.IBLOCK_PROPERTY_ID = FP26.ID AND FPV26.IBLOCK_ELEMENT_ID = BE.ID LEFT JOIN b_iblock_element_property FPV27 ON FPV27.IBLOCK_PROPERTY_ID = FP27.ID AND FPV27.IBLOCK_ELEMENT_ID = BE.ID LEFT JOIN b_iblock_element_property FPV28 ON FPV28.IBLOCK_PROPERTY_ID = FP28.ID AND FPV28.IBLOCK_ELEMENT_ID = BE.ID LEFT JOIN b_iblock_element_property FPV29 ON FPV29.IBLOCK_PROPERTY_ID = FP29.ID AND FPV29.IBLOCK_ELEMENT_ID = BE.ID LEFT JOIN b_iblock_element_property FPV30 ON FPV30.IBLOCK_PROPERTY_ID = FP30.ID AND FPV30.IBLOCK_ELEMENT_ID = BE.ID LEFT JOIN b_iblock_element_property FPV31 ON FPV31.IBLOCK_PROPERTY_ID = FP31.ID AND FPV31.IBLOCK_ELEMENT_ID = BE.ID LEFT JOIN b_iblock_element_property FPV32 ON FPV32.IBLOCK_PROPERTY_ID = FP32.ID AND FPV32.IBLOCK_ELEMENT_ID = BE.ID LEFT JOIN b_iblock_element_property FPV33 ON FPV33.IBLOCK_PROPERTY_ID = FP33.ID AND FPV33.IBLOCK_ELEMENT_ID = BE.ID WHERE 1=1 AND ( ((((BE.ID = '3235')))) AND ((((BE.IBLOCK_ID = '35')))) AND ((((BE.ACTIVE='Y')))) ) AND (((BE.WF_STATUS_ID=1 AND BE.WF_PARENT_ELEMENT_ID IS NULL) OR (BE.WF_NEW='Y')))