Clean tags with zero count on multisite

Clean-tags-sql.sh

#!/bin/bash

# Get all blog ids
blog_ids=$(wp site list --field=blog_id)

# Loop through each blog id
for blog_id in $blog_ids
do
  if [ "$blog_id" -eq 1 ]; then
    continue
  fi
  wp term recount post_tag --url=$(wp site url $blog_id) --skip-plugins --skip-themes
  # Get all unused tags for the current blog
  unused_tags=$(wp db query "SELECT term_taxonomy_id FROM wp_${blog_id}_term_taxonomy WHERE taxonomy = 'post_tag' AND count = 0" --skip-plugins --skip-themes --silent)

  # If there are unused tags, delete them
  if [ ! -z "$unused_tags" ]; then
    # Convert the list of unused tags to a comma-separated string
    unused_tags_comma_separated=$(echo $unused_tags | tr ' ' ',')

    echo "Cleaning up $unused_tags_comma_separated from $blog_id"
    wp db query "DELETE FROM wp_${blog_id}_term_relationships WHERE term_taxonomy_id IN ($unused_tags_comma_separated)" --skip-plugins --skip-themes
    wp db query "DELETE FROM wp_${blog_id}_term_taxonomy WHERE term_taxonomy_id IN ($unused_tags_comma_separated)" --skip-plugins --skip-themes
    wp db query "DELETE FROM wp_${blog_id}_termmeta WHERE term_id IN ($unused_tags_comma_separated)" --skip-plugins --skip-themes
    wp db query "DELETE FROM wp_${blog_id}_terms WHERE term_id IN ($unused_tags_comma_separated)" --skip-plugins --skip-themes
    sleep 2
  fi
done