Skip to content

Instantly share code, notes, and snippets.

@stwalkerster

stwalkerster/gist:5390381

Created April 15, 2013 18:50
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save stwalkerster/5390381 to your computer and use it in GitHub Desktop.
Save stwalkerster/5390381 to your computer and use it in GitHub Desktop.
Download ZIP
ACC link queries
Raw
gistfile1.sql
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