Enter your keyword

Blog

Update Term count by SQL

Update WordPress Taxonomies (Categories/Tags) count field after bulk Import/Delete

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')
)

No Comments

Add your review

Your email address will not be published.

* Feilds are Required.