WITH XMLNAMESPACES (...),
    
    EFPurchaseList ( purchaseNum ) as (
    SELECT DISTINCT
    	table.fst.value('(...) [1]', 'nvarchar(max)')
    FROM table
    	CROSS APPLY table.fst.nodes('.../.[1]') nodes(setting)
    WHERE nodes.setting.value('(...) [1]', 'nvarchar(max)') = 'value'),
    
    ApplicationList (purchaseNum,   lotNum, journalNum, participantType, inn, kpp, orgn, idNumber, countryCode, countryFullName, [status]) as (
    SELECT DISTINCT
    	secondTable.fst.value('(...) [1]', 'nvarchar(max)'),
    	'1',
    	nodes.setting.value('(...) [1]', 'nvarchar(max)'),
    	nodes.setting.value('(...) [1]', 'nvarchar(max)'),
    	nodes.setting.value('(...) [1]', 'nvarchar(max)'),
    	nodes.setting.value('(...) [1]', 'nvarchar(max)'),
    	nodes.setting.value('(...) [1]', 'nvarchar(max)'),
    	nodes.setting.value('(...) [1]', 'nvarchar(max)'),
    	nodes.setting.value('(...) [1]', 'nvarchar(max)'),
    	nodes.setting.value('(...) [1]', 'nvarchar(max)'),
    	nodes.setting.value('(...) [1]', 'nvarchar(max)')
    FROM secondTable
    CROSS APPLY secondTable.fst.nodes('.../.[1]') nodes(setting)
    ),
    
    suppliersList (purchaseNumber, lotNum, journalNum, participantType, inn, kpp, ogrn, idNumber, countryCode, countryFullName, [status], pN) as (
    SELECT *
    FROM ApplicationList INNER JOIN EFPurchaseList on EFPurchaseList.purchaseNum = ApplicationList.purchaseNum)
    
    SELECT suppliersList.inn, count(suppliersList.inn) FROm suppliersList GROUP BY suppliersList.inn