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
Most of the users don’t reach your second page on an archive page, so why not randomize your archive pages to get some hits for your older content.
For a good SEO you need the right keywords in your title. Not too much but the most relative ones. We all use categories on our blog. And those make great keywords. But do we use their power for SEO in a right way? Here I will show you how to add category to your […]
Read more [SEO Tip] How to Add Post Category to Document Title
Archive indexes are a good way to organize your posts, but if there is only one post in an archive page it can be just a waste of time. Here i will give you a small #snippet to jump directly to the post page.
Read more [How to] Redirect To Single Post If There Is One Post In Archive