SQL Query to Get Posts Using Category Name

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’

Read more SQL Query to Get Posts Using Category Name

[How to] Find Which Page Template Is Used By WordPress

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

[How to] Redirect To Single Post If There Is One Post In Archive

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