DMZ 1.7.1 (DataMapper OverZealous Edition)

[eluser]TheJim[/eluser]
squawk, when you access a related model from your object and call get(), you're accessing only those records related to your current object. That is $b->user->get() is not going to be all User records, but only those related to whatever Buyer is stored in $b (after a call to get(), this would be the first Buyer record loaded). So that's why the WHERE clause exists in those generated queries. Your sentence "the relationship fields are also not filled for this record [your first result: Buyer 353]" explains why nothing was loaded after your calls to get() for the related objects.

It sounds like you might need to read through the manual more thoroughly to make sure you're clear on relationships. And if you're wanting those relationships included for each Buyer object, I'd especially look at the include_related function for efficiency's sake.