TEST 4 - Quarry

SQL

SET @lang = 'ar';
SELECT
 actor_name,
 COUNT(*) AS total,
 SUM(comment_text LIKE '/* wbsetlabel-add:%') AS added,
 SUM(comment_text LIKE '/* wbsetlabel-set:%') AS changed,
 SUM(comment_text LIKE '/* wbsetlabel-remove:%') AS removed,
 DATE_FORMAT(MIN(rev_timestamp), "%Y-%m-%d") AS since,
 DATE_FORMAT(MAX(rev_timestamp), "%Y-%m-%d") AS until
FROM
 revision
 JOIN comment ON rev_comment_id = comment_id
 JOIN actor ON rev_actor = actor_id
 JOIN page ON rev_page = page_id
WHERE
 page_namespace = 120 -- Property:
 AND (
  comment_text LIKE CONCAT('/* wbsetlabel-add:1|', @lang, ' */%')
  OR comment_text LIKE CONCAT('/* wbsetlabel-set:1|', @lang, ' */%')
  OR comment_text LIKE CONCAT('/* wbsetlabel-remove:1|', @lang, ' */%')
 )
GROUP BY actor_name
ORDER BY COUNT(*) DESC
LIMIT 10;
SQL

Checking query status...
