کوئری برای دریافت دیتا از وردپرس

پیدا کردم میزارم شاید به درد کسی خود

SELECT wpposts.posttitle AS ‘title’, wpposts.postauthor AS ‘userid‘, wpposts.postcontent AS ‘content‘, wpterms.name AS ‘cateogry’ FROM wpposts INNER JOIN wptermrelationships ON wpposts.ID = wptermrelationships.objectid INNER JOIN wpterms ON wptermrelationships.termtaxonomyid = wpterms.termid INNER JOIN wptermtaxonomy ON wptermrelationships.termtaxonomyid = wptermtaxonomy.termtaxonomyid WHERE wpposts.posttype = 'post' AND wpposts.postauthor = 16 AND wptermtaxonomy.taxonomy = 'category';