shazdeh

<p>This plugin gives you <code>[query]</code> shortcode which enables you to output posts filtered by specific attributes. You can format the output to your liking and even display the results in a grid of customizable columns and rows.<br />
Also supports “lenses” which can turn your query results into Tabs, Accordion, or Carousel widgets. This feature relies on Bootstrap library to be already loaded on the page, the plugin does <em>not</em> include it (for that you can use the <a href="https://wordpress.org/extend/plugins/bootstrap/" rel="ugc">Bootstrap plugin</a>). You can create new lenses or override the built-in ones in your theme to customize the output.</p>
<h4>Usage</h4>
<p>You can use all parameters supported by <a href="https://codex.wordpress.org/Class_Reference/WP_Query" rel="nofollow ugc">WP_Query class</a> to filter the posts; you can query for specific post types, categories, tags, authors, etc. You also have to define how you want to format the output:<br />
    [query posts_per_page=”5″ cat=”3″]</p>
<h3><a href="{URL}" rel="nofollow ugc">{TITLE} ({COMMENT_COUNT})</a></h3>
<p>[/query]<br />
The above shortcode will display the title of the latest 5 posts from the category with the ID of 3. Available keywords are: TITLE, CONTENT, AUTHOR, AUTHOR_URL, DATE, THUMBNAIL, CONTENT, COMMENT_COUNT and more to be added later.</p>
<h4>Grid display</h4>
<p>With the “cols” parameter you can display the output in a grid. So this:<br />
    [query posts_per_page=”3″ cols=”3″] {THUMBNAIL}</p>
<h3>{TITLE}</h3>
<p>{CONTENT} [/query]<br />
will display the latest 3 posts in the defined template, in 3 columns. If in the above snippet we set the posts_per_page option to 6, it will display the latest 6 posts in two rows that each has 3 columns.</p>
<h4>Lenses</h4>
<p>With the “lens” parameter you can display the query results in a Tab, Accordion, or Carousel widget. Example:<br />
    [query posts_per_page=”0″ post_type=”faq” lens=”accordion”]<br />
This will create an accordion widget of all our posts from the “faq” post type. This creates a carousel of latest five featured posts:<br />
    [query posts_per_page=”5″ featured=”true” lens=”carousel”]</p>
<h4>Other supported parameters</h4>
<p>Aside from wp_query parameters, the shortcode also supports additional parameters:</p>
<ul>
<li><em>featured</em> : to query for sticky posts which by default are excluded from the query.</li>
<li><em>thumbnail_size</em> : to specify the size of the {THUMBNAIL} images. You can use <a href="https://codex.wordpress.org/Function_Reference/add_image_size#Reserved_Image_Size_Names" rel="nofollow ugc">built-in image sizes</a> or custom ones you’ve defined.</li>
<li><em>content_limit</em> : to limit the number of words of the {CONTENT} var; by default it’s “0” which means it outputs the whole content.</li>
<li><em>posts_separator</em> : text to display between individual posts.</li>
</ul>


Query Shortcode

An insanely powerful shortcode that enables you to query anything you want and display it however you like.

Olar Marius

Justin Watt

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


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.

Query Shortcode vs SQL Executioner