Active Query bug?

PHP Code:

Error Number: 1052

Column 'id' in field list is ambiguous

SELECT `id`, `s_cities`.`id` as `source_city_id`, `d_cities`.`id` as `destination_city_id`, `jobs_raw`.* FROM `jobs_raw` LEFT JOIN `cities` as `s_cities` ON `s_cities`.`realName`=`jobs_raw`.`source_city` LEFT JOIN `cities` as `d_cities` ON `d_cities`.`realName`=`jobs_raw`.`destination_city` WHERE `jobs_raw`.`id` = '38567' 


PHP Code:

$this->db->select('s_cities.id as source_city_id, d_cities.id as destination_city_id, jobs_raw.*');
$this->db->join('cities as s_cities', 's_cities.realName=jobs_raw.source_city', 'left');
$this->db->join('cities as d_cities', 'd_cities.realName=jobs_raw.destination_city', 'left');
$this->db->where('jobs_raw.id', $id);
$this->db->get('jobs_raw')->row(); 


Notice the Select `id`in the first code block. Its an error that should not happen since that selection is not made in the code. Yet this error shows up. But the funny thing is here that doing this on a different codeigniter install of mine makes it work flawless. Same database, same versions. Latest 3.X