قائمة المستخدمين الأكثر مراجعة للمقالات في يوم ويكيبيديا العربية 19

SQL

use arwiki_p;
SELECT concat('[[مستخدم:',actor_name,'|',actor_name,']]') AS "المستخدم", COUNT(*) AS "عدد المقالات"
FROM revision r
INNER JOIN actor ON r.rev_actor = actor.actor_id
INNER JOIN page p on r.rev_page = p.page_id
WHERE p.page_namespace =0 and p.page_is_redirect =0 and r.rev_timestamp between 2023729000000 and 20230730000000
and r.rev_parent_id =0
AND p.page_id not in (select log_page from logging where log_type like "delete" AND logging.log_timestamp between 20200711000000 and 20200712000000)
GROUP BY actor_name
ORDER BY COUNT(*) DESC;

SQL

Checking query status...