shazdeh

Peter Hebert

This plugin gives you <code>[query]</code> shortcode which enables you to query and output any posts filtered by specific attributes.
<h4>Usage</h4>
You can use most 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.
<h4>Other supported parameters</h4>
Aside from WP_Query parameters, the shortcode also supports the following additional parameters:
<ul>
<li>featured: to query for sticky posts which by default are excluded from the query.</li>
<li>thumbnail_size: 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>content_limit: to limit the number of words of the {CONTENT} var; by default it’s “0” which means it outputs the whole content.</li>
<li>posts_separator: text to display between individual posts.</li>
<li>lens: custom output template – see description below.</li>
<li>twig_template: output template using Twig templating engine – requires the Timber library.</li>
</ul>
<h4>Formatting the output</h4>
You can define how you want to format the output inline within an opening <code>[query]</code> and closing <code>[/query]</code> tag. 
Available keywords are: TITLE, CONTENT, AUTHOR, AUTHOR_URL, DATE, THUMBNAIL, CONTENT, COMMENT_COUNT.
The following example will display the latest 5 posts from the category with the ID of 3, showing a post title and comment count, with a link to the post: 
 [query posts_per_page=”5″ cat=”3″]
<h3><a href="{URL}" rel="nofollow ugc">{TITLE} ({COMMENT_COUNT})</a></h3>
[/query]
Grid display
With the “cols” parameter you can display the output in a grid. 
 [query posts_per_page=”3″ cols=”3″] {THUMBNAIL}
<h3>{TITLE}</h3>
{CONTENT} [/query] 
will display the latest 3 posts in the defined template, in 3 columns. 
The plugin will automatically divide the grid into rows based upon the ‘posts_per_page’ option, divided by the ‘cols’ option.
<h4>Lenses (output templates)</h4>
With the “lens” parameter you can customize the display of the query results using a template. Some basic lenses/templates are provided:
<ul>
<li>ul: unordered list of linked post titles.</li>
<li>ul-title-date: same as ‘ul’, but also displays the posted date.</li>
<li>article-excerpt: series of articles, with a header containing the linked post title, and the excerpt.</li>
<li>article-excerpt-date: same as ‘article-excerpt’, but also displays the posted date.</li>
<li>cards: displays the post thumb above the header with linked post title, followed by the excerpt.</li>
</ul>
Bootstrap lenses
Some pre-defined lenses/templates are provided which use JavaScript Components from the <a href="http://getbootstrap.com/" rel="nofollow ugc">Bootstrap</a> CSS framework. The generated markup is compliant with the 5.x version of Bootstrap.
This feature relies on Bootstrap library to be already loaded on the page, the plugin does not include it.
If you’re using a Bootstrap-based theme, this should work; otherwise you can use the <a href="https://wordpress.org/extend/plugins/bootstrap/" rel="ugc">Bootstrap plugin</a>).
<a href="http://getbootstrap.com/javascript/#tabs" rel="nofollow ugc">Tabs</a>
This will show the latest 3 posts in a tabbed widget. 
 [query posts_per_page=”3″ lens=”tabs”]
<a href="http://getbootstrap.com/javascript/#tabs" rel="nofollow ugc">Accordion</a>
This will create an accordion widget of all our posts from the “faq” post type. 
 [query posts_per_page=”0″ post_type=”faq” lens=”accordion”]
<a href="http://getbootstrap.com/javascript/#carousel" rel="nofollow ugc">Carousel</a>
This creates a carousel of latest five featured posts: 
 [query posts_per_page=”5″ featured=”true” lens=”carousel”]
Custom Lenses/templates
You can create your own custom templates and put them into one of these pre-defined folder names within your theme:
<ul>
<li>‘query-shortcode-templates’</li>
<li>‘partials/query-shortcode-lenses/’</li>
<li>‘html/lenses/’</li>
</ul>
Or simply specify your own subfolder in the ‘lens’ parameter: 
 [query lens=”folder/template-name”]
<h4>Twig Template Support</h4>
Starting with version 0.4, you can use Twig templates for your output. Support for Twig is provided by the <a href="https://github.com/timber/timber" rel="nofollow ugc">Timber</a> library.
This requires that Timber 2.x be installed as a <a href="https://timber.github.io/docs/v2/installation/installation/" rel="nofollow ugc">Composer dependency</a>.
To use a Twig template for your query output, simply use the 'twig_template' parameter instead of the 'lens' parameter, and provide the path to your template. By default, Timber looks within the <code>views</code> folder in your active theme. You can <a href="https://timber.github.io/docs/v2/guides/template-locations/#changing-the-default-folder-for-twig-files" rel="nofollow ugc">change the default template location</a> in Timber.
Examples:
<pre><code>[query twig_template="template-name.twig"]
[query twig_template="folder/template-name.twig"]
</code></pre>

Custom Query Shortcode

A powerful shortcode that enables you to query anything you want and display it however you like, on both pages and posts, and in widgets.

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.

Custom Query Shortcode vs SQL Executioner