Datamapper and pagination

[eluser]kakallatt[/eluser]
How I can write a join query like that:

Code:

$this->db->select('pages.*, p.slug as parent_slug, p.title as parent_title');
  $this->db->join('pages as p', 'pages.parent_id=p.id', 'left');

Thank you very much.