title: SOQL Account query for custom object related to opportunities
body: <p>I'm trying to figure out how to query a custom object that is related to opportunities. </p>
  
  <p>The object name is McaApp__Offer__c 
  The lookup field for that object is McaApp__Opportunity__c (master-detail)</p>
  
  <p>This is what I have, but I'mk missing something as this object is not related to accounts, what do I need to change?</p>
  
  <pre><code>SELECT id, Name, 
    ( 
      Select Id, Name From Opportunities ORDER BY Id DESC LIMIT 1 
    ), 
    ( 
      SELECT McaApp__Funder__c, McaApp__Status__c FROM McaApp__Offers__r WHERE McaApp__Opportunity__c = 'oppidxxx' 
    )   
  FROM Account 
  WHERE id = 'acctidxxx'
  </code></pre>