php – 使用新的wp_query对wordpress查询进行Transofrm sql查询
发布时间:2020-05-25 08:48:56 所属栏目:PHP 来源:互联网
导读:我试图将SQL查询转换为wordpress查询,但无法理解它是如何完成的? 查询我尝试转换为新的wp_query $query = SELECT SQL_CALC_FOUND_ROWS distinct wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta
我试图将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); (编辑:安卓应用网) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |