List duplicate items with same URL?

[cnewtonne]

Is there a way to retrieve items that have same URL? I wanted to clean up duplicate items.

Thank you

[kinook]

Using SQLite

SELECT ItemID, Value FROM ItemAttribute WHERE AttributeID=996 AND UPPER(Value) IN (SELECT UPPER(Value) AS Val FROM ItemAttribute WHERE AttributeID=996 GROUP BY Val HAVING(COUNT(*) > 1)) ORDER BY UPPER(Value);

http://www.kinook.com/Forum/showthread.php?threadid=2825

[quant]

Originally posted by kinook
Using SQLite

SELECT ItemID, Value FROM ItemAttribute WHERE AttributeID=996 AND UPPER(Value) IN (SELECT UPPER(Value) AS Val FROM ItemAttribute WHERE AttributeID=996 GROUP BY Val HAVING(COUNT(*) > 1)) ORDER BY UPPER(Value);

http://www.kinook.com/Forum/showthread.php?threadid=2825

this is second or third user request where UR built in search is simply not enough and you reply directly with sql query. I think it would be great if you add the possibility to create our own queries directly inside UR ... maybe with some simple interface or just a query line ;-)

Thanks!