Common query conditions

Use/Abuse with_scope or have custom finders.

This guys has got quite a few things to say about what you ask:

http://errtheblog.com/post/41