pinned = Pin.find(:all,:conditions => [ 'pins.eid = last_modifieds.eid AND user_id = ?','arika' ], :joins => 'LEFT OUTER JOIN last_modifieds', :order => 'last_modifieds.date desc',:offset =>0,:limit => 10)
D,[22:27:06.977] Pin Load (0.0ms) Mysql::Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE (pins.eid = last_modifieds.eid AND user_id = 'arika') ORDER BY last_modif' at line 1: SELECT `pins`.* FROM `pins` LEFT OUTER JOIN last_modifieds WHERE (pins.eid = last_modifieds.eid AND user_id = 'arika') ORDER BY last_modifieds.date desc LIMIT 0, 10