Einwegsocken identifizieren

SQL

SET @MAX_NEUE_ARTIKEL = 3;
WITH Neuanlagen AS
    (SELECT rev_actor AS neu_actor, COUNT(*) AS neu_artikel
       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
    )
SELECT user_name, neu_artikel
  FROM user, actor, Neuanlagen
 WHERE neu_actor = actor_id
   AND actor_user = user_id
 #LIMIT 500;
SQL

Checking query status...
