TODO: Cleanup of orphaned records

[jeroenvermeulen]

DELETE FROM `core_url_rewrite`
WHERE `is_system`=1
AND `id_path` LIKE 'product/%' 
AND `product_id` NOT IN (SELECT entity_id FROM catalog_product_entity)

and

DELETE FROM `core_url_rewrite` 
WHERE `is_system`=1
AND `id_path` LIKE 'category/%' 
AND  `category_id` NOT IN  (SELECT entity_id FROM catalog_category_entity )