[MediaWiki-l] Obtaining page URL from the wikidb

[Bill Traynor]

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
MediaWiki-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l