Crosstab Query Not Working With ActiveRecord

[eluser]TheFuzzy0ne[/eluser]
The problem is that the AR class is escaping your select query and it's breaking it due to the functions. By passing FALSE as the second parameter to the select method, the fields are not escaped. It's documented in the [url="http://ellislab.com/codeigniter/user-guide/database/active_record.html"]user guide[/url].