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.

Olar Marius

Justin Watt

Instead of needing a tool like <a href="http://www.phpmyadmin.net/home_page/index.php" rel="nofollow ugc">phpMyAdmin</a> 
or the mysql command line client to view and modify your WordPress database, 
the SQL Executioner allows you to run arbitrary SQL queries against your 
WordPress database from within the Admin. In many cases this allows you to bypass 
the inherent limitations of the WordPress Admin interface, and use the full expressive 
power of SQL to analyze and update your blog’s database.
To use simply install and visit the Tools > SQL Executioner page.
If you’re interested in contributing to the code behind this plugin, it’s also hosted on GitHub: 
https://github.com/justincwatt/wp-sql-executioner

SQL Executioner

This plugin seems to me simple but very useful.

Simple and efficient

I use this plugin on a daily basis to run quick queries in the database while developing. Very very helpful!!!

Amazing Tool

Execute arbitrary SQL queries against your WordPress database from the Admin.

Display Pages Shortcode vs SQL Executioner