So if you pop open mysql query browser to check around, a quick query to
check for albums that might have dupes is:
Code:
--------------------
SELECT cnt, titlesort, namesort FROM (SELECT count(titlesort) as cnt,
titlesort, contributor FROM slimserver.albums a group by titlesort, contributor
order by cnt desc) as tbl1 left join slimserver.contributors on contributors.id
= tbl1.contributor
--------------------
--
FredFredrickson
------------------------------------------------------------------------
FredFredrickson's Profile: http://forums.slimdevices.com/member.php?userid=16584
View this thread: http://forums.slimdevices.com/showthread.php?t=49848
_______________________________________________
discuss mailing list
[email protected]
http://lists.slimdevices.com/lists/listinfo/discuss
