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