Pierre Thiollent PierreThiollent

## wp-delete-users-usersmeta.sql
DELETE wp_users, wp_usermeta FROM wp_users
INNER JOIN wp_usermeta ON wp_users.ID = wp_usermeta.user_id
WHERE meta_key = 'wp_capabilities' AND meta_value LIKE '%subscriber%';

## wp-delete-orphans-usermeta.sql
DELETE FROM wp_usermeta WHERE NOT EXISTS (
  SELECT * FROM wp_users
	WHERE wp_usermeta.user_id = wp_users.ID
)

## Readme.md

      
              3 files
            
          
              8 forks
            
          
                0 comments
              
            
              39 stars
            
          
                PierreThiollent
                / Readme.md
            
            
              Last active
              February 6, 2025 10:24
            
              
                iTerm2 and Oh-my-zsh config
              
          
    Setup iTerm2 and oh-my-zsh


Enjoy ! 😄
Install iTerm 2

Download iTerm2 here.
	DELETE wp_users, wp_usermeta FROM wp_users
	INNER JOIN wp_usermeta ON wp_users.ID = wp_usermeta.user_id
	WHERE meta_key = 'wp_capabilities' AND meta_value LIKE '%subscriber%';