List and Show WordPress Posts To Allow Comments and Pings
The most used blog publishing platform WordPress permits the individual author for superseding the global discussion settings. You may change the settings to permit the reader for posting comments on your article, or you could even permit the link notification (aka trackback and pingback) from the other blogs at particular page level or post.
Using this feature you can allow all latest pages and posts to be produced with pings on and comments, and it can be always disabled on particular pages or posts when required.
When it comes to maintenance, WordPress does not offer a simple mode to display all paged articles or posts which contains its pings and comments. For the Bloggers who would like to make out a list of the articles and blog posts which has banned visitors and readers, can use the following trick to leave comments.
By using this trick you can stop other Blogs to trackback or pingback, and you can list out every page and post which is presently set to pingback/trackback and comment off.
Primarily, you will need to sign in to the MySQL database as it controls the WordPress blog. After that you need to the next query statement of SQL, so as to dig up all pages or posts where the comments and pings are not permitted.
SELECT * FROM `wp_posts` where `comment_status` <> 'open' or `ping_status` <> 'open';
Note: If you want to make the assortment as of database much easier, it is suggested to apply phpMyAdmin otherwise any else GUI interface to the MySQL database.
The above query will return every row (together pages and posts) in WordPress which contains either “Allow Pings” or “Allow Comments” set to disabled (uncheck). You can use only “ping_status” or “comment_status” intended for the articles that never allows trackback and pingback.
Both ping_status and comment_status field contains simply two easily understandable values which are open and closed. Open stands for allow whereas closed for not allowed.