$this->db->get_where only returns 1 row

Hmm - that all looks correct. My thoughts are:

1. Maybe there is a control character in one of the rows? In this case try a WHERE `Name_Alpha` LIKE '%A%' query and see if you are given different results.
2. In your phpymyadmin (or whatever) run the raw query - what result do you get?

Tried that and it returned 2 rows.

I'm going to alter the query so it doesn't use Query Builder functions.  I'm much happier writing out the full SQL statement and it might reveal what the issue is.