https://bugzilla.wikimedia.org/show_bug.cgi?id=59257
Web browser: ---
Bug ID: 59257
Summary: DBQ-4 All the links in the main namespace
Product: Tool Labs tools
Version: unspecified
Hardware: All
OS: All
Status: NEW
Severity: minor
Priority: Unprioritized
Component: Database Queries
Assignee: wmf.bugconver...@gmail.com
Reporter: wmf.bugconver...@gmail.com
Classification: Unclassified
Mobile Platform: ---
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 <reflect...@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'
--
You are receiving this mail because:
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
