Hi! 2009/3/18 O. O. <[email protected]>: > 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]] _______________________________________________ Wikitech-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikitech-l
