#5212: removing empty release groups should be an autoedit for autoeditors
-------------------------------------------------+--------------------------
Reporter: voiceinsideyou | Owner:
Type: bug | Status: new
Priority: normal | Milestone:
Component: MusicBrainz Server | Version: Server 2009-05-24
Resolution: | Keywords:
Browser: Netscape, Firefox, Mozilla (Gecko) | Os: Linux
-------------------------------------------------+--------------------------
Comment (by inhouseuk):
infact, it's down to zero. Those 24 had AR's to releases.
This is the final set of queries to find the list of empty labels
----------------------------------------------------------------------
drop table temp_label_id;
select id into temp_label_id from label where modpending =0;
delete from temp_label_id where id in (select distinct label from release
where label NOTNULL);
delete from temp_label_id where id in (select distinct link0 from
l_label_url);
delete from temp_label_id where id in (select distinct link0 from
l_label_label);
delete from temp_label_id where id in (select distinct link1 from
l_label_label);
delete from temp_label_id where id in (select distinct link0 from
l_label_track);
delete from temp_label_id where id in (select distinct link1 from
l_artist_label);
delete from temp_label_id where id in (select distinct link1 from
l_album_label);
select id from temp_label_id;
--------------------------------------------------------------------------
--
Ticket URL: <
http://bugs.musicbrainz.org/ticket/5212#comment:8>
MusicBrainz Bug Tracker <
http://musicbrainz.org>
MusicBrainz -- the music metadatabase
_______________________________________________
Musicbrainz-bugs mailing list
Musicbrainz-bugs@...
http://lists.musicbrainz.org/mailman/listinfo/musicbrainz-bugs
