SQL
x
SELECT COUNT(DISTINCT page_title) AS "Anzahl Artikel",
COUNT(*) AS "Anzahl Links",
SUM(el_to rlike '[?&]utm_id=') AS "utm_id",
SUM(el_to rlike '[?&]utm_source=') AS "utm_source",
SUM(el_to rlike '[?&]utm_medium=') AS "utm_medium",
SUM(el_to rlike '[?&]utm_campaign=') AS "utm_campaign",
SUM(el_to rlike '[?&]utm_term=') AS "utm_term",
SUM(el_to rlike '[?&]utm_content=') AS "utm_content",
SUM(el_to rlike '[?&]utm_referrer=') AS "utm_referrer",
SUM(el_to rlike '[?&]utm_email=') AS "utm_email",
SUM(el_to rlike '[?&]gclid=') AS "gclid",
SUM(el_to rlike '[?&]gclsrc=') AS "gclsrc",
SUM(el_to rlike '[?&]dclid=') AS "dclid",
SUM(el_to rlike '[?&]_r=') AS "_r",
SUM(el_to rlike '[?&]fbclid=') AS "fbclid",
SUM(el_to rlike '[?&]fbc=') AS "fbc",
SUM(el_to rlike '[?&]fbp=') AS "fbp",
SUM(el_to rlike '[?&]oly_enc_id=') AS "oly_enc_id",
SUM(el_to rlike '[?&]oly_anon_id=') AS "oly_anon_id",
SUM(el_to rlike '[?&]__s=') AS "__s",
SUM(el_to rlike '[?&]vero_id=') AS "vero_id",
SUM(el_to rlike '[?&]_hsenc=') AS "_hsenc",
SUM(el_to rlike '[?&]mkt_tok=') AS "mkt_tok",
SUM(el_to rlike '[?&]mc_eid=') AS "mc_eid",
SUM(el_to rlike '[?&]traffic_type=') AS "traffic_type",
SUM(el_to rlike '[?&]srcc=') AS "srcc",
SUM(el_to rlike '[?&]utm_v=') AS "utm_v",
SUM(el_to rlike '[?&]PHPSESSID=') AS "PHPSESSID",
SUM(el_to rlike '[?&]redirect=no') AS "redirect=no",
SUM(el_to rlike '[?&]noredirect=no') AS "noredirect=no",
SUM(el_to rlike '[?&]traffic_id=.*&traffic_type=') AS "traffic_id & traffic_type",
SUM(el_to rlike '[?&]traffic_type=.*traffic_id=') AS "traffic_type & traffic_id",
SUM(el_to rlike '[?&]_r=.*&ref=') AS "_r & ref",
SUM(el_to rlike '[?&]ref=.*&_r=') AS "f & _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.
All SQL code is licensed under CC0 License.