select 

  concat("[[User:", page_title, "]]") page, 

  concat("{{userlinks|", user_name, "}}") editor, 

  concat("[https://en.wikipedia.org/w/index.php?diff=", rev_id, "&oldid=", rev_parent_id, " diff]" ) diff 

from 

  page 

  join revision on rev_id = page_latest 

  join user on user_id = rev_user 

where 

  page_namespace = 2 

  AND page_title != REPLACE(rev_user_text, " ", "_") 

  and user_editcount < 25 

  and user_registration > 20180115000000 

  and page_title NOT LIKE "%/%" 

  AND user_id not in (

    SELECT 

      ipb_user 

    from 

      ipblocks 

    where 

      ipb_user = user_id

  );

​