diff options
Diffstat (limited to 'util/dbdump.pl')
-rwxr-xr-x | util/dbdump.pl | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/util/dbdump.pl b/util/dbdump.pl index 5488d6e4..5adf35de 100755 --- a/util/dbdump.pl +++ b/util/dbdump.pl @@ -98,7 +98,7 @@ my %tables = ( users => { where => 'id IN(SELECT DISTINCT uvl.uid FROM ulist_vns_labels uvl JOIN ulist_labels ul ON ul.uid = uvl.uid AND ul.id = uvl.lbl WHERE NOT ul.private)' .' OR id IN(SELECT DISTINCT uid FROM tags_vn)' .' OR id IN(SELECT DISTINCT uid FROM image_votes)' - .' OR id IN(SELECT DISTINCT uid FROM vn_length_votes)' }, + .' OR id IN(SELECT DISTINCT uid FROM vn_length_votes WHERE NOT private)' }, vn => { where => 'NOT hidden' }, vn_anime => { where => 'id IN(SELECT id FROM vn WHERE NOT hidden)' }, vn_relations => { where => 'id IN(SELECT id FROM vn WHERE NOT hidden)' }, @@ -108,7 +108,7 @@ my %tables = ( .' AND cid IN(SELECT id FROM chars WHERE NOT hidden)' }, vn_staff => { where => 'id IN(SELECT id FROM vn WHERE NOT hidden) AND aid IN(SELECT sa.aid FROM staff_alias sa JOIN staff s ON s.id = sa.id WHERE NOT s.hidden)' }, vn_titles => { where => 'id IN(SELECT id FROM vn WHERE NOT hidden)' }, - vn_length_votes => { where => 'vid IN(SELECT id FROM vn WHERE NOT hidden)' + vn_length_votes => { where => 'vid IN(SELECT id FROM vn WHERE NOT hidden) AND NOT private' , order => 'vid, uid' }, wikidata => { where => q{id IN(SELECT l_wikidata FROM producers WHERE NOT hidden UNION SELECT l_wikidata FROM staff WHERE NOT hidden |