SQL
x
use hewiki_p;
select replace(page_title, "_", " ") as article, el_index as address from page join externallinks
on page_id = el_from
where (el_to like "%action=edit%"
or el_to like "%org/w/index.php%"
or (el_to like "%wik%org/wiki%"
and not el_to like "%wikipedia%"))
and not el_to like "%upload%"
and page_namespace = 0
and el_to like "%wiktionary%"
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.