WaterWiki.net:List of ancient Table structured pages

From WaterWiki.net

(Difference between revisions)
Jump to: navigation, search
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;"
-
*[[User: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]]
Line 18: Line 20:
*[[Women_for_Water]]
*[[Women_for_Water]]
*[[Proposed_EU/Moldova_Action_Plan]]
*[[Proposed_EU/Moldova_Action_Plan]]
-
*[[Workspace/E-Moderator Course]]
+
*[[Workspace/E-Moderator_Course]]
*[[Sandbox3]]
*[[Sandbox3]]

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;"