SELECT Id
FROM Account
WHERE Id IN (SELECT Account__c FROM Deliverable__c WHERE RecordType.DeveloperName = 'Emergency')
LIMIT 100