|
НАВИГАЦИЯ |
|
|
|
|
ДОБАВИТЬ СТАТЬЮ |
|
|
|
|
DB Error: unknown error
SELECT d.* ,CONCAT(r.vcsysname, '/' , d.vcurl) as vcurl ,opl.ipictureid, orl.irubricid, r.vcname as vcrubricname
FROM v_goods as d
LEFT JOIN objects_picture_link as opl ON opl.iobjectid=d.igoodsid AND opl.bmain=1
LEFT JOIN objects_rubric_link as orl ON orl.iobjectid=d.igoodsid
LEFT JOIN rubric as r ON r.irubricid=orl.irubricid
WHERE d.istateid=100 AND d.bavailable
AND EXISTS (SELECT 1 FROM objects_rubric_link as orl1
JOIN v_rubrictree as r ON r.irubricid=orl1.irubricid
WHERE orl1.iobjectid=d.igoodsid AND r.iparentid=51)
ORDER BY d.dtadded DESC
LIMIT 67, 1 [nativecode=1 ** Can't create/write to file '/tmp/#sql_506_0.MYI' (Errcode: 28)] | |