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.

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.

Custom Query Shortcode vs Run SQL Query