Seleccionar ultimos 10 post wordpress

[gerazmv]

Hola necesitaria listar por medio de php sin usar el wordpress
las ultimas 10 urls de los post del wordpress

en reliadad solo necesito la consulta
que me de
categoria/url post/


SELECT * FROM wp_posts
LEFT JOIN wp_postmeta ON(wp_posts.ID = wp_postmeta.post_id)
LEFT JOIN wp_term_relationships ON(wp_posts.ID = wp_term_relationships.object_id)
LEFT JOIN wp_term_taxonomy ON(wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id)
LEFT JOIN wp_terms ON(wp_term_taxonomy.term_id = wp_terms.term_id) WHERE wp_posts.post_status = 'publish'
ORDER BY wp_posts.post_date DESC limit 10";