Magento – magento 1.9 add custom product image type

Using Product Image Placeholders

Magento Go uses temporary images as placeholders until the permanent product images are available. The initial placeholder image is the Magento logo, which you can replace with placeholder images of your own design.

                         Product Image Placeholders

To upload product image placeholders:

1. From the Admin panel, select System > Configuration..
2. In the Configuration panel on the left, under Catalog, select Catalog.
3. Click to expand the Product Image Placeholders section.
4. For each image type, click the Browse button to upload the placeholder image you want to use for the base image, small image, and thumbnail images. If you like, you can use the same image for each type.
5. When complete, click the Save Config button.

System > Configuration > Catalog: Product Image Placeholders

I am not sure how to get this information from the media gallery information but the thumbnail, small_image and image are simply eav_attributes.

You can find the value with the following sql where entity_type_id 4 is the product entity id.

SELECT * FROM `eav_attribute` where entity_type_id = 4 and attribute_code in ("thumbnail", "small_image", "image")

Now what you could do is to build a collection based on product and the attributes returned from the above sql.