Re: [Wikitech-l] Getting the list of Page Titles and Redirects of Wikipedia

2009-03-20 Thread O. O.
Thanks Roan. Roan Kattouw wrote: Aryeh Gregor schreef: http://en.wikipedia.org/w/api.php?action=querymeta=siteinfosiprop=namespaces Note that namespaces with an ID of 100 or higher are specific to enwiki and may have different names or not be used at all on other wikis. To get an

Re: [Wikitech-l] Getting the list of Page Titles and Redirects of Wikipedia

2009-03-20 Thread Aryeh Gregor
On Fri, Mar 20, 2009 at 1:08 PM, O. O. olson...@yahoo.com wrote: I cannot understand why there are more redirects in the redirect table than there are in the pages in the Page table with the redirect flag set. select count(*) from wikidb.redirect ;   ---  Gives 3422938 while select

Re: [Wikitech-l] Getting the list of Page Titles and Redirects of Wikipedia

2009-03-20 Thread O. O.
Thanks Aryeh. Aryeh Gregor wrote: On Fri, Mar 20, 2009 at 1:08 PM, O. O. olson...@yahoo.com wrote: I cannot understand why there are more redirects in the redirect table than there are in the pages in the Page table with the redirect flag set. select count(*) from wikidb.redirect ; ---

Re: [Wikitech-l] Getting the list of Page Titles and Redirects of Wikipedia

2009-03-20 Thread Aryeh Gregor
On Fri, Mar 20, 2009 at 1:26 PM, O. O. olson...@yahoo.com wrote: I think this might mean that there are entries in the Redirect Table where the rd_from does not correspond to a valid page_id in the Page Table? I don’t know what these would be used for though. They're probably just wrong. The

Re: [Wikitech-l] Getting the list of Page Titles and Redirects of Wikipedia

2009-03-20 Thread O. O.
Aryeh Gregor wrote: On Fri, Mar 20, 2009 at 1:26 PM, O. O. olson...@yahoo.com wrote: I think this might mean that there are entries in the Redirect Table where the rd_from does not correspond to a valid page_id in the Page Table? I don’t know what these would be used for though. They're

Re: [Wikitech-l] Getting the list of Page Titles and Redirects of Wikipedia

2009-03-19 Thread Roan Kattouw
Platonides schreef: (it's helpfully provided in the API result . . . actually, what does it mean that Portal and Portal talk are canonical? shouldn't there be no canonical attribute if the namespace is custom?). Agree. Portal and Portal talk could still be acceptable, since the namespace

Re: [Wikitech-l] Getting the list of Page Titles and Redirects of Wikipedia

2009-03-18 Thread Aryeh Gregor
On Wed, Mar 18, 2009 at 6:18 AM, Petr Kadlec petr.kad...@gmail.com wrote: page_title does not contains the full title, only its namespace-relative part. You need to use select page_namespace, page_title from wikidb.page Only this whole tuple (page_namespace, page_title) is a unique identifier

Re: [Wikitech-l] Getting the list of Page Titles and Redirects of Wikipedia

2009-03-18 Thread Roan Kattouw
Aryeh Gregor schreef: On Wed, Mar 18, 2009 at 6:18 AM, Petr Kadlec petr.kad...@gmail.com wrote: page_title does not contains the full title, only its namespace-relative part. You need to use select page_namespace, page_title from wikidb.page Only this whole tuple (page_namespace, page_title)

Re: [Wikitech-l] Getting the list of Page Titles and Redirects of Wikipedia

2009-03-18 Thread Petr Kadlec
2009/3/18 O. O. olson...@yahoo.com: This is fine, but where can I find information on custom namespaces i.e. those that lie above 100. In $wgExtraNamespaces (see http://www.mediawiki.org/wiki/Manual:Using_custom_namespaces) -- [[cs:User:Mormegil | Petr Kadlec]]

Re: [Wikitech-l] Getting the list of Page Titles and Redirects of Wikipedia

2009-03-18 Thread Aryeh Gregor
On Wed, Mar 18, 2009 at 11:06 AM, Roan Kattouw roan.katt...@home.nl wrote: http://en.wikipedia.org/w/api.php?action=querymeta=siteinfosiprop=namespaces Note that namespaces with an ID of 100 or higher are specific to enwiki and may have different names or not be used at all on other wikis. To

Re: [Wikitech-l] Getting the list of Page Titles and Redirects of Wikipedia

2009-03-18 Thread Platonides
Aryeh Gregor wrote: On Wed, Mar 18, 2009 at 11:06 AM, Roan Kattouw roan.katt...@home.nl wrote: http://en.wikipedia.org/w/api.php?action=querymeta=siteinfosiprop=namespaces Note that namespaces with an ID of 100 or higher are specific to enwiki and may have different names or not be used at

[Wikitech-l] Getting the list of Page Titles and Redirects of Wikipedia

2009-03-17 Thread O. O.
Hi, I am wondering if someone could help me create a list of Page Titles, and list of Redirect Pages from the wikidb database in MySQL. I have downloaded the XML/SQL dumps along with the SQL dumps of the remaining Tables and imported them into the wikidb database in MySQL. (This is the