contenttranslation check

SQL

use fiwiki_p;

select 
	t.log_user_text, 
    t.user_registration, 
    tt.max_rev_ts as last_edit,
    (datediff(str_to_date(l1.log_timestamp, "%Y%m%d%H%i%S"), str_to_date(user_registration, "%Y%m%d%H%i%S")) as survival_age,
    t.log_title,
    t.log_comment
from (
select 
  	l1.log_id, 
  	l1.log_timestamp, 
  	user_registration,   	 
  	l1.log_user_text, 
  	l1.log_title, 
    l1.log_comment,
    l1.log_page,    
    l1.log_user
  from 
  	user, 
  	logging_compat as l1  	
  	LEFT JOIN change_tag ON ct_log_id=l1.log_id 
  	LEFT JOIN change_tag_def ON ctd_id=ct_tag_id     
  where 
  	user_registration > 20200000000000 
  	and user_registration<20210000000000 
  	and user_editcount>0 
  	and l1.log_user=user_id 
  	and l1.log_namespace=0 
  	and l1.log_type="create" 
  	and l1.log_id>11602246 
  	and l1.log_id<12371120
    and (datediff(str_to_date(l1.log_timestamp, "%Y%m%d%H%i%S"), str_to_date(user_registration, "%Y%m%d%H%i%S"))<=1)
    and (ctd_name="contenttranslation")
  group by log_id
) 
as t LEFT JOIN (
   select 
  	user_name, 
    user_id,
  	max(rev_timestamp) as max_rev_ts 
  from 
  	user, 
  	revision_compat 
  where 
  	user_registration > 20200000000000 
  	and user_registration<20210000000000 
  	and user_editcount>0 
  	and rev_user=user_id 
  	and rev_id>18630374 
  group by user_id
) as tt ON t.log_user=tt.user_id
SQL

Checking query status...
