Переход с ShopDesk

SELECT     tovar.tovar_number AS Code,     LTRIM(ISNULL(tc.min_tovar_bar_code, '')) AS Barcode,     LTRIM(CASE         WHEN LEFT(ISNULL(tc.otherbrcd, ''), 1) = ',' THEN STUFF(ISNULL(tc.otherbrcd, ''), 1, 1, '')         ELSE ISNULL(tc.otherbrcd, '')     END) AS BarcodeOther,     LTRIM(tovar_name) AS DisplayName,     LTRIM(izmer.izmer_name) AS Measure,     LTRIM(CASE         WHEN LEFT(ISNULL(ext_kat_name, ''), 1) = '\' THEN STUFF(ISNULL(ext_kat_name, ''), 1, 1, '')         ELSE ISNULL(ext_kat_name, '')     END) AS GoodGroup,     ISNULL(cena_rozn_sprav, 0) AS PriceOUT,     ISNULL(last_cena_opt, 0) AS PriceIN FROM tovar     LEFT JOIN izmer ON izmer.izmer_number = tovar.izmer_number     LEFT JOIN (         SELECT             tc1.tovar_number,             LTRIM(tc1.min_tovar_bar_code) AS min_tovar_bar_code,             LTRIM(REPLACE(tc2.other_tovar_barcodes, tc1.min_tovar_bar_code, '')) AS otherbrcd     FROM (             SELECT                   tovar_number,                   MIN(tc1.tovar_bar_code) AS min_tovar_bar_code             FROM tovar_code tc1             GROUP BY tovar_number     ) AS tc1     LEFT JOIN (             SELECT                   tovar_number,                   STRING_AGG(CAST(LTRIM(tc2.tovar_bar_code) AS NVARCHAR(MAX)), ',') AS other_tovar_barcodes     FROM tovar_code tc2     GROUP BY tovar_number     ) AS tc2 ON tc1.tovar_number = tc2.tovar_number ) tc ON tc.tovar_number = tovar.tovar_number     LEFT JOIN kat ON kat.kat_number = tovar.kat_number ORDER BY 1;