Hi!
2009/3/18 O. O. olson_ot@yahoo.com:
For the list of Page Titles, I looked into the Page Table, and simply got a list of all of the Titles. In SQL I assumed this would be the result of the Query: “select page_title from wikidb.page;” – The problem with this is that I am getting a number of Titles that are repeated?? So I think I am doing something wrong?
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 of a page (this is true for the whole MediaWiki).
HTH, -- [[cs:User:Mormegil | Petr Kadlec]]