Einwegsocken identifizieren

SQL

SELECT nachher.rev_actor, nachher.rev_page, SUM(CAST(nachher.rev_len AS SIGNED) - CAST(vorher.rev_len AS SIGNED))
  FROM revision AS vorher, revision as nachher
 WHERE vorher.rev_id = nachher.rev_parent_id
   AND vorher.rev_page = nachher.rev_page
 GROUP BY rev_actor, rev_page
 LIMIT 10;
SET @MAX_NEUE_ARTIKEL = 3;
SET @MAX_AKTIVE_TAGE = 10; # Prozentanteil aktive Tage zwischem 1. und letzten Edit im ANR
/*WITH Neuanlagen AS
    (SELECT rev_actor AS neu_actor, COUNT(*) AS neu_artikel, SUM(rev_len) as neu_len
       FROM revision, page
      WHERE rev_parent_id = 0 # Neuanlage
        AND rev_page = page_id
        AND page_namespace = 0 # ANR
        AND NOT EXISTS (SELECT 1 # keine BKS
                          FROM page_props
                         WHERE pp_page = page_id
                           AND pp_propname = 'disambiguation'
                       )
      GROUP BY rev_actor
     HAVING COUNT(*) <= @MAX_NEUE_ARTIKEL
    ),
     AktiveTage AS
    (SELECT rev_actor AS akt_actor, COUNT(DISTINCT(SUBSTRING(rev_timestamp, 1, 8))) AS akt_tage,
            MIN(SUBSTRING(rev_timestamp, 1, 8)) AS akt_erster,
            MAX(SUBSTRING(rev_timestamp, 1, 8)) AS akt_letzter,
            DATEDIFF(regexp_replace(MAX(SUBSTRING(rev_timestamp, 1, 8)), '^(....)(..)(..)$', '\\1-\\2-\\3'),
                     regexp_replace(MIN(SUBSTRING(rev_timestamp, 1, 8)), '^(....)(..)(..)$', '\\1-\\2-\\3')) AS akt_diff
       FROM revision, page
      WHERE rev_page = page_id
        AND page_namespace = 0 # ANR
        AND NOT EXISTS (SELECT 1 # keine BKS
                          FROM page_props
                         WHERE pp_page = page_id
                           AND pp_propname = 'disambiguation'
                       )
      GROUP BY rev_actor
    )
SELECT user_name, neu_artikel, neu_len, akt_tage, akt_diff, akt_erster, akt_letzter, ROUND(akt_tage / akt_diff * 100, 1) AS "Prozent Aktiv"
  FROM user, actor, Neuanlagen, AktiveTage
 WHERE akt_actor = actor_id
   AND neu_actor = actor_id
   AND actor_user = user_id
   AND akt_tage / akt_diff <= @MAX_AKTIVE_TAGE / 100
 LIMIT 500;*/
SQL

Checking query status...
