https://bugzilla.wikimedia.org/show_bug.cgi?id=39011
--- Comment #4 from Sam Reed (reedy) <s...@reedyboy.net> --- (In reply to comment #3) > Hi, > > looks like the second point has been fixed in the prod db: > > mysql:giovanni@db1047.eqiad.wmnet [enwiki]> select count(*) from page left > join > redirect on page_id = rd_from where page_is_redirect != 0 and rd_from is > null; > > > +----------+ > | count(*) | > +----------+ > | 0 | > +----------+ > 1 row in set (39.33 sec) > > mysql:giovanni@db1047.eqiad.wmnet [enwiki]> Agreed. First one done too now. It only had 5 rows now. 1 was an erroneous redirect, presumably just never deleted. 1 was a redirect in user js files which I don't think ever worked. 2 were non existent pages. mysql:wikiadmin@db60 [enwiki]> select * from redirect join page on rd_from=page_id where page_is_redirect != 1 limit 100; Empty set (19.58 sec) -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l