How to bulk delete unattached images in WordPress using WP CLI and exclude specific authors?

Asked Dec 01 '22 at 13:24

Active Dec 02 '22 at 20:11

Viewed 184 times

Task is to delete all images within a month's archive that are not assigned to a post and have not been uploaded by the admin (user_id 1). The number of affected images is large (>50.000 images), so they have to be deleted image by image.

Command: Delete unattached images line by line and exclude the admin:

for id in $(wp db query "SELECT ID FROM wp_posts WHERE post_date>='2020-11-01' AND post_date<='2020-11-30' AND post_type='attachment' AND post_parent=0 AND post_author !='1'" --silent --skip-column-names)
do
    wp post delete --force $id
done

Is the solution

edited Dec 02 '22 at 20:11

asked Dec 01 '22 at 13:24

David W.

how can `-1` match as post author? – Vijay Hardaha Dec 01 '22 at 17:32
In wp query -1 gives all posts except post from author with id 1 . I had also tried AND NOT post_author='1' – David W. Dec 02 '22 at 00:37
Found the solution and updated the command – David W. Dec 02 '22 at 20:11

How to bulk delete unattached images in WordPress using WP CLI and exclude specific authors?

0 Answers0