首页 > 解决方案 > 如何完成 Wordpress 查询以按元值和日期对结果进行排序

问题描述

我尝试执行的查询在普通 sql 中看起来像这样: SELECT wp_posts.post_title, wp_postmeta.meta_value FROM wp_posts INNER JOIN wp_postmeta ON wp_posts.ID = wp_postmeta.post_id WHERE wp_posts.post_type = 'property' AND wp_posts.post_status = 'publish' AND wp_postmeta.meta_key = 'property_package' ORDER BY wp_postmeta.meta_value DESC, wp_posts.post_date DESC LIMIT 0, 32;

标签: wordpressdatesortingkey

解决方案


推荐阅读