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