LINE: 693
MySQL Query Error: SELECT BE.ID as ID,BE.CODE as CODE, FPS0.PROPERTY_82 as PROPERTY_CARGO_VALUE, FPS0.PROPERTY_83 as PROPERTY_TRANSPO_VALUE, FPS0.PROPERTY_84 as PROPERTY_MANUFACTURER_VALUE, FPS0.PROPERTY_81 as PROPERTY_FULLNAME_VALUE,BE.SORT as SORT, COUNT( BE.ID) as CNT 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_element_prop_s14 FPS0 ON FPS0.IBLOCK_ELEMENT_ID = BE.ID WHERE 1=1 AND ( ((((B.CODE LIKE 'nomenclature')))) ) AND (((BE.WF_STATUS_ID=1 AND BE.WF_PARENT_ELEMENT_ID IS NULL))) GROUP BY BE.ID,BE.CODE, FPS0.PROPERTY_82, FPS0.PROPERTY_83, FPS0.PROPERTY_84, FPS0.PROPERTY_81,BE.SORT ORDER BY BE.SORT asc [Disk full (/var/lib/tmp_mysql/#sql_bc4_0); waiting for someone to free some space...]
|