如指定分类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内置类WP_Query即可快速实现:
1 2 3 4 |
$args = array( 'cat' => 1 ); var_dump( new WP_Query( $args ) ); |