Created
April 15, 2013 18:50
-
-
Save stwalkerster/5390381 to your computer and use it in GitHub Desktop.
ACC link queries
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
select page_namespace, page_title, iwl_text from iwlinks inner join page on page_id = iwl_from where iwl_prefix = "tools" and iwl_title like "~acc/%"; | |
select distinct page_namespace, page_title, el_to from externallinks inner join page on page_id = el_from where el_index LIKE "http://org.toolserver./~acc/%" or el_index LIKE "https://org.toolserver./~acc/%"; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment