wordpress - 批量导入/删除后如何更新 WordPress 分类法(类别/标签)的计数字段

Question

如何在批量导入/删除后更新 WordPress 分类法(类别/标签)的计数字段？

相关问题:

WordPress › 支持 » 导入后修复评论和类别计数
http://wordpress.org/support/topic/fix-comment-and-category-counts-after-import

Answer 1

此 SQL 有助于:

UPDATE wp_term_taxonomy SET count = (
SELECT COUNT(*) FROM wp_term_relationships rel 
    LEFT JOIN wp_posts po ON (po.ID = rel.object_id) 
    WHERE 
        rel.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id 
        AND 
        wp_term_taxonomy.taxonomy NOT IN ('link_category')
        AND 
        po.post_status IN ('publish', 'future')
)