No TA Action@commons exc.admin

SQL

USE commonswiki_p;
SELECT
 CONACT("* \[https://commons.wikimedia.org/w/index.php?title=Special%3ALog&type=pagetranslation&user=", user_name, "\]")
FROM user_groups
INNER JOIN user
ON ug_user=user_id
WHERE ug_group = "translationadmin"
AND user_id NOT IN
  (
   SELECT DISTINCT
   log_user AS q1
   FROM logging
   WHERE log_type = "pagetranslation"
   AND log_timestamp > DATE_FORMAT(DATE_ADD(NOW(), INTERVAL -365 DAY), '%Y%m%d%H%i%s')
   )
AND user_id NOT IN
  (
   SELECT
   ug_user AS ugsysop
   FROM user_groups
   WHERE ug_group = "sysop"
   );
SQL

Checking query status...
