How to get the rowCount with results returned by query while joining tables

I would run it through phpMyAdmin Explain and see what it says.

ms = milliseconds (one thousandth of a second).

What did you Try? What did you Get? What did you Expect?

Joined CodeIgniter Community 2009.  ( Skype: insitfx )