The obvious thing would be to search for post_type=’attachment’ but every media file has three entries in wp_posts plus the wp_postmeta data _wp_attached_file, wpml_media_processed, _wp_attachment_metadata so I would assume there’s some proper channels I should go through that makes sense of all that.
Three entries? I’ve not experienced that. I only see one for each image in my DB! In any case, that’s what you have. There must be something unique about one of the fields that identifies one as more “official” than the others. Post status perhaps? It may even be one of the post meta fields. It doesn’t matter much what’s unique as long as something consistently is. If all else fails, query for all attachment post types where guid is distinct. You’ll get one attachment for each image, even if the record returned isn’t the “official” one.
Okay, it turns out the three entries were being created by another plugin.
