Скачать или смотреть How to Display the Most Recently Modified Posts in WordPress Without Including Form Entries

Learn how to filter your WordPress query to display only the most recently modified posts while excluding entries from contact forms. Perfect for keeping your content list relevant and clean!
---
This video is based on the question https://stackoverflow.com/q/72863675/ asked by the user 'EnmanuelGo' ( https://stackoverflow.com/u/14311092/ ) and on the answer https://stackoverflow.com/a/72865986/ provided by the user 'silver' ( https://stackoverflow.com/u/1319623/ ) at 'Stack Overflow' website. Thanks to these great users and Stackexchange community for their contributions.

Visit these links for original content and any more details, such as alternate solutions, latest updates/developments on topic, comments, revision history etc. For example, the original title of the Question was: Display list of the last modified or updated posts in wordpress

Also, Content (except music) licensed under CC BY-SA https://meta.stackexchange.com/help/l...
The original Question post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license, and the original Answer post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license.

If anything seems off to you, please feel free to write me at vlogize [AT] gmail [DOT] com.
---
Displaying Recently Modified Posts in WordPress: A Guide

In the world of WordPress, keeping your content fresh and up-to-date is crucial for engaging your audience. However, if you’re using plugins like contact forms, you might find unexpected entries appearing in your list of recently modified posts. This can lead to clutter and confusion. Luckily, there’s a straightforward solution! In this guide, we’ll walk through how to display only the latest modified posts while excluding those pesky contact form submissions or anything else you don’t want on that list.

The Problem

You currently have a piece of WordPress code designed to fetch and display the latest modified posts. However, due to the contact form you are using, any message sent through the form is mistakenly reflected in your list of recently modified posts. This not only misleads website visitors but can also detract from the overall user experience. The goal here is to limit the displayed entries to genuine posts, pages, or custom post types.

The Solution

Adding a post_type Filter

To resolve this issue, you need to modify your existing SQL query to include a filter that specifies the types of content you want to include. Implementing this change will ensure your list accurately reflects only the content you're interested in.

How to Implement the Change

Here’s the modified code that introduces the post_type filter:

[[See Video to Reveal this Text or Code Snippet]]

Breakdown of the SQL Query

SELECT Statement: This part of the query is straightforward; you’re requesting the ID and title of the posts.

FROM Clause: Here, you specify the wp_posts table where all posts and pages are stored.

WHERE Clause:

post_status = 'publish': This ensures you are only fetching posts that are published and visible on the website.

post_modified_gmt < '$today': This filter selects those that have been modified before today, which helps to fetch only truly updated content.

post_type = 'post': This line is your filter! It ensures only posts are included in the results. If you want to include pages as well, change it to: AND post_type IN ('post', 'page').

ORDER BY: This ensures the posts are listed from the most recently modified to the oldest.

LIMIT: Notice the $count variable; it limits the number of results returned, allowing you to control the number of posts displayed.

Final Thoughts

By refining your SQL query with the post_type filter, you can ensure that your list of recently modified posts remains relevant and user-friendly. This simple code adjustment makes a huge difference, allowing you to maintain a clean list of content that enhances your site’s performance and appearance.

Implementing these changes is not just about cleaner code, but it’s about providing a better experience for your audience. Now you can confidently display your updates without the unnecessary clutter of form submissions.

If you have any questions about WordPress queries or need further assistance, feel free to reach out in the comments below!