SQL
x
USE trwiki_p;
SELECT CONCAT('[[Kullanıcı:',actor_name,'|',actor_name,']]') AS "Kullanıcı", COUNT(log_actor) AS "Approve" FROM actor
JOIN logging ON (actor.actor_id=logging.log_actor)
WHERE log_timestamp BETWEEN 20210101000000 AND 20210131000000
AND log_action IN ('approve', 'approve2', 'approve-i', 'approve2-i')
GROUP BY actor_name
ORDER BY COUNT(log_actor) DESC
LIMIT 20;
SELECT CONCAT('[[Kullanıcı:',actor_name,'|',actor_name,']]') AS "Kullanıcı", COUNT(log_actor) AS "Approve & Unapprove" FROM actor
JOIN logging ON (actor.actor_id=logging.log_actor)
WHERE log_timestamp BETWEEN 20210101000000 AND 20210131000000
AND log_action IN ('approve', 'approve2', 'approve-i', 'approve2-i', 'unapprove', 'unapprove2')
GROUP BY actor_name
ORDER BY COUNT(log_actor) DESC
LIMIT 20;
SELECT CONCAT('[[Kullanıcı:',actor_name,'|',actor_name,']]') AS "Kullanıcı", COUNT(log_actor) AS "Approve & Unapprove & Revert" FROM actor
JOIN logging ON (actor.actor_id=logging.log_actor)
WHERE log_timestamp BETWEEN 20210101000000 AND 20210131000000
AND log_action IN ('approve', 'approve2', 'approve-i', 'approve2-i', 'unapprove', 'unapprove2', 'revert')
GROUP BY actor_name
ORDER BY COUNT(log_actor) DESC
LIMIT 20;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.