EllisLab/CodeIgniter — pull request #1527 by HighKickX (2012-06-24 23:01:22+00:00)
Title: Patch 1

I've had a problem with a subquery join condition, the join() function is escaping the SELECT.
More details here : http://codeigniter.com/forums/viewthread/219734/#1012948