USE plwiki_p;

​

-- note! only works from about 20080406221043

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

FROM logging

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

GROUP BY log_title

ORDER BY 2 ASC

;