Active Record + Join SQL Problem

[eluser]PV-Patrick[/eluser]
I have been changing this over and over trying to get it to work so this doesn't exactly work how I would like it as I can't get the order_by function to work. This is also the stripped down version of setting alias for items with same column names.

Code:

$this->db->select("table1.*, table2.*");
$this->db->select("table3.*, table4.*");
$this->db->join('table2', 'table1.id = table2.id', 'left');
$this->db->join('table3', 'table1.id = table3.id', 'left');
$this->db->join('table4', 'table1.id = table4.id', 'left');
$this->db->where('table1.id', $id);
//$this->db->order_by('timestamp desc');
$this->db->limit(15);

$this->db->get('table1')