WP:获取特定术语id的wp_post，wp_meta_value[contact]

Question

我一直在试图弄清楚如何根据术语ID来获取wp_meta_value。

这就是我到目前为止所在的地方，但现在我的头都晕了！如果您能帮忙，我将不胜感激:)

谢谢

SELECT wp_posts.post_title
FROM wp_posts
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
)
WHERE wp_posts.post_status =  'publish'
AND wp_term_taxonomy.term_id =2
ORDER BY post_title DESC 
LIMIT 0 , 30

Answer 1

这似乎起作用了..。

    SELECT wp_posts.post_title, wp_postmeta.meta_value AS  'Contact Details'
FROM wp_posts
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_postmeta ON ( wp_postmeta.post_id = wp_posts.ID ) 
WHERE wp_posts.post_status =  'publish'
AND wp_postmeta.meta_key =  'contact'
AND wp_term_taxonomy.term_id =2
ORDER BY post_title;