Quote:
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/showthre...?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!