Einwegsocken identifizieren

SQL

SELECT SUBSTR(rev_timestamp, 0, 8) FROM revision limit 3;
SET @MAX_NEUE_ARTIKEL = 3;
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(SUBSTR(rev_timestamp, 0, 8))) AS akt_tage
       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
  FROM user, actor, Neuanlagen
 WHERE neu_actor = actor_id
   AND actor_user = user_id
 LIMIT 500;
SQL

Checking query status...
