Untitled query #23618

SQL

SELECT * FROM afwiktionary_p.revision_userindex LIMIT 100;
SELECT
 DAY,
 ACTIONS
 FROM (SELECT
   SUBSTR(log_timestamp, 1, 8) AS DAY,
   SUM(log_action = 'create') AS ACTIONS
   FROM logging
   GROUP BY DAY
   ORDER BY log_id DESC
   LIMIT 30)
   AS logs;
SELECT
  DATE(CONCAT(YEAR(rev_timestamp),"-",MONTH(rev_timestamp),"-",DAY(rev_timestamp))) AS day, rev_user_text,
  COUNT(rev_timestamp) AS revisions, sum(rev_len) "Bytes added"
FROM afwiktionary_p.revision_userindex
-- WHERE rev_user_text = 'Naudefj'
GROUP BY day, rev_user_text
order by day desc
limit 10;
SQL

Checking query status...
