问WP -按日期计算类别数

EN

   global $wpdb;
    $sql = "
SELECT wp_term_taxonomy.term_id as term_id, COUNT(wp_posts.id) as count_posts
    FROM wp_posts
    INNER JOIN wp_term_relationships ON wp_posts.id = wp_term_relationships.object_id
    INNER JOIN wp_term_taxonomy ON wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_id
    WHERE wp_posts.post_date >= cast(DATE_ADD(NOW(), INTERVAL -1 DAY) as date)
    AND wp_term_taxonomy.taxonomy = 'category'
    GROUP BY term_id
    ";
    $query = $wpdb->get_results($sql);
    foreach ($query as $u) {
        var_dump($u);
    }