Unnamed

$query = $this->db->select('clients.name, sites.name')
			->from('clients');
			->join('sites_table', 'clients.site_id = sites_table.site_id');
			->join('sites', 'sites_table.site_id = sites.site_id');
			->orderby('clients.name', 'DESC');
			->get();