我正在开发一个用于生成播客提要的插件,我正在尝试找出是否可以使用WP\\u Query仅从指定类别中提取具有音频附件的帖子。我知道我可以在自定义查询中执行此操作,例如:
$podeps = $wpdb->get_results(
"SELECT SQL_CALC_FOUND_ROWS $wpdb->posts.*
FROM $wpdb->posts,wp_term_relationships
WHERE $wpdb->posts.ID = $wpdb->term_relationships.object_id
AND $wpdb->term_relationships.term_taxonomy_id IN ($catid)
AND $wpdb->posts.post_type = \'post\'
AND $wpdb->posts.post_status = \'publish\'
AND $wpdb->posts.ID IN (
SELECT DISTINCT post_parent
FROM $wpdb->posts
WHERE post_parent > 0
AND post_type = \'attachment\'
AND post_mime_type = \'audio/mpeg\'
)
GROUP BY $wpdb->posts.ID
ORDER BY $wpdb->posts.post_date DESC
LIMIT 50",
OBJECT
);
但是,有没有一种方法可以使用WP\\u查询来做到这一点?如果可能,我希望避免直接编写查询,以确保最广泛的兼容性。谢谢