(empty) - Quarry

SQL

use nlwiki_p;

# Some stats, try 2
/*SELECT raw_list.loguser,
(SELECT COUNT(1) WHERE isAnoniem = 1) as anoniemN,
(SELECT COUNT(1) WHERE isAnoniem = 0) as gebruikerN,
(SELECT COUNT(1)) as totaalN
FROM
(*/
/*  SELECT COUNT(*), actor.actor_name #actor.actor_user, rev.rev_timestamp
  FROM revision rev
  INNER JOIN actor ON actor.actor_id = rev_actor AND actor_user IS NOT NULL
  #WHERE 
  GROUP BY actor.actor_user
  HAVING COUNT(*) > 25

  #ORDER BY log_timestamp DESC #De meest recente bovenaan
  LIMIT 100*/
  
/*) as raw_list
GROUP BY raw_list.loguser
ORDER BY COUNT(1) DESC*/

SELECT rev.*
  FROM revision rev
  GROUP BY rev_actor
  LIMIT 100
SQL

Checking query status...
