Php WordPress：今天的计数'；修改和发布的帖子

以下函数返回published和modified today的全部posts的计数:

function sabtfactor_su() {
    global $wpdb;
    $today = date("Y-m-d");
    $query = "SELECT COUNT(ID) FROM {$wpdb->prefix}posts WHERE post_type='post' AND post_status='publish' AND post_modified_gmt LIKE '{$today}%'";
    return (int)$wpdb->get_var($query);
}

要获得相同的结果，但要针对特定的author_id使用:

function sabtfactor_su($shenase) {
    global $wpdb;
    $today = date("Y-m-d");
    $query = "SELECT COUNT(ID) FROM {$wpdb->prefix}posts WHERE post_type='post' AND post_author='%d' AND post_status='publish' AND post_modified_gmt LIKE '{$today}%'";
    return (int)$wpdb->get_var($wpdb->prepare($query, $shenase));
}

并进一步将范围缩小到所有开机自检，对于特定的meta_key，对于特定的author_id使用，指定的meta_value:

function sabtfactor_su($shenase) {
    global $wpdb;
    $today = date("Y-m-d");
    $query = "SELECT COUNT(ID) FROM {$wpdb->prefix}posts INNER JOIN {$wpdb->prefix}postmeta ON post_id=ID AND meta_key='shomare_status' AND meta_value='Example' WHERE post_type='post' AND post_author='%d' AND post_status='publish' AND post_modified_gmt LIKE '{$today}%'";
    return (int)$wpdb->get_var($wpdb->prepare($query, $shenase));
}