CodeCanyon - Smart Post Lists Widget for WordPress | 2 MB
Builds lists of posts based on options you choose from a form in a widget. It works similar to SQL query but no coding knowledge is required!
You can drop the widget in as many sidebars (widget areas) you like and build as many independent lists as you like. You can easily build any type of list you’d like.
Select multiple categories, tags, authors to list posts fromChoose the number of posts to list and where to start listing fromOrder the list by: author, date created, date modified, post title, id, randomSelect fields you want to show: title, date, excerpt, number of commentsSelect excerpt/text length in wordsChoose to show image on: first post only, all posts, noneSelect featured image size you’d like to use: thumbnail, medium, largeFurther customize the width or height of your imagesChoose image floatBy filling a simple form this plugin will build an SQL SELECT query, return a result set and build html code based on it. The form controls select expression, where condition, order by expression, limit expression. No coding is required!
By default the widget looks like all other widgets from the same sidebar (widget area) you drop it. It has its own CSS file that overrides the default styles for your list elements. You can use that file to further customize the front-end outlook.