SELECT COUNT(*) AS COUNT
FROM (
SELECT Account.*
FROM Account
LEFT JOIN OCE__accountterritoryfields__c
ON oce__accountterritoryfields__c.oce__account__c = account.uid
LEFT JOIN OCE__accountaddress__c
ON oce__accountaddress__c.uid = oce__accountterritoryfields__c.oce__preferredaddress__c
LEFT JOIN recordtype  ON recordtype.uid == Account.recordtypeid
WHERE OCE__AccountAddress__c.oce__emailrestriction__c == '1'
AND OCE__AccountTerritoryFields__c.OCE__preferredaddress__c
IS NOT NULL AND recordtype.developername = 'Ins_Doc'
COLLATE nocase
GROUP BY Account.uid
)