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
Wurgl
.
Toggle Highlighting
SQL
SELECT COUNT(DISTINCT page_title) AS "Anzahl Artikel", COUNT(*) AS "Anzahl Links", SUM(el_to rlike '[?&]utm_id=') AS "Muster '[?&]utm_id='", SUM(el_to rlike '[?&]utm_source=') AS "Muster '[?&]utm_source='", SUM(el_to rlike '[?&]utm_medium=') AS "Muster '[?&]utm_medium='", SUM(el_to rlike '[?&]utm_campaign=') AS "Muster '[?&]utm_campaign='", SUM(el_to rlike '[?&]utm_term=') AS "Muster '[?&]utm_term='", SUM(el_to rlike '[?&]utm_content=') AS "Muster '[?&]utm_content='", SUM(el_to rlike '[?&]utm_referrer=') AS "Muster '[?&]utm_referrer='", SUM(el_to rlike '[?&]utm_email=') AS "Muster '[?&]utm_email='", SUM(el_to rlike '[?&]gclid=') AS "Muster '[?&]gclid='", SUM(el_to rlike '[?&]gclsrc=') AS "Muster '[?&]gclsrc='", SUM(el_to rlike '[?&]dclid=') AS "Muster '[?&]dclid='", SUM(el_to rlike '[?&]_r=') AS "Muster '[?&]_r='", SUM(el_to rlike '[?&]fbclid=') AS "Muster '[?&]fbclid='", SUM(el_to rlike '[?&]fbc=') AS "Muster '[?&]fbc='", SUM(el_to rlike '[?&]fbp=') AS "Muster '[?&]fbp='", SUM(el_to rlike '[?&]oly_enc_id=') AS "Muster '[?&]oly_enc_id='", SUM(el_to rlike '[?&]oly_anon_id=') AS "Muster '[?&]oly_anon_id='", SUM(el_to rlike '[?&]__s=') AS "Muster '[?&]__s='", SUM(el_to rlike '[?&]vero_id=') AS "Muster '[?&]vero_id='", SUM(el_to rlike '[?&]_hsenc=') AS "Muster '[?&]_hsenc='", SUM(el_to rlike '[?&]mkt_tok=') AS "Muster '[?&]mkt_tok='", SUM(el_to rlike '[?&]mc_eid=') AS "Muster '[?&]mc_eid='", SUM(el_to rlike '[?&]traffic_type=') AS "Muster '[?&]traffic_type='", SUM(el_to rlike '[?&]srcc=') AS "Muster '[?&]srcc='", SUM(el_to rlike '[?&]utm_v=') AS "Muster '[?&]utm_v='", SUM(el_to rlike '[?&]PHPSESSID=') AS "Muster '[?&]PHPSESSID='", SUM(el_to rlike '[?&]redirect=no') AS "Muster '[?&]redirect=no'", SUM(el_to rlike '[?&]noredirect=no') AS "Muster '[?&]noredirect=no'", SUM(el_to rlike '[?&]traffic_id=.*&traffic_type=') AS "Muster '[?&]traffic_id=.*&traffic_type='", SUM(el_to rlike '[?&]traffic_type=.*traffic_id=') AS "Muster '[?&]traffic_type=.*traffic_id='", SUM(el_to rlike '[?&]_r=.*&ref=') AS "Muster '[?&]_r=.*&ref='", SUM(el_to rlike '[?&]ref=.*&_r=') AS "Muster '?&ref=.*&_r='" FROM externallinks STRAIGHT_JOIN page WHERE el_from = page_id AND el_to LIKE "%=%" AND (el_to RLIKE '[?&]utm_id=' OR el_to RLIKE '[?&]utm_source=' OR el_to RLIKE '[?&]utm_medium=' OR el_to RLIKE '[?&]utm_campaign=' OR el_to rlike '[?&]utm_term=' OR el_to rlike '[?&]utm_content=' OR el_to rlike '[?&]utm_referrer=' OR el_to rlike '[?&]utm_email=' OR el_to rlike '[?&]gclid=' OR el_to rlike '[?&]gclsrc=' OR el_to rlike '[?&]dclid=' OR el_to rlike '[?&]_r=' OR el_to rlike '[?&]fbclid=' OR el_to rlike '[?&]fbc=' OR el_to rlike '[?&]fbp=' OR el_to rlike '[?&]oly_enc_id=' OR el_to rlike '[?&]oly_anon_id=' OR el_to rlike '[?&]__s=' OR el_to rlike '[?&]vero_id=' OR el_to rlike '[?&]_hsenc=' OR el_to rlike '[?&]mkt_tok=' OR el_to rlike '[?&]mc_eid=' OR el_to rlike '[?&]traffic_type=' OR el_to rlike '[?&]srcc=' OR el_to rlike '[?&]utm_v=' OR el_to rlike '[?&]PHPSESSID=' OR el_to rlike '[?&]redirect=no' OR el_to rlike '[?&]noredirect=no' OR el_to rlike '[?&]traffic_id=.*&traffic_type=' OR el_to rlike '[?&]traffic_type=.*traffic_id=' OR el_to rlike '[?&]_r=.*&ref=' OR el_to rlike '[?&]ref=.*&_r=' ) AND page_namespace = 0; /*SELECT COUNT(DISTINCT page_title) AS "Anzahl Seiten", COUNT(*) AS "Anzahl Links", SUM(el_to rlike '[?&]utm_id=') AS "Muster '[?&]utm_id='", SUM(el_to rlike '[?&]utm_source=') AS "Muster '[?&]utm_source='", SUM(el_to rlike '[?&]utm_medium=') AS "Muster '[?&]utm_medium='", SUM(el_to rlike '[?&]utm_campaign=') AS "Muster '[?&]utm_campaign='", SUM(el_to rlike '[?&]utm_term=') AS "Muster '[?&]utm_term='", SUM(el_to rlike '[?&]utm_content=') AS "Muster '[?&]utm_content='", SUM(el_to rlike '[?&]utm_referrer=') AS "Muster '[?&]utm_referrer='", SUM(el_to rlike '[?&]utm_email=') AS "Muster '[?&]utm_email='", SUM(el_to rlike '[?&]gclid=') AS "Muster '[?&]gclid='", SUM(el_to rlike '[?&]gclsrc=') AS "Muster '[?&]gclsrc='", SUM(el_to rlike '[?&]dclid=') AS "Muster '[?&]dclid='", SUM(el_to rlike '[?&]_r=') AS "Muster '[?&]_r='", SUM(el_to rlike '[?&]fbclid=') AS "Muster '[?&]fbclid='", SUM(el_to rlike '[?&]fbc=') AS "Muster '[?&]fbc='", SUM(el_to rlike '[?&]fbp=') AS "Muster '[?&]fbp='", SUM(el_to rlike '[?&]oly_enc_id=') AS "Muster '[?&]oly_enc_id='", SUM(el_to rlike '[?&]oly_anon_id=') AS "Muster '[?&]oly_anon_id='", SUM(el_to rlike '[?&]__s=') AS "Muster '[?&]__s='", SUM(el_to rlike '[?&]vero_id=') AS "Muster '[?&]vero_id='", SUM(el_to rlike '[?&]_hsenc=') AS "Muster '[?&]_hsenc='", SUM(el_to rlike '[?&]mkt_tok=') AS "Muster '[?&]mkt_tok='", SUM(el_to rlike '[?&]mc_eid=') AS "Muster '[?&]mc_eid='", SUM(el_to rlike '[?&]traffic_type=') AS "Muster '[?&]traffic_type='", SUM(el_to rlike '[?&]srcc=') AS "Muster '[?&]srcc='", SUM(el_to rlike '[?&]utm_v=') AS "Muster '[?&]utm_v='", SUM(el_to rlike '[?&]PHPSESSID=') AS "Muster '[?&]PHPSESSID='", SUM(el_to rlike '[?&]redirect=no') AS "Muster '[?&]redirect=no'", SUM(el_to rlike '[?&]noredirect=no') AS "Muster '[?&]noredirect=no'", SUM(el_to rlike '[?&]traffic_id=.*&traffic_type=') AS "Muster '[?&]traffic_id=.*&traffic_type='", SUM(el_to rlike '[?&]traffic_type=.*traffic_id=') AS "Muster '[?&]traffic_type=.*traffic_id='", SUM(el_to rlike '[?&]_r=.*&ref=') AS "Muster '[?&]_r=.*&ref='", SUM(el_to rlike '[?&]ref=.*&_r=') AS "Muster '?&ref=.*&_r='" FROM externallinks STRAIGHT_JOIN page WHERE el_from = page_id AND el_to LIKE "%=%" AND (el_to RLIKE '[?&]utm_id=' OR el_to RLIKE '[?&]utm_source=' OR el_to RLIKE '[?&]utm_medium=' OR el_to RLIKE '[?&]utm_campaign=' OR el_to rlike '[?&]utm_term=' OR el_to rlike '[?&]utm_content=' OR el_to rlike '[?&]utm_referrer=' OR el_to rlike '[?&]utm_email=' OR el_to rlike '[?&]gclid=' OR el_to rlike '[?&]gclsrc=' OR el_to rlike '[?&]dclid=' OR el_to rlike '[?&]_r=' OR el_to rlike '[?&]fbclid=' OR el_to rlike '[?&]fbc=' OR el_to rlike '[?&]fbp=' OR el_to rlike '[?&]oly_enc_id=' OR el_to rlike '[?&]oly_anon_id=' OR el_to rlike '[?&]__s=' OR el_to rlike '[?&]vero_id=' OR el_to rlike '[?&]_hsenc=' OR el_to rlike '[?&]mkt_tok=' OR el_to rlike '[?&]mc_eid=' OR el_to rlike '[?&]traffic_type=' OR el_to rlike '[?&]srcc=' OR el_to rlike '[?&]utm_v=' OR el_to rlike '[?&]PHPSESSID=' OR el_to rlike '[?&]redirect=no' OR el_to rlike '[?&]noredirect=no' OR el_to rlike '[?&]traffic_id=.*&traffic_type=' OR el_to rlike '[?&]traffic_type=.*traffic_id=' OR el_to rlike '[?&]_r=.*&ref=' OR el_to rlike '[?&]ref=.*&_r=' ) AND page_namespace != 0;*/
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...