Fork of
Hewiki google links
by Estopedist1
This query is marked as a draft
This query has been published
by Estopedist1.
SQL
AخA
use etwiki_p;
select replace(page_title, "_", " ") as article, el_to as address from page join externallinks on page_id = el_from
where page_namespace = 0
AND el_to RLIKE "[A-Za-z]{70}"
LIMIT 3;
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.