DBQ-4 All the links in the main namespace
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	JiraBugConverter
	Jan 3 2014, 3:22 PM

Description

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'

Version: unspecified
Severity: minor

Details

Reference: bz59257

Event Timeline

• bzimport raised the priority of this task from to Needs Triage.Nov 22 2014, 2:18 AM

• bzimport added a project: Tool-Database-Queries.

• bzimport set Reference to bz59257.

JiraBugConverter created this task.Jan 3 2014, 3:22 PM

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

DBQ-4 All the links in the main namespaceClosed, ResolvedPublicActions