مستخدمو الشهر الأكثر نشاطا بعدد التعديلات خلال فترة

SQL

SELECT
CONCAT("[[مستخدم:",actor_name,"|",actor_name,"]]") AS "المستخدم",
SUM(CASE WHEN rev_timestamp BETWEEN 20240203000000 AND 20240803000000 THEN 1 ELSE 0 END) AS recent_user_editcount,
COUNT(rev_id) AS user_editcount
FROM revision
	/*INNER JOIN user ON  user_id=rev_user /* ربط جدول المستخدمين بجدول الأفعال*/
	INNER JOIN actor on rev_actor = actor_id

	WHERE rev_timestamp >= 20240000000000
GROUP BY actor_name
ORDER BY recent_user_editcount DESC
LIMIT 100;

SQL

Checking query status...