Like Drupal Views but for WordPress, The Loops allows you to query the database for content and display it in a page without having to write php code.
For an automatic installation through WordPress:
Or use a nifty tool by WordPress lead developer Mark Jaquith:
For a manual installation via FTP:
the-loopsdirectory to the
To upload the plugin through WordPress, instead of FTP: