use fawiki_p;

select concat('[[user:',user_name,']]'), count(*)

from user

join logging

on log_user = user_id

where log_type ='patrol' and log_action='patrol'

group by log_user, log_action order by 2 desc;