https://bugzilla.wikimedia.org/show_bug.cgi?id=59305
--- Comment #1 from Bugzilla Bug Importer (valhallasw) <wmf.bugconver...@gmail.com> --- ------------------------------------------------------------------------------- From: MZMcBride <mzmcbr...@gmail.com> 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 = page_id) AND page_is_redirect = 0; Results posted to http://en.wikibooks.org/w/index.php?oldid=1332296 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 Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l