Untitled query #48191

SQL

use tewiki_p;

set @dbname = 'tewiki';

set @ct_tag_id = (
  select
    ctd_id
  from
    change_tag_def
  where
    ctd_name = 'contenttranslation'
);




  select
    LEFT(rev_timestamp,6) as month,
    actor_name,
    count(rev_actor)
  from
    change_tag,
    page,
    revision,
    actor
  where
    page_id = rev_page and
    page_namespace = 0 and
    rev_id = ct_rev_id and
    rev_parent_id = 0 and
    actor_id=rev_actor and
    ct_tag_id = @ct_tag_id and
    actor_name in ("Nrgullapalli","Vemurione","T.sujatha","Arjunaraoc","Veera.sj","Apbook","Vmakumar","C.Chandra Kanth Rao","Kasyap","దేవుడు")
   LIMIT 500;
SQL

Checking query status...
