(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_name #actor.actor_user, rev.rev_timestamp
  FROM revision rev
  INNER JOIN actor ON actor.actor_id = rev_actor
  WHERE actor_user IS NOT NULL
  GROUP BY actor.actor_user
  #ORDER BY log_timestamp DESC #De meest recente bovenaan
  LIMIT 100
  
/*) as raw_list
GROUP BY raw_list.loguser
ORDER BY COUNT(1) DESC*/
SQL

Checking query status...
