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
    Classification: Unclassified
   Mobile Platform: ---

This issue was converted from
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 <>
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

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

Reply via email to