SELECT `p`.`sku` FROM `catalog_product_entity` AS `p`...

The following solutions helps to find duplicate image file for each product and to remove it

Reindex category products index at first and then execute following sql-script

Magento has two attributes “Set Product As New From Date” and “Set Product As New To Date” to set a product as new

If you wan’t automatically make all simple products which are configurable options of configurable products to be hidden in catalog, you have to change their visibility to “Not Visible Individually”

For instance, we need to convert all .gif to .jpg