WP SQL Categories

Here is how to get WordPress Post categories via straight SQL query:

 

SELECT 
	wp_term_taxonomy.description, 
	wp_terms.term_id, 
	wp_terms.name, 
	wp_terms.slug
FROM wp_term_taxonomy
	JOIN wp_terms ON ( wp_term_taxonomy.term_id = wp_terms.term_id )
WHERE wp_term_taxonomy.taxonomy = 'category'