Untitled query #67890

SQL

SELECT COUNT(*) AS "# Moves", actor_name as "Mover"
FROM logging
  WHERE log_type = 'move'
JOIN actor_revision ON actor_id = log_actor
WHERE log_parent_id = 0
  AND log_timestamp >= '20220829'
GROUP BY actor_name
HAVING COUNT(*) >= 0
ORDER BY COUNT(*) DESC;
/* select log_id,log_timestamp,(select actor_name from actor where log_actor=actor_id) as "user",
log_title,log_params,(select comment_text from comment where comment_id=log_comment_id) as "summary"
from logging where log_type="move" and log_namespace=3 and log_params not like "%User talk:%" and log_title not like "%/%"
order by log_timestamp desc limit 100; [[Quarry 36671 by Pppery [[Original: 67105 by BilledMammal*/
SQL

Checking query status...
