根据元密钥和猫id自定义选择查询 - Custom Select Query by meta key and cat id

Custom Select Query by meta key and cat id

本文关键字：id 自定义选择查询密钥 | 更新日期: 2023-09-27

我有一个自定义查询，它可以获取帖子的到期日并据此发布订单。如何将其修改为仅列出某个类别id，例如"20"

$querystr = "
    SELECT wposts.*
    FROM $wpdb->posts wposts, $wpdb->postmeta wpostmeta
    WHERE wposts.ID = wpostmeta.post_id
    AND wpostmeta.meta_key = 'es_ape_expiry'
    ORDER BY wpostmeta.meta_value ASC
    ";
 $pageposts = $wpdb->get_results($querystr, OBJECT);

非常感谢！

尝试以下查询并将$cat_id替换为20

SELECT wposts.*
FROM $wpdb->posts wposts, $wpdb->postmeta wpostmeta
JOIN $wpdb->term_relationships tr ON (p.ID = tr.object_id)
JOIN $wpdb->term_taxonomy tt ON (tr.term_taxonomy_id = tt.term_taxonomy_id)
JOIN $wpdb->terms t ON (tt.term_id = t.term_id)
WHERE wposts.ID = wpostmeta.post_id
AND wpostmeta.meta_key = 'es_ape_expiry' 
AND tt.taxonomy = 'category'
AND t.term_id = $cat_id
ORDER BY wpostmeta.meta_value ASC