Home - johnybk08/Magento GitHub Wiki

Welcome to the Magento wiki!

SELECT * from url_rewrite where entity_type = 'product' and entity_id IN (select entity_id from catalog_product_entity WHERE TIME_TO_SEC(TIMEDIFF(CURRENT_TIMESTAMP, created_at)) <= 172800)