How To Get Posts Category In WordPress

Problem Can we get the list of blog posts in the following structure? Published Date Author Category Post Title Blog URL Solution 1 2 3 4 5 6 7 8 9 10 SELECT p.ID,DATE(p.post_date) Date,u.display_name Author,p.post_title Title,GROUP_CONCAT(t.name) Category, CONCAT(‘http://yourdomain.com/blog/’,p.post_name) URL FROM wp_posts p LEFT JOIN wp_users u ON p.post_author = u.ID LEFT JOIN wp_term_relationships rel ON rel.object_id = […]

Read More