WaterWiki.net:List of ancient Table structured pages

From WaterWiki.net

(Difference between revisions)
Jump to: navigation, search

Mikel (Talk | contribs)
(New page: SQL: "select distinct(page.page_title) from text INNER JOIN revision ON rev_text_id=old_id INNER JOIN page ON rev_page = page_id where LOWER(text.old_text) like '%<table>%' and page_latest...)
Newer edit →

Revision as of 20:08, 11 October 2009

SQL: "select distinct(page.page_title) from text INNER JOIN revision ON rev_text_id=old_id INNER JOIN page ON rev_page = page_id where LOWER(text.old_text) like '%%' and page_latest = rev_id;"