scribu

Smart Archives Reloaded allows you to display a list of posts grouped by year and month. It also provides several interesting navigation elements.
Format list:
<ul>
<li>list = a list of posts grouped by month</li>
<li>block = a compact block of links to year and date archive pages</li>
<li>menu = a two-level menu with links to year and date archive pages</li>
<li>both = block + list (<a href="http://scribu.net/archive" rel="nofollow ugc">example</a>)</li>
<li>fancy = menu + list + JavaScript (<a href="http://www.conceptfusion.co.nz/archive" rel="nofollow ugc">example</a>)</li>
</ul>
No support
I do not offer support for this plugin, either free or paid.
Credits:
<ul>
<li><a href="http://justinblanton.com" rel="nofollow ugc">Justin Blanton</a>, for the original <a href="http://justinblanton.com/projects/smartarchives/" rel="nofollow ugc">Smart Archives</a> plugin</li>
<li><a href="http://www.conceptfusion.co.nz/" rel="nofollow ugc">Simon Pritchard</a>, for the fancy format</li>
</ul>
Links: <a href="http://scribu.net/wordpress/smart-archives-reloaded" rel="nofollow ugc">Plugin News</a> | <a href="http://scribu.net" rel="nofollow ugc">Author’s Site</a>

Smart Archives Reloaded

Easily display posts grouped by year and month, in one or more elegant formats

OTWthemes

You can create a fully functional website using this widget. Check out the showcase. 
Drag & drop the widget in as many sidebars or custom widget areas as you like and build as many independent lists as you like. It is very easy to build any type of list you’d like. 
It works similar to SQL query but no coding knowledge is required! 
<a href="http://otwthemes.com/demos/smart-post-lists-light/?utm_source=wp.org&utm_medium=page&utm_content=demo&utm_campaign=spll" rel="nofollow ugc">Check out demo site</a>
<blockquote>
<a href="https://1.envato.market/c/1246358/275988/4415?subId1=spl&subId2=2020&subId3=https%3A%2F%2Fcodecanyon.net%2Fitem%2Fsmart-post-lists-widget-for-wordpress%2F935289&u=https%3A%2F%2Fcodecanyon.net%2Fitem%2Fsmart-post-lists-widget-for-wordpress%2F935289" rel="nofollow ugc">Upgrade to Pro Version</a> | 
 <a href="http://www.youtube.com/watch?v=4A8q7UQJzLg" rel="nofollow ugc">Video demonstration</a>.
</blockquote>
How it works
Go to your widgets section. Drag and Drop the widget in a sidebar(widget area) that you want your list to appear in. Fill in the form and click save. Here are the options you can choose from:
<ul>
<li>Select multiple categories and tags to list posts from.</li>
<li>Choose the number of posts to list and where to start listing from.</li>
<li>Order the list by: author, date created, date modified, post title.</li>
<li>Order to display posts: ascending, descending.</li>
<li>Select fields you want to show: title, date, excerpt, number of comments.</li>
<li>Select excerpt length in words</li>
<li>Choose to show image on: all posts, first only or none</li>
<li>Choose size of the image: thumb, medium, large</li>
<li>Choose image float: top of text, left of text, right of text</li>
</ul>
By 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!
Showcase
You can create a fully functional website using this widget. Get some ideas at the <a href="http://otwthemes.com/demos/smart-post-lists-light/?utm_source=wp.org&utm_medium=page&utm_content=demo&utm_campaign=spll" rel="nofollow ugc">demo site</a>.
<ul>
<li>Sidebar examples</li>
<li>Footer examples</li>
<li>Blog examples</li>
<li>Portfolio example</li>
<li>Products example</li>
<li>Widgetized page</li>
</ul>
Customize front-end
By default the widget looks like all other widgets from the same sidebar (widget area) you drop it in. 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.
Get more of this plugin
Most themes for WordPress will come with default sidebars and a few footer areas where you can drop widgets in. If you want to have custom widget areas for instance in content areas of your pages and post, or any other area of your site:
<ul>
<li>Create your custom widget areas by using a plugin. It’s fast and easy.</li>
<li>Create your custom widget areas by little coding – advanced users.</li>
<li>Use an advanced theme with more widget areas defined.</li>
</ul>

Smart Post Lists Light

Create custom post lists based on options you choose from a form in a widget. Different types of lists, blog, portfolio, services pages. No coding.

Smart Archives Reloaded vs Smart Post Lists Light