RustyBadRobot

The Display Pages Shortcode was written to allow users to easily display listings of pages without knowing PHP or editing template files, it is based heavily on the [display-posts] shortcode by Bill Erickson.
Add the shortcode in a post or page, and use the arguments to query based on tag, id, post type, and many other possibilities (see the Arguments). I’ve also added some extra options to display something more than just the title: include_date, include_excerpt, and image_size.
See the <a href="https://codex.wordpress.org/Class_Reference/WP_Query" rel="nofollow ugc">WordPress Codex</a> for information on using the arguments.
<a href="https://github.com/RustyBadRobot/display-pages-shortcode/wiki" rel="nofollow ugc">Documentation</a> | <a href="http://widgetmedia.co/display-pages-shortcode-examples/" rel="nofollow ugc">Examples</a>

Display Pages Shortcode

Display a listing of pages using the [display-pages] shortcode.

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 Pages Shortcode vs Run SQL Query