--- Comment #1 from Bugzilla Bug Importer (valhallasw) 
<> ---
From: MZMcBride <>
Date: Fri, 14 Nov 2008 02:03:58

Wrote and ran the query. Didn't include the JOIN on pagelinks because I'm lazy.

> SELECT page_title,rev_timestamp,rev_user_text  
FROM page  
LEFT JOIN templatelinks  
ON page_namespace = tl_namespace AND page_title = tl_title  
JOIN revision ON rev_page = page_id  
WHERE page_namespace = 10 AND tl_from IS NULL  
AND rev_timestamp = (SELECT MAX(rev_timestamp) FROM revision WHERE rev_page =
AND page_is_redirect = 0;

Results posted to

Sortable wikitable format with numbered output.

You are receiving this mail because:
You are on the CC list for the bug.
Wikibugs-l mailing list

Reply via email to