translations on meta empty, with top editor info

Fork of transltions on meta empty, top editor is a translate admin by Base

This query is marked as a draft This query has been published by Base.

SQL

select CONCAT("[[Translations:",page_title,"]]"),
CONCAT("{{Translations:",page_title,"}}"),
rev_user,
(
  select GROUP_CONCAT(ug_group SEPARATOR ", ")
  from metawiki_p.user_groups
  where ug_user = rev_user
  group by ug_user
)
  
from metawiki_p.page
join metawiki_p.revision_userindex
on metawiki_p.page.page_namespace = 1198
and metawiki_p.page.page_len = 0
and rev_id = page_latest

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...