php – 使用新的wp_query对wordpress查询进行Transofrm sql查询

前端之家收集整理的这篇文章主要介绍了php – 使用新的wp_query对wordpress查询进行Transofrm sql查询前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。
我试图将SQL查询转换为wordpress查询,但无法理解它是如何完成的?

查询我尝试转换为新的wp_query

$query = "  SELECT sql_CALC_FOUND_ROWS distinct wp_posts.ID
            FROM   wp_posts
                   INNER JOIN wp_postMeta
                           ON ( wp_posts.id = wp_postMeta.post_id )
                   INNER JOIN wp_postMeta AS mt1
                           ON ( wp_posts.id = mt1.post_id )
            WHERE  1 = 1
                   AND wp_posts.id NOT IN ( 0 )
                   AND wp_posts.post_type = 'topic'
                   AND ( wp_posts.post_status = 'publish'
                          OR wp_posts.post_status = 'closed'
                          OR wp_posts.post_status = 'reported' )
                   AND ( wp_postMeta.Meta_key = '_bbp_last_active_time')
            GROUP  BY wp_posts.id
            ORDER  BY wp_postMeta.Meta_value DESC
            LIMIT  0,10 
        ";
$topics = $wpdb->get_results($query,OBJECT);

所以我可以使用

while($topics->have_posts()) : $topics->the_post(); ?>

喜欢

$args = array(); // how do I convert to this.
$topics = new WP_query($args);
尝试:
$wpq = new WP_Query();
$wpq->parse_query($query);
$posts = $wpq->get_posts();

或者使用标准的WP_Query函数

$wpq = new WP_Query($query);

猜你在找的PHP相关文章