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.

Fabricio Carella

<p>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.</p>
<p>It also gives you the ability to export the results in a CSV format file.</p>
<p>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.</p>
<p>Feel free to contribute:<br />
https://github.com/Sefirost/run-sql-query</p>
<p>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.</p>


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.

Query Shortcode vs Run SQL Query