$pages = $wpdb->get_results("
	SELECT post_title, ID identificativo FROM wp_posts
	JOIN wp_term_relationships
		ON wp_term_relationships.object_id = wp_posts.ID
	JOIN
		wp_term_taxonomy
		ON wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id
	JOIN
		wp_terms
		ON wp_term_taxonomy.term_id = wp_terms.term_id
	WHERE 
		wp_terms.name = '" . GLOSSARYCAT . "'
	AND
		wp_posts.post_type = 'post'
");

Query to get posts by category - Wordpress

sql, wordpress, category, query

PHP