Figured it out myself. I just used concat to prepend the wiki's URI to each page name.
On Thu, Nov 21, 2013 at 9:20 AM, Bill Traynor <[email protected]> wrote: > I've written an SQL query to extract some data from our wikidb as follows: > > select > page_title, > u.user_name, > u.user_email, > rev_timestamp, > c.cl_to > from page p > join revision r > on p.page_id = r.rev_page > join user u > on r.rev_user = u.user_id > left join categorylinks c > on p.page_id = c.cl_from > where page_latest = r.rev_id > into outfile "/tmp/report.txt"; > > I need to obtain the full page URI, not just the Page Title. I can't seem > to find that stored in the wikidb. Am I just missing it or is it always > dynamically generated? > > Thanks > Bill > _______________________________________________ MediaWiki-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
