Help with SELECT statement

[eluser]Samuurai[/eluser]
Thanks a lot everyone !

This is how my code turned out after I dumbed it down

Code:

$this->db->select('downtime.*, application.name AS appname, device.name AS devname');
$this->db->join('application', 'application.id = downtime.application_id', 'left');
$this->db->join('device', 'device.id = downtime.device_id', 'left');
$this->db->where('status = 1');
$query = $this->db->get('downtime');