klongdesigns · May 13, 2014 19:07
diff --git a/SQL Query to pull post title, name and cateogry b/SQL Query to pull post title, name and cateogry
 SELECT post.post_title, post.post_name, tt.name
 FROM  `wp_posts` AS post
 INNER JOIN  `wp_term_relationships` AS terms ON ( post.ID = terms.object_id ) 
 INNER JOIN  `wp_term_taxonomy` AS tax ON ( terms.term_taxonomy_id = tax.term_taxonomy_id ) 
 INNER JOIN  `wp_terms` AS tt ON ( tax.term_id = tt.term_id ) 
 WHERE post.post_type =  'post'
	SELECT post.post_title, post.post_name, tt.name
	FROM `wp_posts` AS post
	INNER JOIN `wp_term_relationships` AS terms ON ( post.ID = terms.object_id )
	INNER JOIN `wp_term_taxonomy` AS tax ON ( terms.term_taxonomy_id = tax.term_taxonomy_id )
	INNER JOIN `wp_terms` AS tt ON ( tax.term_id = tt.term_id )
	WHERE post.post_type = 'post'