Ostatni redaktorzy

SQL

use plwiki_p;

select nadawacze.user_name AS nadawacz, replace(log_title, '_', ' ') as redaktor_nazwa, log_params from logging
left join actor on actor_id = log_actor
left join user nadawacze on nadawacze.user_id = actor_user
left join user redaktorzy on redaktorzy.user_name = replace(log_title, '_', ' ')
left join user_groups on ug_user = redaktorzy.user_id and ug_group="editor"
where
log_type = "rights" and log_timestamp > 20200101000000
and log_params like "%editor%"
and ug_group IS NOT null
order by log_timestamp desc;
SQL

Checking query status...
