我需要一个特定post\\u类型的帖子列表，外加一个自定义分类术语的名称。

这就是我目前得到的

SELECT p.post_name,t.name as clientName 
FROM $wpdb->posts AS p, $wpdb->terms AS t
LEFT JOIN $wpdb->term_relationships AS tr ON (\'p.ID\' = tr.object_id)
LEFT JOIN $wpdb->term_taxonomy AS tt ON (tr.term_taxonomy_id = tt.term_taxonomy_id)
LEFT JOIN $wpdb->terms AS t2 ON (t2.term_id = tt.term_id)
WHERE   p.post_status = \'publish\' 
    AND p.post_type = \'portfolio\'
    AND tt.taxonomy = \'clients\' 
ORDER BY p.post_date DESC

有什么问题？我得到了太多的结果，我得到了正确的帖子，但每个客户都有好几次。我想这是因为我使用$wpdb->术语作为t和t2？但当我尝试将其用作t时，两次都会出现错误

Not unique table/alias: \'t\'

谁能帮忙？

SELECT p.post_name, t.name as clientName 
FROM $wpdb->posts AS p
INNER JOIN $wpdb->term_relationships AS tr ON (\'p.ID\' = tr.object_id)
INNER JOIN $wpdb->term_taxonomy AS tt ON (tr.term_taxonomy_id = tt.term_taxonomy_id)
INNER JOIN $wpdb->terms AS t ON (t.term_id = tt.term_id)
WHERE   p.post_status = \'publish\' 
    AND p.post_type = \'portfolio\'
    AND tt.taxonomy = \'clients\' 
ORDER BY p.post_date DESC