Address
:
(Go:
>> BACK <<
-|-
>> HOME <<
)
Include Form
Remove Scripts
Accept Cookies
Show Images
Show Referer
Rotate13
Base64
Strip Meta
Strip Title
Session Cookies
Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
ⵓ
.
find fixed URL noted by giftbot
Toggle Highlighting
SQL
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./%" 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 45000;
By running queries you agree to the
Cloud Services Terms of Use
and you irrevocably agree to release your SQL under
CC0 License
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...