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
left join user_groups on ug_user = user_id and ug_group="editor"
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...
