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’
Templating is a great feature of WordPress blogging system. If you want to build a CMS system using WordPress, you will be using lots of them. You can use different templates for each category, tag, page, etc. But sometimes this gets confusing. In this post I will give you a simple snippet to find out […]
Read more [How to] Find Which Page Template Is Used By WordPress
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.
Read more [How to] Insert Post Tags Automatically on Post Save
Facebook Meta Tags version 0.6 is now released. With this new version, I fixed a minor bug that prevented site logo to be shown for posts that doesn’t have a thumbnail. If you don’t know how to add default logo you can read article here. To get the latest version, visit Facebook Meta Tags plugin […]
New version (0.5) for Facebook Meta Tags plugin is here. In this new version I fixed several issues, including no-thumbnail error for pages, errors in page excerpts and thumbnail size problems in sharing. I also added a plugin options page. You can easily setup default logo URL, admins for your site and an App ID […]