SELECT DISTINCT companies."symbol", warehouses."id", CategoryTreeResult."categoryTreeId", CategoryTreeResult."categoryTreeName", product."id", product."productName"
    FROM public."products" products

INNER JOIN public."warehousesTOcompanies" wTOc ON wTOc."id" = products."linkWarehouseCompany"
    INNER JOIN public."warehouses" warehouses ON warehouses."id" = wTOc."warehouseId"
INNER JOIN public."companies" companies ON companies."id" = wTOc."companyId"
    INNER JOIN public."usersTOcompanies" uTOc ON uTOc."companyId" = companies."id"
        INNER JOIN public."users" users ON users."id" = uTOc."userId"

INNER JOIN public."productList" product ON product."id" = products."productId"
    INNER JOIN public."productsTOcategories" pTOc ON pTOc."productId" = product."id"
        INNER JOIN public."productCategories" categories ON categories."id" = pTOc."categoryId"

CROSS JOIN LATERAL
(
        WITH RECURSIVE CategoryTree("id", "categoryName", "prevId", "level") AS (
        SELECT public."productCategories"."id", public."productCategories"."categoryName", public."productCategories"."prevId", 1 AS level
            FROM public."productCategories"

        WHERE id = categories."id"

        UNION ALL

        select categories."id", categories."categoryName", categories."prevId", categoryTree."level" + 1
            FROM public."productCategories" categories
                JOIN categoryTree ON categories."id" = categoryTree."prevId"
    )

    SELECT array_to_string(array_agg(distinct "id"), '/') as "categoryTreeId", string_agg("categoryName", '/') as "categoryTreeName"
        FROM (
        SELECT "id", "categoryName", "level"
            FROM categoryTree
            ORDER BY "level" DESC
        ) as result
) AS CategoryTreeResult

where
    companies."visible" = true AND
--  users."identity" = 'JzvA9K7itD2pdQOkvfNtrUMX68S3KMOpC6XnJMPnTxiJYORJ0UAt5W6OETkc0da9dRKt9'
    users."identity" = 'zYEN77mIwJBfkcFBonda5TFjAAwCPAD3q6lzM52KbBc5RnRFiRrv3N6lbLVCO6Jbx74c5'