ActiveRecord - What's wrong with this statement?

[eluser]stormbytes[/eluser]
[quote author="tonanbarbarian" date="1287901783"]tell us the exact query you expect it to produce
and then run the following command after the ->db->get() and see what the query is actually producing

Code:

echo $this->db->last_query();

[/quote]

I expect it to access the 'Revisions' table, retrieve the 'date' field, format the date field like I expressed, retrieve the revisions field, and return the data to the controller that called it.

Frankly I'm really stumped.

This query works just fine in mysql client locally -

In fact, it actually half-works in CI. It retrieves the data from the revision field but the date field is generating an error. I'm guessing it's got something to do with the single-quotes as I've executed similar functions in other queries without a problem.