Justin Tadlock

The Query Posts widget was written to allow users that don’t know their way around PHP to easily show posts in any way they’d like. It’s like having a cool WordPress developer as a friend ready to do your bidding. Seriously.
The widget has over 40 options to choose from. You can list posts by category, tag, custom taxonomies, author, date, time, name, or anything you can imagine. You can choose to show the full content, excerpts, or even a simple list. You can order the posts in all sorts of ways. Oh, and you can even show pages.
This is the widget that keeps users out of the code and gives them the ability to display items on their site how they want.

Query Posts

A WordPress widget that gives you unlimited control over showing posts and pages.

littlejon

LJ Subpages Widget allows you to display a menu listing subpages from a chosen page.
This plugin was developed as I needed a widget to display a list of subpages in my sidebar. All the other plugins that I found would only display subpages from the current page being displayed.
Features:
<ul>
<li>Will display the subpages of a chosen Parent page (as of version 1.1 will show subpages of current page if required).</li>
<li>Customizable Title with the choice of using the Parent Page Title or writing your own</li>
<li>Compatible with subpages of subpages. You have the option of displaying Subpages of the Subpages being displayed (This is theme dependant, your theme must support submenus in the sidebar for this option to function as expected)</li>
<li>If there are no subpages to display the widget outputs nothing rather then leaving a heading without any content</li>
</ul>
This widget was built using the new WordPress Widget API and as such it supports multi instance copies. For this reason it means that this widget is only supported by WordPress 2.8 and above. If you have a requirement for this plugin for a version of WordPress lower then 2.8 please contact me on the plugins homepage via a comment.

LJ Subpages Widget

LJ Subpages Widget allows you to display a menu listing subpages from a chosen page.

Query Posts vs LJ Subpages Widget