 |
НАВИГАЦИЯ |
 |
|
|
|
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 78, 1 [nativecode=1030 ** Got error 28 from storage engine] | |
