Ostatni redaktorzy

SQL

use plwiki_p;

select user_name, log_title, log_params from logging
left join actor on actor_id = log_actor
left join user on user_id = actor_user
where
log_type = "rights" and log_timestamp > 20200101000000
and log_params like "%editor%"
order by log_timestamp desc;
/*
select user_name, log_title, log_params from logging
left join actor on actor_id = log_actor
left join user on user_id = actor_user
where
log_type = "rights" and log_timestamp > 20190624000000 and log_timestamp < 20190626000000
and log_params like "%editor%"
order by log_timestamp desc;
*/
SQL

Checking query status...
