CREATE TEMPORARY TABLE admin_stats (

    admin_id                int,

    admin_name              varchar(255),

    first_admin_dt          bigint,

    registration_dt         bigint,

    first_edit_dt           bigint,

    edits_pre_sysop         bigint,

    gender      varchar(100),

);

​

INSERT INTO admin_stats (admin_name, first_admin_dt, admin_id)

SELECT log_title, min(log_timestamp), 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

;

​

SELECT * from admin_stats;