WaterWiki.net:List of ancient Table structured pages

From WaterWiki.net

(Difference between revisions)
Jump to: navigation, search
(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...)
Line 1: Line 1:
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 = rev_id;"
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 = rev_id;"
-
* [[Roland.Oosterbaan]]                                                                                                                                                      * [[Capacity_for_Water_Cooperation_Project]]                                                                                                                                  *[[Europe_and_CIS_Water-CoP_members Contacts_and_Colleagues]]
+
*[[User:Roland.Oosterbaan]]                                                                                                                                                      *[[Capacity_for_Water_Cooperation_Project]]                                                                                                                                  *[[Europe_and_CIS_Water-CoP_members Contacts_and_Colleagues]]
*[[Dialogue_on_Effective_Water_Governance]]
*[[Dialogue_on_Effective_Water_Governance]]
*[[Dialogue_on_Water,_Food_and_Environment]]
*[[Dialogue_on_Water,_Food_and_Environment]]

Revision as of 20:09, 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;"