USE fawiki_p;

SELECT  u1.user_name as UserName,u1.user_editcount as editCount from 

(select  rev_id,rev_comment from revision where (rev_comment like '%واگردان%'  or rev_comment like '%خنثی%') and rev_timestamp>20160101000000) as rev1

join (select  user_name,user_editcount from user) as u1 where

rev1.rev_comment like concat('%|',u1.user_name,']]%') and rev1.rev_id in (select  page_id from page where page_namespace=0) limit 100;