Mageseller

Find Duplicate Product Url SELECT Count(*),value FROM catalog_product_entity_varchar v WHERE EXISTS (SELECT * FROM eav_attribute a WHERE attribute_code = "url_key" AND v.attribute_id = a.attribute_id AND EXISTS (SELECT * FROM eav_entity_type e WHERE entity_type_code = "catalog_product" AND a.entity_type_id = e.entity_type_id )) AND store_id = 0 GROUP BY v.value HAVING Count(*) > 1 Find Duplicate Category Url SELECT Count(*),value FROM catalog_category_entity_varchar v WHERE EXISTS (SELECT * FROM eav_attribute a WHERE attribute_code = "url_key" AND v.attribute_id = a.attribute_id AND EXISTS (SELECT * FROM eav_entity_type e WHERE entity_type_code = "catalog_cate...

for category page <? php $_filters = Mage :: getSingleton ( 'catalog/layer' )-> getState ()-> getFilters (); foreach ( $_filters as $_filter ):?> <? php echo $this -> stripTags ( $_filter -> getLabel ()) ?> <a href=” <? php echo $_filter -> getRemoveUrl () ?> ” title=” <? php echo $this -> __ ( 'Remove This Item' ) ?> ”> <? php echo $this -> __ ( 'Remove This Item' ) ?> </a> <? php endforeach ; ?> for search page <? php $_filters = Mage :: getSingleton ( 'catalogsearch/layer' )-> getState ()-> getFilters (); foreach ( $_filters as $_filter ):?> <? php echo $this -> stripTags ( $_filter -> getLabel ()) ?> <a href=” <? php echo $_filter -> getRemoveUrl () ?> ” title=” <? php echo $this -> __ ( 'Remove This Item' ) ?> ”> <? php echo $this -> __ ( 'Remove This Item' ) ?> </a> ...