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