Mutiple SQL count() from several tables

[eluser]oliviermarian[/eluser]
hello,
is there a proper way to code this using active record CI code, or is it better to use the sql query syntax ?

I mean:

Code:

$sql="SELECT users.name, user.address, users.mail,
COUNT(pm.*) AS total_pm, COUNT(posts.*) AS total_posts, COUNT(login.*) AS total_login
FROM users
INNER JOIN pm ON users.id=pm.user
INNER JOIN posts ON users.id=posts.user
INNER JOIN login ON users.id=login.user
WHERE id=102";
$data['query'] = $this->db->query($sql);

or something like

Code:

this->db->select('users.name, user.address, users.mail');
$this->db->from('users');
$this->db->join("pm", "users.id=posts.user");
$this->db->join("posts", "users.id=posts.user");
$this->db->join("login", "users.id=login.user");
$this->db->stop_cache();
$total = $this->db->count_all_results();
$query = $this->db->get();
$this->db->flush_cache();
return $query->result();

1 - I don't know if it works
2 - Is it worth trying once we have the sql query working ?