IMHO, if we are changing it already, we might as well change it to an INNER SELECT style which rails 3.2+ supports.

this was done prior to that.