reniera;651293 Wrote:
> Well, I do not understand this. It could be that I possibly have 1529
> duplicate tracks i.e. in single and compilations. (sound a lot but it's
> not impossible).
> But how about Duplicate musicbrainz artist tag ?? I would assume a lot
> more considering one artists does a lot of song ...
>
> Beside this, I use picard for almost everything (just a few tracks are
> not tagged yet or there is no match in musicbrainz), so I would assume
> that anyone using picard would have the same problem.
>
> But is this a problem after all to have duplicates (when I tag with
> Picard, I can see that some artist release the exact same track on
> multiple albums/releases) ?
>
You can try to create a new "Free form query" in Database Query plugin
and use the following SQL statement with it:
Code:
--------------------
select musicbrainz_id,count(*) from contributors where musicbrainz_id is not
null group by musicbrainz_id having count(*)>1
--------------------
This should list the artist musicbrainz_id's that are duplicated and
how many you have of each one.
Then do the same thing for songs with the following SQL statement:
Code:
--------------------
select musicbrainz_id,count(*) from tracks where musicbrainz_id is not null
group by musicbrainz_id having count(*)>1
--------------------
Which will list the track musicbrainz_id's that are duplicated.
Both queries lists two columns:
- musicbrainz_id
- count(*) => Number of occurences
To see which artist the duplicated musicbrainz_id belongs to you can
use a SQL query like this:
Code:
--------------------
select musicbrainz_id,name from contributors where musicbrainz_id in (select
distinct musicbrainz_id from contributors where musicbrainz_id is not null
group by musicbrainz_id having count(*)>1) order by musicbrainz_id,name
--------------------
And the same thing for songs is:
Code:
--------------------
select musicbrainz_id,url from tracks where musicbrainz_id in (select
distinct musicbrainz_id from tracks where musicbrainz_id is not null group by
musicbrainz_id having count(*)>1) order by musicbrainz_id,url
--------------------
Both are ordered by musicbrainz_id, so you should be able to see which
are duplicates.
Let me know if the duplicates you find are real duplicates or if they
are caused by some invalid tag value written by Picard or something
else.
--
erland
Erland Isaksson ('My homepage' (http://erland.isaksson.info))
(Developer of 'many plugins/applets'
(http://wiki.slimdevices.com/index.php/User:Erland). If my answer
helped you and you like to encourage future presence on this forum
and/or third party plugin/applet development, 'donations are always
appreciated' (http://erland.isaksson.info/donate))
------------------------------------------------------------------------
erland's Profile: http://forums.slimdevices.com/member.php?userid=3124
View this thread: http://forums.slimdevices.com/showthread.php?t=89719
_______________________________________________
plugins mailing list
plugins@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/plugins
