Question: I'm learning Salesforce Marketing Cloud and experienced some unexpected behavior today.

I sent a message to a number of data extensions. The number of recipients was upwards of 70,000. Before I sent the official email I sent a test specifically to my address. Everything looked good so I used Guided Send to send to the data extensions.

This was 4 hours ago and I have not received the message yet but my coworker who sits across from me has. This coworker and I likely would have been in the same data extension.

I verified that my name and email address are in the data extension. Does it just take this long to distribute to a huge list? Did it not send to me since I received a test send? Or is something likely wrong?

I checked all folders in my email and do not see it.

Thank you

Answer: 
Also you can directly query in child object using relationship fields,

```
[select ISOOffice__Merchant_Location__c,Account__r.Name 
 from ISOOffice__Merchant_Opportunity__c where 
 ISOOffice__Opportunity_Type__c = 'New Merchant' AND 
 Account__r.Name = 'Goodwill of Southwestern Pennsylvania']

```

You need to prefix ISOOffice\_\_Merchant\_Location\_\_c with Account\_\_r, if this field is in account.
Not sure I fully follow your data model, but a [parent-child relationship query](https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql_relationships_and_custom_objects.htm#sforce_api_calls_soql_relationships_and_custom_objects) would look like this:

```
Account a = [
        select (
                select ISOOffice__Merchant_Location__c
                from ISOOffice__Merchant_Opportunities__r
                where ISOOffice__Opportunity_Type__c = 'New Merchant'
                )
        from Account
        where Name = 'Goodwill of Southwestern Pennsylvania'
        ];
for (ISOOffice__Merchant_Opportunity__c o : a.ISOOffice__Merchant_Opportunities__r) {
    String mainLocationId = o.ISOOffice__Merchant_Location__c;
    ...
}

```

assuming the conventional plural has been used for the relationship name.