SELECT
*
FROM
(SELECT
n.address,
p.id,
p.storages,
p.disk_path,
CONCAT_WS('/', LEFT(n.path, 2), n.path, p.path) p_disk_path
FROM
projects p
INNER JOIN namespace...