Fork of
dewiki:Find fixed URLs
by ⵓ
This query is marked as a draft
This query has been published
by ⵓ.
SQL
AخA
use dewiki_p;
SELECT filter_url, filter_title, filter_page_id
FROM
(SELECT substring(el_to,28) as filter_url, page_title as filter_title, page_id as filter_page_id
FROM externallinks as euf INNER JOIN page as pf on euf.el_from=pf.page_id
WHERE el_index LIKE "http://invalid.dwl.giftbot./ftp%" and pf.page_namespace=1) as diskfilter
LEFT JOIN
(SELECT lnel.el_to, lnp.page_title, lnp.page_id
FROM externallinks as lnel INNER JOIN page as lnp on lnel.el_from=lnp.page_id and lnp.page_namespace=0) as leftside
ON (diskfilter.filter_url= leftside.el_to and diskfilter.filter_title= leftside.page_title)
WHERE leftside.page_id is null
LIMIT 26000;
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.