select Id,Name,Name__c,
(SELECT Id FROM CombinedAttachments where id!=null)
from Offer__c 
order by CreatedDate desc