Skip to content

Instantly share code, notes, and snippets.

@arika

arika/re: gist:183674

Created September 9, 2009 13:31
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save arika/183711 to your computer and use it in GitHub Desktop.
Save arika/183711 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
re: gist:183674
pinned = Pin.find(:all,:conditions => [ 'user_id = ?','arika' ], :joins => 'LEFT OUTER JOIN last_modifieds ON pins.eid = last_modifieds.eid', :order => 'last_modifieds.date desc',:offset =>0,:limit => 10)
D,[22:31:17.510] Pin Load (0.6ms) SELECT `pins`.* FROM `pins` LEFT OUTER JOIN last_modifieds ON pins.eid = last_modifieds.eid WHERE (user_id = 'arika') ORDER BY last_modifieds.date desc LIMIT 0, 10
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment