CodeCanyon - Smart Post Lists Widget for WordPress v2.0 (Update)

Builds post lists based on options you choose from a form in a widget. It works similar to SQL query but no coding knowledge is required. Check out the Live preview and the Video Preview above.
You can drag & drop the widget in as many sidebars or custom widget areas as you like and build as many independent lists as you like. You can easily build any type of list you'd like.