Sürüm kontrolü

SQL

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 20231201000000 AND 20240102000000
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 20231201000000 AND 20240102000000
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 20231201000000 AND 20240102000000
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;
SQL

Checking query status...
