Wordpress Archives - Kamran Rafi's Blog

Remove WordPress version from JS and CSS files

March 20, 2018 Kamran Rafi 0

I recently faced an issue while working on SEO of my blog. I figured that version numbers appended to js and css files is one […]

How to load WordPress posts using WP_Query

February 19, 2018 Kamran Rafi 1

In order to use WordPress methods directly to pull posts or any other data, “wp-load.php” file from the active WordPress installation is required to be […]

MySQL Query to Get WordPress Post Categories

January 1, 2018 Kamran Rafi 0

Here is pretty straight forward mysql query to get WordPress post categories. I’ve excluded the default Uncategorized category.

SELECT wt.*, wtt.taxonomy FROM wp_terms wt
inner join wp_term_relationships wtr on wtr.term_taxonomy_id = wt.term_id
inner join wp_term_taxonomy wtt on wtt.term_taxonomy_id = wtr.term_taxonomy_id
where wt.term_id <> 1 and wtr.object_id = 1

1

2

3

4

SELECT wt.*, wtt.taxonomy FROM wp_terms wt

inner join wp_term_relationships wtr on wtr.term_taxonomy_id = wt.term_id

inner join wp_term_taxonomy wtt on wtt.term_taxonomy_id = wtr.term_taxonomy_id

where wt.term_id <> 1 and wtr.object_id = 1

“wt.term_id 1″ to exclude Uncategorized Category […]

Create hierarchical view widget for WordPress posts

December 26, 2017 Kamran Rafi 0

Recently i got a chance to create a custom widget to display WordPress posts in hierarchical way, first By Year, then by Months and at […]