shawfactor

LH Display Posts allows you easily list content from all across your website. Whilst respecting the current users capability to view the posts displayed.
Just add the [lh_display_posts] shortcode to you content. The shortcode has 5 optional parameters
<ul>
<li>post_parent: show only post/pages with the parent id specified</li>
<li>post__in: a comma separated list of post ids to query</li>
<li>post_type: the post type, this defaults to ‘post’</li>
<li>post_author: the id of the post author</li>
<li>template: see details below on how to alter the template used to output the shortcode</li>
</ul>
Like this plugin? Please consider <a href="https://wordpress.org/support/view/plugin-reviews/lh-display-posts-shortcode/" rel="ugc">leaving a 5-star review</a>.
Love this plugin or want to help the LocalHero Project? Please consider <a href="https://lhero.org/portfolio/lh-display-posts-shortcode/" rel="nofollow ugc">making a donation</a>.

LH Display Posts Shortcode

Add a listing of content on your website using a simple shortcode. Filter the results by author, post type and more.

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.

LH Display Posts Shortcode vs Run SQL Query