INFORMATION and DESCRIPTION
1. The WordPress Media Library allows editors to upload images, video, docs, pdfs, etc.
2. When a file is uploaded the original is kept in a folder and its information is stored in the database.
3. After an IMAGE is uploaded, the WordPress back-end automatically creates a specific set of image sizes for each image. These include thumbnails and a set of dimensions commonly used (i.e. related to Original, Large, Medium, Small, and Thumbnail).
4. These several image sizes are also added to the database, however they are never displayed in the Media Library.
5. During a recent Media Library migration, ALL image sizes were added to the database--including images with image sizes, which we now see in the Media Library, but which should not appear in the Media Library.
Run an SQL script on the database which does three things:
1. Identify any image with a specific set of dimensions in the file name.
2. From those images identify those images which are specified to appear in the Media Library.
3. Delete the subset of images in step two.