/engine_v4.84.8v7.1/i_db.php(1447):Ошибка при отработке SQL запроса: - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
UNION ALL
-- поднимаемся вверх
SELECT g.pkey, g.parent' at line 5
WITH RECURSIVE parents AS (
-- якорь: непосредственный родитель нужного узла
SELECT g.pkey, g.parent, g.obj_name, 1 AS depth
FROM obj_site_goods g
WHERE g.pkey = (SELECT parent FROM obj_site_goods WHERE pkey = )
UNION ALL
-- поднимаемся вверх
SELECT g.pkey, g.parent, g.obj_name, p.depth + 1
FROM obj_site_goods g
JOIN parents p ON g.pkey = p.parent
WHERE g.parent IS NOT NULL
)
SELECT GROUP_CONCAT(obj_name ORDER BY depth DESC SEPARATOR ' ') AS breadcrumb
FROM parents
WHERE pkey <> 5; -- исключаем только сам корневой узел