I need help with complex relationships and queries using DataMapper

[eluser]bEz[/eluser]
@qureshi
Using the DMZ edition of DataMapper, I would have Tables/Modles setup as follows:
Did not include the Translator portion, therefore the $has_many is empty!

Code:

users :: id, ...

class User extends DataMapper {
  
   var $table = 'users';
   var $has_many = array('category');
   var $has_one = array();
  
    function User()
   {
      parent::DataMapper();
    }
    
}

Code:

categories :: id, user_id, ...
(scrap categories_users)

class Category extends DataMapper {
  
   var $table = 'categories';
   var $has_many = array('verse');
   var $has_one = array('user');
  
    function Category()
   {
      parent::DataMapper();
    }
    
}

Code:

verses :: id, category_id, ...
(scrap categories_verses)

class Verse extends DataMapper {
  
   var $table = 'verses';
   var $has_many = array('translation');
   var $has_one = array('category');
  
    function Verse()
   {
      parent::DataMapper();
    }
    
}

Code:

translations :: id, verse_id, ...
(scrap translations_verses)

class Translation extends DataMapper {
  
   var $table = 'translations';
   var $has_many = array();
   var $has_one = array('verse');
  
    function Translation()
   {
      parent::DataMapper();
    }
    
}