MySQL Query Error:
SELECT
BEP.*
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_s6 FPS0 ON FPS0.IBLOCK_ELEMENT_ID = BE.ID
INNER JOIN b_iblock_element_prop_s6 BEP ON BEP.IBLOCK_ELEMENT_ID = BE.ID
WHERE 1=1
AND (
((((BE.IBLOCK_ID = '6'))))
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 (((FPS0.PROPERTY_86 IN ('49405', '49406', '49419', '49557', '49585', '49586', '49587', '49625', '49626', '49627', '49628', '49629', '49630', '49695', '49696', '49697', '49698', '49699', '49700', '49701', '49702', '49703', '49704', '49705', '49706', '49758', '49759', '49760', '49761', '49762', '49763', '49770', '49771', '49772', '50034', '50035', '50036', '167233', '167881', '167882', '167883', '167884', '167941', '167950', '167951', '168252', '169079', '169080', '169081', '169082', '169083', '169084', '169085', '169086', '169172', '169849', '169850', '173830', '174884', '175179', '175185', '175186', '175187', '176043', '176219', '176220', '176221', '176222', '176223', '176247', '176248', '176516', '176517', '176611', '176612', '176650', '176662'))))
)
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
BEP.IBLOCK_ELEMENT_ID
[[1] Can't create/write to file '/tmp/MYZPmGUv' (Errcode: 28 - No space left on device)]
DB query error.
Please try later.
|
|