summaryrefslogtreecommitdiff
path: root/util/dbdump.pl
diff options
context:
space:
mode:
Diffstat (limited to 'util/dbdump.pl')
-rwxr-xr-xutil/dbdump.pl4
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