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;

​