select into a variable

SQL

use tewiki_p;

set @dbname = 'tewiki';

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




  select

    actor_name,
    LEFT(rev_timestamp,8) as date,
    CONCAT("[[",page_title,"]]") as pagename,ct_id
  from
    change_tag,
    page,
    revision,
    actor
  where
    page_id = rev_page and
    page_namespace = 0 and
    rev_id = ct_rev_id and
    actor_id=rev_actor and
    ct_tag_id = @ct_tag_id and
    actor_name in ("Nagarani Bethi","Vemurione","T.sujatha","Arjunaraoc","Veera.sj","Apbook","Vmakumar","C.Chandra Kanth Rao","Kasyap","దేవుడు")
   LIMIT 500;
SQL

Checking query status...
