ActiveRecord, MySQL with DATE_SUB ... how?

[eluser]cahva[/eluser]
Theres nothing wrong using DATE_SUB I think but I think its cleaner not to use it if you really dont need to use it

The created2 column I got straight from your first post so dont blame me I see that you created an alias for that in the earlier select so thats something to investigate why it wouldnt work. In common sense it should have worked. Maybe if you put generated query we could see whats that all about.