Bill Erickson

This plugin extends <a href="https://wordpress.org/plugins/display-posts-shortcode" rel="ugc">Display Posts</a> by letting you break your content down by month or year. You can use all of the <a href="https://displayposts.com/docs/parameters/" rel="nofollow ugc">Display Posts parameters</a> to customize the query.
Month Listing
<pre><code>[display-posts display_by_month="true" posts_per_page="999" title="Posts by Month"]
</code></pre>
Use the <code>display_by_month</code> parameter to break it down by month. To list all your content, use a high <code>posts_per_page</code>, like 999. You can also add an optional <code>title</code> to appear above the listing.
Year Listing
<pre><code>[display-posts display_by_year="true" posts_per_page="999" title"Posts by Year"]
</code></pre>
Use the <code>display_by_month</code> parameter to break it down by year. To list all your content, use a high <code>posts_per_page</code>, like 999. You can also add an optional <code>title</code> to appear above the listing.
Filters
If you’re a developer, you can use the following filters to customize the markup:
<ul>
<li><code>display_posts_date_view_heading_tag</code> – The heading tag used for date headings. Default is h4.</li>
<li><code>display_posts_date_view_heading_class</code> – The class added to the heading tag. Default is .display-posts-date.</li>
<li><code>display_posts_date_view_month_format</code> – The date format used for month headings. Default is ‘F Y’.</li>
<li><code>display_posts_date_view_year_format</code> – The date format used for year headings. Default is ‘Y’.</li>
</ul>

Display Posts – Date View

List your content broken down by month or year. This is an extension of the Display Posts plugin.

Fabricio Carella

This plugin will allow you to execute any type of SQL query into the WordPress’s DB connecting through the driver provided by the MySQLi extension without the need to use another tool like phpMyAdmin.
It also gives you the ability to export the results in a CSV format file.
In order to access this plugin’s admin page (Tools -> Run SQL Query), your account needs to have the <code>install_plugins</code> capability, that means a Super Admin in the multi-site installation or an Admin in a single site.
Feel free to contribute: 
https://github.com/Sefirost/run-sql-query
Use on you own risk. Under no circumstances will the Author of this plugin assume responsibility or liability for any damages or destructive effects on the database resulting from the queries executed using this tool.

Run SQL Query

Run SQL Query is a simple plugin to quickly execute any type of SQL query into the WordPress's DB and export the results in a CSV format file.

Display Posts – Date View vs Run SQL Query