-- USE plwiki_p;

​

-- note! only works from about 20060815191823

SELECT log_title, min(log_timestamp), min(log_params), min(user_id)

FROM logging l

LEFT JOIN user u ON user_name=REPLACE(log_title,'_',' ')

WHERE log_type = 'rights' AND log_namespace = '2' AND log_params like '%sysop%'

GROUP BY log_title

ORDER BY 2 ASC

;

​