Bill Erickson

CultivateWP

Display Posts allows you easily list content from all across your website. Start by adding this shortcode in the content editor to display a list of your most recent posts:
<pre><code>[display-posts]
</code></pre>
Filter by Category
To only show posts within a certain category, use the category parameter:
<pre><code>[display-posts category="news"]
</code></pre>
Display as Post Grid
You can create a great looking, column-based grid of posts with a bit of styling. <a href="https://displayposts.com/2019/01/04/post-grid-styling/" rel="nofollow ugc">Here’s how!</a>
List Popular Posts 
You can highlight your popular content in multiple ways. If you want to feature the posts with the most comments, use:
<pre><code>[display-posts orderby="comment_count"]
</code></pre>
You can also list <a href="https://displayposts.com/2019/01/04/most-popular-posts-by-social-shares/" rel="nofollow ugc">most popular posts by social shares</a>.
Include thumbnails, excerpts, and more 
The <a href="https://displayposts.com/docs/parameters/#display-parameters" rel="nofollow ugc">display parameters</a> let you control what information is displayed for each post. To include an image and summary, use:
<pre><code>[display-posts include_excerpt="true" image_size="thumbnail"]
</code></pre>
You can use any image size added by WordPress (thumbnail, medium, medium_large, large) OR any custom image size added by your theme or other plugins.
Sort the list however you like 
By default the listing will list the newest content first, but you can order by title, menu order, relevance, content type, metadata, and more.
List upcoming events 
You can easily list upcoming events from any event calendar. Each plugin will require slightly different code.
Here are <a href="https://displayposts.com/tag/events/" rel="nofollow ugc">tutorials for popular event calendar plugins</a>. If your plugin is not listed here, submit a support request and I’ll add it!
Tutorials 
<a href="https://displayposts.com/tutorials/" rel="nofollow ugc">Our tutorials</a> cover common customization requests, and are updated often.
Full Documentation
<ul>
<li><a href="https://displayposts.com/docs/parameters/#query-parameters" rel="nofollow ugc">Query parameters</a> for customizing which posts are listed (filter by category, tag, date…)</li>
<li><a href="https://displayposts.com/docs/parameters/#display-parameters" rel="nofollow ugc">Display parameters</a> determine how the posts appear (title, excerpt, image…)</li>
<li><a href="https://displayposts.com/2019/01/04/use-template-parts-to-match-your-themes-styling/" rel="nofollow ugc">Template parts</a> for Display Posts to perfectly match your theme’s post listings</li>
<li><a href="https://displayposts.com/docs/the-output-filter/" rel="nofollow ugc">Output filter</a> for complete control over how the listing looks on your site</li>
<li><a href="https://displayposts.com/docs/parameters/#display-parameters" rel="nofollow ugc">Filters</a> for even more powerful customizations for developers</li>
</ul>
Extensions
<ul>
<li><a href="https://github.com/billerickson/Display-Posts-Pagination" rel="nofollow ugc">Display Posts – Pagination</a> – Allow results of Display Posts to be paginated</li>
<li><a href="https://wordpress.org/plugins/display-posts-date-view/" rel="ugc">Display Posts – Date View</a> – Lets you break your content down by month or year.</li>
<li><a href="https://github.com/billerickson/Display-Posts-Alpha-View" rel="nofollow ugc">Display Posts – Alpha View</a> – Display an alphabetical listing of your content, broken down by letter</li>
<li><a href="https://github.com/billerickson/Display-Posts-Transient-Cache" rel="nofollow ugc">Display Posts – Transient Cache</a> – Cache the output using transients</li>
<li><a href="https://github.com/billerickson/dps-coauthor-addon" rel="nofollow ugc">Co-Authors Plus Addon</a> – multiple authors on posts</li>
<li><a href="https://github.com/billerickson/dps-columns-extension" rel="nofollow ugc">Columns Extension</a> – display posts in columns</li>
<li><a href="https://github.com/billerickson/DPS-Exclude-Sticky" rel="nofollow ugc">DPS Exclude Sticky</a> – exclude sticky posts unless specifically requested</li>
<li><a href="https://github.com/shazahm1/Display-Posts-Shortcode-Pinch-Zoomer" rel="nofollow ugc">DPS Pinch Zoomer</a> – adds support pinch zooming post images on mobile devices and mouse wheel zooming on desktops</li>
<li><a href="https://github.com/shazahm1/Display-Posts-Shortcode-Remote" rel="nofollow ugc">Display Posts Shortcode Remote</a> – display posts from a remote WordPress site utilizing the WP REST API.</li>
</ul>

Display Posts – Easy lists, grids, navigation, and more

I have hardly any page that does not use this plugin to display information extracted from posts. By using its hooks, I am able to generate carousels, accordions, and lists of posts for alerts, news, faqs, fundraisers, booking calendar, events, testimonials, and so on.

Swissknife for posts


nothing shows, or incompatible with woocommerce. no idea why, but i replaced this plugin by simple php snippets. much easier.


does not work at all


Any plugin coming from Bill Erickson can be trusted as an excellent coded tool!



And this Display Posts plugin doesn't disappoint.



If you're looking for an easy way to add posts anywhere you want without hacking theme files, the Display Posts plugin is the one you want to install! Lightweight and highly customisable.



Thanks Bill!  


Excellent

Add a listing of content on your website using a simple shortcode. Filter the results by category, author, 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.

Display Posts – Easy lists, grids, navigation, and more vs Run SQL Query