select p.id, p.post_title from wp_posts p inner join wp_term_relationships tr on tr.object_id = p.ID inner join wp_terms t on tr.term_taxonomy_id = t.term_id inner join wp_term_taxonomy tt on tt.term_taxonomy_id = t.term_id where post_status =’publish’ and tt.taxonomy = ‘category’ and t.name = ‘Renewed’
To get a list of WordPress Posts using meta query in MySQL, you can use the following SQL query: SELECT p.ID, p.post_title, m.meta_id, m.meta_key, m.meta_value FROM `wp_posts` p LEFT JOIN `wp_postmeta` m ON p.ID = m.post_id WHERE m.meta_key = ‘wpcf-show-status’ AND m.meta_value ” ORDER BY p.post_title ASC This query will create a list with ID, […]
If you are using WordPress for a long time, it is possible that you have many spam comments, revisions, transients cache etc. on your wp database. In this post, I listed most useful SQL queries you can use to clean up your WordPress database and reduce its size around 85%! [toc] Tools Required My favorite tool for […]
Did you know that WordPress has a mobile detect function already? In this post, I will show you how you can use wp_is_mobile function to create a simple shortcode to hide certain parts of your posts from mobile visitors or the other way. Demonstration Desktop View Mobile View The Shortcode wp_is_mobile function returns true when […]
If you want to insert the same tags to every post on your blog post, you can set it to be done automatically using PHP. Using this simple snippet, all tags will be added automatically on post save and publish.