Editors of Abidjan article in Italian Wikipedia

SQL

SET @pageTitle = "Air Côte d'Ivoire";
SET @pageId = (SELECT page_id FROM page WHERE page_title = REPLACE(@pageTitle, "_", " "));

SELECT gu_name, gu_home_db, gu_registration, gug_group, 
  ( SELECT count(rev_actor) 
      FROM revision_userindex 
      WHERE rev_actor = actor_id 
      AND rev_timestamp > (now() - INTERVAL 15 DAY + 0) 
  ) AS total 
FROM centralauth_p.globaluser 
LEFT JOIN actor 
    ON actor_name = gu_name 
LEFT JOIN centralauth_p.global_user_groups 
    ON gug_user = gu_id 
WHERE gu_name IN ( 
  SELECT actor_name FROM revision_userindex 
  LEFT JOIN actor ON rev_actor = actor_id 
  WHERE rev_page = @pageId 
) 
LIMIT 10;

SQL

Checking query status...