comment_text and tags

SQL

select
convert(a.actor_name using utf8mb4) actor_name,
date_format(ru.rev_timestamp, '%Y-%m-%dT%T') rev_timestamp,
case
when p.page_namespace = 0 then '(Main/Article)'
when p.page_namespace = 1 then 'Talk'
when p.page_namespace = 2 then 'User'
when p.page_namespace = 3 then 'User talk'
when p.page_namespace = 4 then 'Wikipedia'
when p.page_namespace = 5 then 'Wikipedia talk'
when p.page_namespace = 6 then 'File'
when p.page_namespace = 7 then 'File talk'
when p.page_namespace = 8 then 'MediaWiki'
when p.page_namespace = 9 then 'MediaWiki talk'
when p.page_namespace = 10 then 'Template'
when p.page_namespace = 11 then 'Template talk'
when p.page_namespace = 12 then 'Help'
when p.page_namespace = 13 then 'Help talk'
when p.page_namespace = 14 then 'Category'
when p.page_namespace = 15 then 'Category talk'
when p.page_namespace = 100 then 'Portal'
when p.page_namespace = 101 then 'Portal talk'
when p.page_namespace = 118 then 'Draft'
when p.page_namespace = 119 then 'Draft talk'
when p.page_namespace = 710 then 'TimedText'
when p.page_namespace = 711 then 'TimedText talk'
when p.page_namespace = 828 then 'Module'
when p.page_namespace = 829 then 'Module talk'
else null
end as namespace,
replace(convert(p.page_title using utf8mb4),'_',' ') page_title,
group_concat(ctd.ctd_name) tags,
char_length(if(substring(cr.comment_text,1,2) = '/*', concat(substring_index(cr.comment_text, '/*', 1), trim(substring_index(cr.comment_text, '*/', -1))), cr.comment_text)) n_chars,
convert(if(substring(cr.comment_text,1,2) = '/*', concat(substring_index(cr.comment_text, '/*', 1), trim(substring_index(cr.comment_text, '*/', -1))), cr.comment_text) using utf8mb4) comment_text
from
actor a
join revision_userindex ru on ru.rev_actor = a.actor_id
join page p on p.page_id = ru.rev_page
join comment_revision cr on cr.comment_id = ru.rev_comment_id
left join change_tag as ct ON ct.ct_rev_id = ru.rev_id
left join change_tag_def ctd on ct.ct_tag_id = ctd.ctd_id
where
a.actor_name in (
  'ABHammad', 
  'OdNahlawi', 
  'O.maximov', 
  'Shoogiboogi', 
  'Galamore', 
  'האופה', 
  'Minden500', 
  'Owenglyndur', 
  'EnfantDeLaVille', 
  'UnspokenPassion', 
  'PeleYoetz', 
  'EliasAtonakos', 
  'Rajoub570'
) 
group by 1,2,3,4,6,7
having n_chars > 0
order by 1,2
SQL

Checking query status...
