use tewiki_p;

​

  select 

    l1.log_id, 

    l1.log_timestamp, 

    user_registration, 

    (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) as diff, 

    l1.log_user_text, 

    l1.log_title, 

    l1.log_comment,

    l1.log_page,

    rev_id, 

    ar_rev_id, 

    rev_len, 

    ar_len, 

    (ctd_name="visualeditor") as visualeditor, 

    (ctd_name="mobile edit") as mobile_edit, 

    (ctd_name="contenttranslation") as contenttranslation   

  from 

    user, 

    logging_compat as l1

    LEFT JOIN revision ON l1.log_page=rev_page AND l1.log_actor=rev_actor 

    LEFT JOIN archive ON l1.log_title=ar_title AND ar_namespace=0 AND ar_actor=l1.log_actor AND ar_timestamp>=l1.log_timestamp 

    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>00000000 

    and l1.log_id<1299371120

    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)

​

​