wordpress获取某个分类的文章的sql语句
如指定分类ID为1:
1 2 3 4 5 6 7 8 9 | global $wpdb; $sql = "SELECT SQL_CALC_FOUND_ROWS {$wpdb->posts}.* FROM {$wpdb->posts} INNER JOIN {$wpdb->term_relationships} ON ({$wpdb->posts}.ID = {$wpdb->term_relationships}.object_id) WHERE 1=1 AND ( {$wpdb->term_relationships}.term_taxonomy_id IN (1) ) AND {$wpdb->posts}.post_type = 'post' AND ({$wpdb->posts}.post_status = 'publish') GROUP BY {$wpdb->posts}.ID ORDER BY {$wpdb->posts}.post_date DESC "; var_dump( $wpdb->get_results( $sql ) ); |
以上可以用wp内置类W […]