Last modified: 2014-01-03 15:22:09 UTC
This issue was converted from https://jira.toolserver.org/browse/DBQ-4. Summary: All the links in the main namespace Issue type: Task - A task that needs to be done. Priority: Minor Status: Done Assignee: (none) ------------------------------------------------------------------------------- From: brian mingus <reflection@gmail.com> Date: Tue, 04 Dec 2007 21:36:25 ------------------------------------------------------------------------------- This query will output the IDs of all the articles in the main namespace, followed by all the articles each article links to, for easy computation of PageRank. SELECT pl_from, GROUP_CONCAT(DISTINCT page_id) FROM pagelinks INNER JOIN page ON pagelinks.pl_title = page.page_title WHERE pl_namespace = 0 AND page_namespace = 0 GROUP BY (pl_from) INTO OUTFILE 'namespace_0.links'
------------------------------------------------------------------------------- From: Pietrodn <powerpdn@gmail.com> Date: Sat, 05 Jan 2008 18:13:36 ------------------------------------------------------------------------------- In which wiki? ![][1] [1]: https://jira.toolserver.org/images/icons/emoticons/smile.gif
------------------------------------------------------------------------------- From: Daniel Kinzler <daniel@brightbyte.de> Date: Sun, 06 Jan 2008 21:56:47 ------------------------------------------------------------------------------- note that only root can select INTO OUTFILE
------------------------------------------------------------------------------- From: brian mingus <reflection@gmail.com> Date: Sun, 06 Jan 2008 22:04:09 ------------------------------------------------------------------------------- I managed to run this query on my mac mini. Cheers ![][1] [1]: https://jira.toolserver.org/images/icons/emoticons/smile.gif
This bug was imported as RESOLVED. The original assignee has therefore not been set, and the original reporters/responders have not been added as CC, to prevent bugspam. If you re-open this bug, please consider adding these people to the CC list: Original assignee: (none) CC list: reflection@gmail.com, daniel.kinzler@wikimedia.de, powerpdn@gmail.com